Upgrade problem

Hi there

Just tried to upgrade and got the following error/warning

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_resources ADD resourceCreated DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER resourceType • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER resourceCreated • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceAWOL TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceUpdated • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD INDEX idx_awol (resourceAWOL) • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceTitle CHAR(255) NULL DEFAULT NULL AFTER resourceAWOL • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceFileSize INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTitle • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceFileSize • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceWidth • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceCrop TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceHeight • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceDensity FLOAT NOT NULL DEFAULT '1' AFTER resourceCrop • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceTargetWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceDensity • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceTargetHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTargetWidth • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceMimeType CHAR(64) NULL DEFAULT NULL AFTER resourceTargetHeight • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD FULLTEXT INDEX idx_search (resourceTitle) • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD resourceInLibrary TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceMimeType • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • ALTER TABLE perch2_resources ADD INDEX idx_library (resourceInLibrary) • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resources' doesn't exist • The following error occurred: • RENAME TABLE perch2_content_resources TO perch2_resource_log • SQLSTATE[HY000]: General error: 1017 Can't find file: './uks78224clarity/perch2_content_resources.frm' (errno: 2) • The following error occurred: • ALTER TABLE perch2_resource_log DROP PRIMARY KEY • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist • The following error occurred: • ALTER TABLE perch2_resource_log ADD logID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist • The following error occurred: • ALTER TABLE perch2_resource_log ADD appID CHAR(32) NOT NULL DEFAULT 'content' AFTER logID • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist • The following error occurred: • ALTER TABLE perch2_resource_log ADD itemFK CHAR(32) NOT NULL DEFAULT 'itemRowID' AFTER appID • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist • The following error occurred: • ALTER TABLE perch2_resource_log ADD INDEX idx_fk (itemFK, itemRowID) • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist • The following error occurred: • ALTER TABLE perch2_resource_log ADD UNIQUE INDEX idx_uni (appID, itemFK, itemRowID, resourceID) • SQLSTATE[42S02]: Base table or view not found: 1146 Table 'uks78224clarity.perch2_resource_log' doesn't exist

Contact us if you are unsure how to resolve these problems, or accept these errors and continue.

I continued the log in and the 'upgrade success' message was displayed - I then added the categories templates which I had missed.

Is there anything else I need to do?

Cheers in advance

Ben