[xwiki-users] MySQL5?

jeremi joslin jeremi at xwiki.com
Thu Jan 11 18:51:55 CET 2007 

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 at 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(RequestProcessor.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(ApplicationFilterChain.java:252)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>          at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>          at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>          at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.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:148)
>          at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>          at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>          at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>          at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.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(ServerPreparedStatement.java:828)
>          at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
>          at
> org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
>          at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
>          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(AbstractEntityPersister.java:2048)
>          at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.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(DefaultFlushEventListener.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:106)
>          at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:561)
>          at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.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(RequestProcessor.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(ApplicationFilterChain.java:252)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>          at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:121)
>          at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>          at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>          at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>          at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.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:148)
>          at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>          at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>          at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>          at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.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 at objectweb.org
> mailing list.
> To unsubscribe:
> mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>


-- 
jeremi

More information about the users mailing list