Hi, I'm searching for weeks now, and i didn't find anything that work... I tried soooo many things without success.
My Xwiki server work fine exept one thing, the wiki creation. Every time i have this error: <http://xwiki.475771.n2.nabble.com/file/n7603193/2017-03-22_09_29_02-Cr%C3%A9er_un_nouveau_wiki_%28WikiManager.png> here the complete msg: Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/utilisateurs] Checking Hibernate mapping and updating schema if needed for wiki [utilisateurs] SQL Error: 1146, SQLState: 42S02 Table 'utilisateurs.xwikidbversion' doesn't exist Table 'utilisateurs.xwikidbversion' doesn't exist class com.xpn.xwiki.store.migration.DataMigrationException: Unable to store new data version 90000 into database utilisateurs at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:169) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1340) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.hibernate.exception.SQLGrammarException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:110) at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:423) at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doInHibernate(HibernateDataMigrationManager.java:163) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1334) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class java.sql.SQLSyntaxErrorException: Table 'utilisateurs.xwikidbversion' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115) at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826) at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034) at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1970) at com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:4984) at com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1955) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101) at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:423) at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doInHibernate(HibernateDataMigrationManager.java:163) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1334) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Fail to get the configuration document for wiki [utilisateurs]. class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [utilisateurs]. at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:104) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to set metadata to the wiki [utilisateurs]. at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:81) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.wiki.user.WikiUserManagerException: Fail to get the configuration document for wiki [utilisateurs]. at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:67) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Finished job of type [wikicreationjob] with identifier [wikicreation/createandinstall/utilisateurs] Here is the Catalina log for this action: catalinaerror.txt <http://xwiki.475771.n2.nabble.com/file/n7603193/catalinaerror.txt> Can someone help me please ? I don't know where to look anymore... I looked the hibernate file, but everything seems ok, the user used for the connexion is the MySQL root user, so he has every rights on the MySQL server... Thank you. Daniel -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193.html Sent from the XWiki- Users mailing list archive at Nabble.com.
