Unable to Create Pages or Spaces (The Popup Loads Forever) After Confluence Upgrade to 5.x or 6.x

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptom

When attempting to create a new page, the Create Page popup loads forever.

The following appears in the atlassian-confluence.log:

 java.sql.SQLException: Invalid column name 'PLUGINKEY'.

OR

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'pagetempla0_.PLUGINKEY' in 'field list'

OR

java.lang.IllegalArgumentException: Invalid plugin key specified

OR 

When trying to create a new space. The popup window appears and the spinning wheel keeps on rotating forever.


Sometimes, you can't find any errors in the logs, it could be related to Cause 2 to 4 discussed below.


Other symptoms and causes

Alternative 1

This appears in the log file

2015-11-17 12:06:36,537 WARN [http-nio-8090-exec-6] [common.security.jersey.XsrfResourceFilter] passesAdditionalBrowserChecks Additional XSRF checks failed for request: http://confluence.mycompany.com/rest/analytics/1.0/publish/bulk , origin: null , referrer: https://confluence.mycompany.com/rest/analytics/1.0/publish/bulk null , credentials in request: true , allowed via CORS: false

Take note of the "referrer" part of the log above. If the referrer is not null and contains a link similar to the example above, there might be issues with SSL configuration. Please see After upgrading Confluence, you are unable to create new pages or spaces for a resolution.

If the similar error above log appears in the log file but with a "referrer: null" instead of a URL link, and there is the following HTML is in the header

<meta name="referrer" content="none">

Please see Creating a page in Firefox causes the create dialog to wait indefinitely for a resolution.

Alternative 2

Refer to this: Create Page/Space Loads Forever Due To WST Timezone Set In Server Installation Date.

Cause

Cause 1:

The upgrade task to update the DB schema and migrate the page templates to XHTML was not performed during the upgrade.

Cause 2:

The confluence.server.installation.date Bandana entry is null.

OR

installationDate value initialised from the last Confluence startup is nullified as listed in atlassian-confluence.log below:

--------------------------
Build Information
--------------------------
installationDate = null

(Follow Resolution 2 below)

Cause 3:

The customer is using a SQL Server database with a JDBC driver, instead of the bundled jTDS driver. (Follow Resolution 3 below)

If so, the following error shows up in the atlassian-confluence.log:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
	at com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData.<init>(SQLServerParameterMetaData.java:426)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getParameterMetaData(SQLServerPreparedStatement.java:1532)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getParameterMetaData(NewProxyPreparedStatement.java:573)
	at net.java.ao.DatabaseProvider.putNull(DatabaseProvider.java:2053)
	at net.java.ao.EntityProxy.save(EntityProxy.java:579)
	at net.java.ao.EntityProxy.invoke(EntityProxy.java:122)

Cause 4:

There might be an empty space key which could be confirmed by the following SQL query.

SELECT spaceid,spacename,spacekey FROM spaces;

Check if there are any empty spacekey or spacename from the list return. If there are any, please take note of the spaceid. (Follow Resolution 4 below) 

Cause 5:

The presence of this error during Confluence Startup

2015-06-26 18:05:48,529 WARN [localhost-startStop-1] [confluence.setup.bandana.ConfluenceDaoBandanaPersister] getObjectFromValue Configuration could not be loaded because class could not be found (context: _GLOBAL, key: confluence.server.installation.date).
com.thoughtworks.xstream.converters.ConversionException: Cannot parse date 2014-10-01 18:24:03.855 WST


Resolution

Resolution 1

  1. Shutdown Confluence

  2. Add the following to the Java Startup Properties (refer to this guide to see how to add this: Configuring System Properties)

    -Datlassian.forceSchemaUpdate=true
  3. Startup Confluence (which will trigger the DB schema update task, adding the PLUGINKEY column)
  4. Navigate to http://YourConfluenceURL/admin/force-upgrade.action and run the pageTemplateWikiToXhtmlMigrationUpgradeTask
  5. Remove the forceSchemaUpdate startup property added in step 2 to prevent Confluence from triggering that task each time Confluence is started, which will slow down the Confluence startup

(info) In step 3 Replace 'YourConfluenceURL' with the URL you would normally use to connect to Confluence.

Resolution 2

  1. Run the following query in the Confluence Database to see if this applies to you:

     SELECT * FROM bandana WHERE BANDANAKEY = 'confluence.server.installation.date';

    If the query returns <null/> or does not return any rows at all, proceed to the next step

  2. If the query above returns <null/> , set it via this query:

     UPDATE BANDANA SET BANDANAVALUE = '<date>2013-10-01 15:45:01.493 SGT</date>' WHERE BANDANAKEY = 'confluence.server.installation.date';

    Modify the date and time accordingly
    (info) Please do ensure that the installationDate entry has indeed been specified in such date format - <date>YYYY-MM-DD HH:MM:SS.sss <timeZone></date>

  3. Otherwise, if the query from step 1 returns no rows, insert it via this query:

    INSERT INTO bandana(BANDANAID, BANDANACONTEXT, BANDANAKEY, BANDANAVALUE) VALUES (99999, '_GLOBAL', 'confluence.server.installation.date', '<date>2013-10-01 15:45:01.493 SGT</date>');

    Modify the date and time accordingly

  4. Flush all caches in Confluence Admin >> Cache Statistics

Resolution 3

  1. Use the bundled SQL Server driver

Resolution 4

  1. Use the spaceid noted from the previous SQL query above and execute this SQL query:

    UPDATE spaces SET spacekey = '<input UNIQUE space key>' WHERE spaceid = <spaceid noted from the previous query>;
  2. Flush all caches in Confluence Admin >> Cache Statistics
Last modified on Mar 20, 2019

Was this helpful?

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