This happens with an existing wiki that has it's database exported and imported into a new MySQL5 database (same export works using 4.1.14). I'll have access to the server again in the morning and I can try this again. Thanks! -----Original Message----- From: jeremi23@gmail.com [mailto:jeremi23@gmail.com] On Behalf Of jeremi joslin Sent: 11 January 2007 17:52 To: xwiki-users@objectweb.org Subject: Re: [xwiki-users] MySQL5? Hi, have you tried with an empty wiki? it means there is a problem because there is no default value set for the field XWD_ARCHIVE. You can upgrade your schema with "alter table"... to set a default value. jeremi On 1/11/07, Esbach, Brandon <Esbachb@tycoelectronics.com> wrote:
Using MySQL 5.0.27 on a new test box, with XWiki10B2 and getting the following message every time I try to create a new document:
Does not seem to happen for MySQL 4.1 at all. Is this a bug or is there a config I need to implement for my MySQL version?
Error number 3201 in 3: Exception while saving document Main.TesTsts Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
saving document Main.TesTsts Wrapped Exception: Could not execute JDBC batch update at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore .java:310)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96 )
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90 )
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:767) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:111) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:120) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:143) at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86 9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:684)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
java.sql.BatchUpdateException: Field 'XWD_ARCHIVE' doesn't have a default value at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatem ent.java:828)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState ment.java:294)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState ment.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5 8)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195 )
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java :91)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java :86)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher .java:171)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn tityPersister.java:2048)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn tityPersister.java:2427)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java: 51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions( AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv entListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:10 6)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernat eBaseStore.java:561)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernat eBaseStore.java:539)
at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore .java:305)
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96 )
at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90 )
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:767) at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:111) at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:120) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:143) at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173)
at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86 9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:684)
at java.lang.Thread.run(Thread.java:595)
Brandon Esbach Software Engineer M/A-Com Eurotec Operations LoughMahon Technology Park, Skehard Road, Blackrock, Cork, Ireland Tel +353 21 4808305
-- You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
-- jeremi