errors when configure the system administrator account for this Confluence installation

dizhihao

Oops - an error has occurred

when configure the system administrator account for this Confluence installation.  I choose 'Manage Users and Groups within Confluence'. 

 

Cause

com.atlassian.core.exception.InfrastructureException: Failed to create default group: confluence-users
    at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroups(SetupAdministrator.java:89)

caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:230)

caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence_db.cwd_application_attribute' doesn't exist
    at jdk.internal.reflect.GeneratedConstructorAccessor340.newInstance(Unknown Source)

Evan Underwood-Harley_yyu64c

caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence_db.cwd_application_attribute' doesn't exist

 

This suggests the database hasn't been setup correctly and all the required tables could not be created. Check the permissions on the database does your confluence database user have all the correct permissions on the database as per - https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

 

You may need to drop the database and re-create it as per the above link to get this working correctly.

 

Regards

Evan