82Views4Replies

Author Options:

ERROR 500 when trying to edit iBle or send PM Answered

. C&Pd this after clicking Send to reply to a PM. First line is the same when I try to edit an unpublished iBle (rest may be the same, not sure). Been happening a lot.

ERROR 500: org.hibernate.exception.DataException: Could not execute JDBC batch update

Exception

org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.instructables.transaction.TransactionHandler.invoke(TransactionHandler.java:117)
at $Proxy13.sendReply(Unknown Source)
at com.instructables.webapp.edit.ComposeMessageAction.process(ComposeMessageAction.java:130)
at com.instructables.servlet.ActionServlet.process(ActionServlet.java:178)
at com.instructables.servlet.ActionServlet.doPost(ActionServlet.java:124)
at com.instructables.webapp.edit.EditServlet.doPost(EditServlet.java:173)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
at com.instructables.filter.SecurityFilter.doFilter(SecurityFilter.java:211)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.instructables.filter.HibernateSessionRequestFilter.doFilter(HibernateSessionRequestFilter.java:70)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'subject' at row 1
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 27 more

Tags:edit500

Discussions

0
None
NachoMahma

10 years ago

. Rachel figured it out! . For the PM problem, that occurs when the title is too long. In my case, caused by all the Re:'s that were added by the system. . Not being able to edit an iBle was caused by Zachninme's No K'nex script for GreaseMonkey. If I erase "?ALLSTEPS" from the end of the URL, everything works. . Thanks, Rachel!

0
None
NachoMahma

10 years ago

. I've been able to send 3-4 PMs without problems, but still can't edit my iBle. :(

0
None
NachoMahma

10 years ago

. Egads! It's getting worse. Now I can't edit the iBle at all. Click "edit" on my You page - 500. View iBle and click "edit" - 500. :( . . BTW, Win XP Pro SP3, Firefox 3.0.3, Java Std Ed 6 v1.6.0

0
None
Plasmana

10 years ago

I often get a problem like all of that when I try to undelete my accidentally deleted emails on instructables...