Forum

Thread tagged as: Problem, Error, Installation

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

Ben Read

Ben Read 0 points

  • 6 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

Which version did you upgrade from?

Hi Rachel

Pretty sure it was 2.08 or 2.1?

Apologies I can't be more definite.

Ben

This from the diagnostics:

DB tables: perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users, perch_blog_categories, perch_blog_posts, perch_blog_posts_to_categories, perch_blog_posts_to_tags, perch_blog_tags, perch_contentItems, perch_forms, perch_forms_responses, perch_settings, perch_users

Drew McLellan

Drew McLellan 2638 points
Perch Support

What do you get if you rerun the update?

/perch/core/update/?force=update

Just to be clear - to do that, do I add that to the url i.e. https://mydomain.co.uk/perch/core/update/?force=update ?

sorry... just being sure

B

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, is that not working?

Yes it worked.

That resulted in the success message as before - without the warnings - does that mean it's ok?

B

Drew McLellan

Drew McLellan 2638 points
Perch Support

I think you should be all good.