Error setting up postgresql database (Import failed - Error executing update for SQL Statement)

Question

At the setup restore progress page, an error message appeared:

Import failed. Check your server logs for more information. com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Confluence Create Content Plugin(com.atlassian.confluence.plugins.confluence-create-content-plugin) #9.1.4 (table AO_54C900_C_TEMPLATE_REF):Error executing update for SQL statement 'CREATE TABLE "AO_54C900_C_TEMPLATE_REF" ( "CB_INDEX_PARENTID" INTEGER, "CB_PARENTID" INTEGER, "ID" SERIAL, "NAME" VARCHAR(255), "PARENT_ID" INTEGER, "PLUGIN_CLONE" BOOLEAN, "PLUGIN_MODULE_KEY" VARCHAR(255), "TEMPLATE_ID" BIGINT, "UUID" VARCHAR(255), )'

I am trying to set up confluence 6.14.1 as a new installation migrating from a trial database.

Diego_88dj6o · Answer

Hello there!
So Kuan, I have seen this error previously and there are a few things we can check to fix it. 
First, make sure that you are restoring the backup into a compatible Confluence version. Ideally, a site backup is restored into an instance with the same version as the origin instance. 
Also check that your database version is compatible with your Confluence version and that all permissions are correct. My guess is that you are using MySQL for this setup. With this in mind, you can take a look here:

* Database Setup For MySQL

If you are not using MySQL, you can select your version here:

* Database Configuration

I am suggesting you to look into your database setup and permissions due to the fact that the other case which I dealt with was solved by restoring the database to a previous point in time. This indicates that there was some problem with the database setup. 
Be sure to have a compatible database driver as well. You can get them here:

* Database JDBC Drivers

Our next steps are:

* Check database version
* Check origin Confluence version
* Check database drivers

Let us hear from you Kuan! Looking forward to your reply.