[opencms-dev] Error with ADE Recent List

[Tobias Karrer]

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)