[opencms-dev] Error with ADE Recent List

[Tobias Herrmann]

Hi Tobias,

sorry for the late reply. There was an issue with the recent list getting to big to be saved in the additional user infos. Best option is to wait a few days and update to version 8.5.1 once it is released.
A temporary solution is to manually clear the recent list by editing the effected user. Edit the additional info and remove the entry starting with 'ADE_RECENT_LIST='. This will clear the users recent list.

Greetings, Tobias

--

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com
http://www.opencms.org

Am 16.01.2013 10:06, schrieb Tobias Karrer:
> Does someone from Alkacon know how to solve the problem?
>
> Am 09.01.2013 14:14, schrieb Tobias Karrer:
>> Error with ADE Recent List
>> 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
>> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>>
>>
>>
>>
>
>
>
> _______________________________________________
> 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
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>