<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Does someone from Alkacon know how to
      solve the problem?<br>
      <br>
      Am 09.01.2013 14:14, schrieb Tobias Karrer:<br>
    </div>
    <blockquote
cite="mid:http:%2F%2Fpermalink.gmane.org%2Fgmane.comp.cms.opencms.devel%2F37487@localhost.localdomain"
      type="cite"><base
        href="http://permalink.gmane.org/gmane.comp.cms.opencms.devel/37487">
      <title>Error with ADE Recent List</title>
      <base
        href="http://permalink.gmane.org/gmane.comp.cms.opencms.devel/37487">
      <pre>Hi all,

got an error (ADE popup, message see below) on a customers OpenCms 
8.0.4, when he wants to edit a container of a container page.
Clicking on "OK" closes the popup and saves the changes, but how to get 
rid of this error popup?

Regards,
Tobias

Error message:

Error writing user "xyz".
Reason:An SQL error occurred when executing the following query: 
com.mysql.jdbc.PreparedStatement< at >6066629e: UPDATE CMS_USERDATA SET 
DATA_VALUE =** STREAM DATA **, DATA_TYPE='java.lang.String' WHERE 
USER_ID ='e08ac4f9-66b5-11e1-89b9-67fb2a39e333' AND DATA_KEY 
='ADE_RECENT_LIST'.


Ticket Id: 1357736186920
org.opencms.db.CmsDbSqlException: Error writing user "xyz".
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:334)
org.opencms.db.CmsDbContext.report(CmsDbContext.java:286)
org.opencms.db.CmsSecurityManager.writeUser(CmsSecurityManager.java:6461)
org.opencms.file.CmsObject.writeUser(CmsObject.java:3804)
org.opencms.ade.configuration.CmsADEManager.saveRecentList(CmsADEManager.java:695)
org.opencms.ade.containerpage.CmsContainerpageService.addToRecentList(CmsContainerpageService.java:148)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.opencms.gwt.CmsGwtService.service(CmsGwtService.java:191)
org.opencms.main.OpenCmsCore.invokeGwtService(OpenCmsCore.java:1537)
org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:150)
org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:679)org.opencms.main.OpenCmsCore.invokeGwtService(OpenCmsCore.java:1537)
org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:679)
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev">http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev</a>




</pre>
    </blockquote>
    <br>
  </body>
</html>