Forum

Thread tagged as: Question, Problem, Error

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?

Neil Duddridge

Neil Duddridge 1 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

If you refresh do you get the same errors?

Hi Drew,

No, if I return to the login page is says 'update successful'

Drew McLellan

Drew McLellan 2638 points
Perch Support

Sounds like you're good to go then.

Ok, so those errors would have been corrected when I did the refresh then?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, maybe even before that.