Forum
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
What happens if you run it again?
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?
That's right.