Unable to use Confluence after setup

Question

Hi,

I have set up Confluence on my server and after putting MySQL credentials, I do get a message about setting up the database. It did create 81 tables. However, then I got a "System Error" page and I am stuck now.

I deleted the folders to do a fresh installation. The issue still persists.

Can anyone please help?

Find more details:

Cause

java.lang.reflect.UndeclaredThrowableException
    at com.sun.proxy.$Proxy246.permissionExists(Unknown Source)

caused by: java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

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

Sanil Gajadhar_jr75o7 · Answer

Hello,

In fact, I was installing version 7.8.0 but it was keeping failing during the database setup. After creating around 81 tables, then the error was appearing.

Finally, I installed the version 7.4.4 which installed successfully. Once installed, I then upgraded to 7.8.0

Diego_88dj6o · Answer

Hello there @Sanil Gajadhar ! Would you mind sharing the solution to your case with the community?

Maybe someone faces the same problem in the future and your question will be able to help them!

Let us hear from you.

Sanil Gajadhar_jr75o7 · Answer

The problem has been solved. Thank you.