Error Creating Space: Invalid column name 'true'.
症状
After installation, Confluence Administrators cannot create new Spaces. The following appears in the atlassian-confluence.log:
ERROR [http-8090-6] [atlassian.event.internal.EventPublisherImpl] invokeListeners There was an exception thrown trying to
dispatch event 'com.atlassian.confluence.event.events.content.page.PageCreateEvent@73c19912[page=page: PageName (589844),
timestamp=1341376629186]' from the invoker 'com.atlassian.event.legacy.LegacyListenerHandler$LegacyListenerInvoker@3d0c6482'.
– url: /spaces/createspace.action | userName: test| referer: http://**********:8090/dashboard.action | action: createspace
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested
exception is java.sql.SQLException: Invalid column name 'true'.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341)
at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:350)
at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParam(HibernateObjectDao.java:290)
原因
This is due to an error in the initial database configuration. If the database was set up incorrectly, Confluence cannot created the data required. It has been known to occur in SQL Server, but could happen in other databases.
ソリューション
You will lose all of your data in this process. This issue usually happens immediately after install, so it's unlikely you will have data that needs to be retained. However, if you have already created data which you would like to retain, you can perform an XML backup for import into the newly created system, or alternatively contact Support for help.
You will need to configure the database correctly, and then restart the Confluence configuration process. Since Confluence has been set up, you will need to drop and recreate the database.
- Perform an XML backup if you need to retain data.
- Confluence を停止します。
- Drop the database
- Create a new database. Follow the steps in Database Setup for SQL Server, to ensure the database is configured correctly.
- Review the Known Issues For SQL Server.
- Remove everything from the <confluence-home> directory
- Confluence を再起動します。
You will need to reconfigure the instance, including entering the license information again.