[ http://jira.magnolia.info/browse/MAGNOLIA-1981?page=comments#action_15459 ] Edgar Vonk commented on MAGNOLIA-1981: --------------------------------------
Ah yes, of course. Forgot about that for a minute. Thanks! > Unable to update item due to mysqlDataTruncation exception > ---------------------------------------------------------- > > Key: MAGNOLIA-1981 > URL: http://jira.magnolia.info/browse/MAGNOLIA-1981 > Project: Magnolia > Issue Type: Bug > Affects Versions: 3.0.5 > Environment: Linux Centos 5, tomcat 5.5, jdk1.5.0_09, apache 2, > mod_jk, MySQL 5 > Reporter: Edgar Vonk > Assigned To: Boris Kraft > > If we enter too much (textual) content on a certain page we get the following > exception: > {code} > ERROR info.magnolia.module.admininterface.SaveHandlerImpl 19.12.2007 > 12:30:17 -- /: unable to update item.: failed to write property state: > 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content > javax.jcr.RepositoryException: /: unable to update item.: failed to write > property state: 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content: failed to > write property state: 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content > at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1197) > at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:805) > at > info.magnolia.cms.core.HierarchyManager.save(HierarchyManager.java:525) > at > info.magnolia.module.admininterface.SaveHandlerImpl.save(SaveHandlerImpl.java:212) > at > info.magnolia.module.admininterface.DialogMVCHandler.onSave(DialogMVCHandler.java:284) > at > info.magnolia.module.admininterface.DialogMVCHandler.save(DialogMVCHandler.java:181) > at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > info.magnolia.cms.servlets.MVCServletHandlerImpl.execute(MVCServletHandlerImpl.java:96) > at info.magnolia.cms.servlets.MVCServlet.doPost(MVCServlet.java:111) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > > > > CAUSED by: > > mysqlDataTruncation: Data truncation: Data too long for column 'PROP_DATA' at > row 1 > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3374) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925) > {code} > It seems there is a limit in the datamodel for the storage of this content? > Or maybe it is a setting in our MySQL that we need to tweak? Any help is > greatly appreciated. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.magnolia.info/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
