Forum

Thread tagged as: Error

Errors updating from 2.0.7

I've got the following errors come up after trying to update from 2.0.7 to the latest version. I did the update first on localhost and didn't have any issues at all. Please advise!

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 'yepdouk1_starlight.perch2_categories' doesn't exist
The following error occurred:
ALTER TABLE `perch2_resources` ADD INDEX `idx_list` (`resourceParentID`, `resourceKey`, `resourceAWOL`)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'yepdouk1_starlight.perch2_resources' doesn't exist
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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.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 'yepdouk1_starlight.perch2_resources' doesn't exist
Stephen Turvey

Stephen Turvey 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What happens if you run it again?

/perch/core/update/?force=update

I got 2 errors that time. I refreshed again and no errors so I continued to log in.

Those errors nothing to worry about then?

Drew McLellan

Drew McLellan 2638 points
Perch Support

That's right.