Unable to Create Pages or Spaces (The Popup Loads Forever) After Confluence Upgrade to 5.x or 6.x
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
When attempting to create a new page, the Create Page popup loads forever.
Diagnosis
The following appears in the atlassian-confluence.log:
1
java.sql.SQLException: Invalid column name 'PLUGINKEY'.
OR
1
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'pagetempla0_.PLUGINKEY' in 'field list'
OR
1
java.lang.IllegalArgumentException: Invalid plugin key specifiedOR
When trying to create a new space. The popup window appears and the spinning wheel keeps on rotating forever.
OR
This appears in the application log file:
1
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: falseTake 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
1
<meta name="referrer" content="none">Please see Creating a page in Firefox causes the create dialog to wait indefinitely for a resolution.
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 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:
1
2
3
4
5
6
7
8
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)For other possible causes of problems with creating pages and spaces, please see:
Solution
Resolution
Resolution 1
Shutdown Confluence
Add the following to the Java Startup Properties (refer to this guide to see how to add this: Configuring System Properties)
1-Datlassian.forceSchemaUpdate=trueStartup Confluence (which will trigger the DB schema update task, adding the PLUGINKEY column)
Navigate to http://YourConfluenceURL/admin/force-upgrade.action and run the pageTemplateWikiToXhtmlMigrationUpgradeTask
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
ℹ️ In step 3 Replace 'YourConfluenceURL' with the URL you would normally use to connect to Confluence.
Resolution 2
Use the bundled SQL Server driver
Was this helpful?