Forum

Thread tagged as: Problem, Error, Configuration

Perch Upgrade errors 2.3.2 to 2.7.3

Hi there,

I have been upgrading Perch CMS on one of my older websites in order to use new addons. When I logged in to the admin panel I was surprised by error log output. At the very bottom of it there was a link that allowed me to proceed by however I am afraid that ingoring it might not be the wisest thing to do. Any ideas?

BTW: Diagnostic tab says my PHP is up to date.

Software Update

  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceCreated DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER resourceType|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER resourceCreated|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceAWOL TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceUpdated|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD INDEX idx_awol (resourceAWOL)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceTitle CHAR(255) NULL DEFAULT NULL AFTER resourceAWOL|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceFileSize INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTitle|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceFileSize|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceWidth|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceCrop TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceHeight|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceDensity FLOAT NOT NULL DEFAULT '1' AFTER resourceCrop|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceTargetWidth INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceDensity|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceTargetHeight INT(10) UNSIGNED NULL DEFAULT NULL AFTER resourceTargetWidth|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceMimeType CHAR(64) NULL DEFAULT NULL AFTER resourceTargetHeight|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD FULLTEXT INDEX idx_search (resourceTitle)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD resourceInLibrary TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER resourceMimeType|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_resources ADD INDEX idx_library (resourceInLibrary)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('assets.create','Upload assets',1)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.create','Create new categories',1)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.delete','Delete categories',2)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.manage','Manage categories',3)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.create','Create category sets',4)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('categories.sets.delete','Delete category sets',5)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_items ADD INDEX idx_regrev USING BTREE (itemID, regionID, itemRev)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_items ADD INDEX idx_order USING BTREE (itemOrder)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_regions ADD INDEX idx_key USING BTREE (regionKey)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_regions ADD INDEX idx_path USING BTREE (regionPage)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_page_templates ADD templateNavGroups VARCHAR(255) NULL DEFAULT '' AFTER templateReference|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_user_privileges ADD UNIQUE INDEX idx_key (privKey)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.navgroups.configure','Configure navigation groups',7), ('content.navgroups.create','Create navigation groups',8), ('content.navgroups.delete','Delete navigation groups',9)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.create.toplevel','Add new top-level pages',3)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.delete.own','Delete pages they created themselves',4)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.templates.configure','Configure master pages',6)|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.republish','Republish pages', 12)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageAccessTags VARCHAR(255) NOT NULL DEFAULT '' AFTER pageNavOnly|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageCreatorID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageAccessTags|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageModified DATETIME NOT NULL DEFAULT '2014-01-01 00:00:00' AFTER pageCreatorID|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageAttributes TEXT NOT NULL AFTER pageModified|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageAttributeTemplate VARCHAR(255) NOT NULL DEFAULT 'default.html' AFTER pageAttributes|
  • ||
  • The following error occurred:
  • |INSERT INTO perch2_user_privileges (privKey, privTitle, privOrder) VALUES ('content.pages.attributes','Edit page titles and attributes',6)|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_regions ADD regionUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER regionEditRoles|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_items ADD itemUpdated TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER itemSearch|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_content_items ADD itemUpdatedBy CHAR(32) NOT NULL DEFAULT '' AFTER itemUpdated|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageTemplate CHAR(255) NOT NULL DEFAULT '' AFTER pageAttributeTemplate|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD templateID INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER pageTemplate|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageSubpageTemplates VARCHAR(255) NOT NULL DEFAULT '' AFTER templateID|
  • ||
  • The following error occurred:
  • |ALTER TABLE perch2_pages ADD pageCollections VARCHAR(255) NOT NULL DEFAULT '' AFTER pageSubpageTemplates|
Damian Drozdowicz

Damian Drozdowicz 0 points

  • 7 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

I think that's probably fine to proceed with.

The update script by necessity reapplies some changes which may have already taken place and could cause an error. Normally those are caught and not displayed, but it depends.

Proceed and let us know if you see any problems.