Unable to Create Pages or Spaces after Upgrading to 3.3
Symptoms
After upgrading to Confluence 3.3, users are unable to create/remove pages or spaces, and the logs might show the following error:
ERROR [http-443-8] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Invalid column name 'DIGEST'.
-- referer: https://xxxxx/spaces/spaceadmin.action?atl_token=lDHOIgs68t&key=it | url: xxxxx | userName: xxxxx | action: viewpage | page: 1409026
2010-07-22 09:36:37,017 ERROR [http-443-8] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Invalid column name 'NETWORK'.
-- referer: https://xxxxx/spaces/spaceadmin.action?atl_token=lDHOIgs68t&key=it | url: xxxxx | userName: xxxxx | action: viewpage | page: 1409026
2010-07-22 09:36:37,017 ERROR [http-443-8] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Invalid column name 'CONTENTTYPE'.
-- referer: https://xxxxx/spaces/spaceadmin.action?atl_token=lDHOIgs68t&key=it | url: xxxxx | userName:xxxxx
Cause
Confluence did not create the following columns in the NOTIFICATIONS table: DIGEST, NETWORK and CONTENTTYPE.
Workaround
Run the following query to add the missing columns. The query should work for Oracle, MSSQL, and MySQL databases:
ALTER TABLE NOTIFICATIONS
ADD ( DIGEST bit(1),
NETWORK bit(1),
CONTENTTYPE varchar(255));Resolution
Upgrade to 3.3.1 or later. See Unable to Create Pages or Spaces after Upgrading to 3.3.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.