Error Creating Space: Invalid column name 'true'.

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

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)

Cause

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.

Resolution

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.

 

  1. Perform an XML backup if you need to retain data.
  2. Stop Confluence
  3. Drop the database
  4. Create a new database. Follow the steps in Database Setup for SQL Server, to ensure the database is configured correctly.
  5. Review the Known Issues For SQL Server.
  6. Remove everything from the <confluence-home> directory
  7. Restart Confluence

(info) You will need to reconfigure the instance, including entering the license information again.

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.