Forum
Errors on update to from 2.3 to 2.8.18
Software 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 'accolajoomla.perch2_categories' doesn't exist
Do you get the same errors if you run it again?
I did refresh and the error was gone and the normal control panel was back in place. And it seems to be working fine.
I was just concerned as to why this happened and what it means.
It's fine - it means you have some changes missing from your database, so Perch has made those changes for you.
Ah ok. Phew!