Forums

Upgrade Error

Permalink
Seem to be getting this error upgrading to the latest build:

An Unexpected Error occurred while upgrading: mysql error: [1146: Table 'cms.pagepermissions' doesn't exist] in EXECUTE("select * from PagePermissions where cID = 1")

Have indeed checked the schema and it doesn't exist.

Core is currently 5.6.0.2 and database is 5.6.0b1.

Any ideas? Thanks!
 
daaahhnuh replied on at Permalink Reply
Nevermind... I have fixed it. I executed the following SQL to create the table as it was missing for some reason. No idea!

CREATE TABLE IF NOT EXISTS `pagepermissions` (
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `gID` int(10) unsigned NOT NULL DEFAULT '0',
  `uID` int(10) unsigned NOT NULL DEFAULT '0',
  `cgPermissions` varchar(32) DEFAULT NULL,
  `cgStartDate` datetime DEFAULT NULL,
  `cgEndDate` datetime DEFAULT NULL,
  PRIMARY KEY (`cID`,`gID`,`uID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


The DB and Core are in harmony once more.