Hi Hamster, On 8 Oct 2015 at 12:46:44, Hamster ([email protected](mailto:[email protected])) wrote:
We are running XWiki 5.4.3
We have upgraded the server on which XWiki runs, but we now get an error when we want to delete a page:
First, could you tell us to what version you are upgrading?
Error number 0 in 3: Exception while hibernate execute com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1266) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1346) at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.saveToRecycleBin(XWikiHibernateRecycleBinStore.java:123) at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3801) at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:3776) at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5521) at com.xpn.xwiki.XWiki.deleteAllDocuments(XWiki.java:5510) at com.xpn.xwiki.web.DeleteAction.action(DeleteAction.java:93)
[snip]
Caused by: java.sql.SQLException: Field 'XDD_ID' doesn't have a default value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
[snip]
What could be the cause? Where should we start looking?
This looks like some error of upgrading the schema. Are you sure that you have enabled data migration: xwiki.store.migration=1 xwiki.store.migration.databases=all Thanks -Vincent