Forum

Thread tagged as: Error, Configuration, Blog

SQL errors / perch upgrade

Hi there,

I have been struggling with setting up my blog recently. I am not sure why none of my posts are visible etc. After doing perch/upgrade and debug I have received a lot of errors. Should I re-install the whole thing or there is a quick fix?

Thanks!

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 ('assets.manage','Manage assets',2)
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

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

That's very strange - it's stating an error occurred, but not actually giving the error. It may well be spurious. Which version were you updating from?