Forum

Thread tagged as: Error, Installation

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

Andrew Areoff

Andrew Areoff 0 points

  • 5 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

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.

Drew McLellan

Drew McLellan 2638 points
Perch Support

It's fine - it means you have some changes missing from your database, so Perch has made those changes for you.

Ah ok. Phew!