Forum
Upgrading from 2.2.x to 2.8.29
I got the following errors on update
The following error occurred:
ALTER TABLE `perch2_pages` ADD `pageTemplate` CHAR(255) NOT NULL DEFAULT '' AFTER `pageAttributeTemplate`
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pageAttributeTemplate' in 'perch2_pages'
The following error occurred:
ALTER TABLE `perch2_pages` ADD `templateID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `pageTemplate`
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pageTemplate' in 'perch2_pages'
The following error occurred:
ALTER TABLE `perch2_pages` ADD `pageSubpageTemplates` VARCHAR(255) NOT NULL DEFAULT '' AFTER `templateID`
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'templateID' in 'perch2_pages'
The following error occurred:
ALTER TABLE `perch2_pages` ADD `pageCollections` VARCHAR(255) NOT NULL DEFAULT '' AFTER `pageSubpageTemplates`
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pageSubpageTemplates' in 'perch2_pages'
The following error occurred:
ALTER TABLE `perch2_categories` CHANGE `catDisplayPath` `catDisplayPath` CHAR(255) NOT NULL DEFAULT ''
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'so53devc1_dgs.perch2_categories' doesn't exist
The following error occurred:
ALTER TABLE `perch2_resources` ADD INDEX `idx_list` (`resourceParentID`, `resourceKey`, `resourceAWOL`)
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'resourceAWOL' doesn't exist in table
How do I resolve?
If you refresh do you get the same errors?
Hi Drew,
No, if I return to the login page is says 'update successful'
Sounds like you're good to go then.
Ok, so those errors would have been corrected when I did the refresh then?
Yes, maybe even before that.