Forum

Thread tagged as: Error, Installation

Update errors when upgrading from 2.0.8 to 2.7.1 (latest

Hi Drew,

Just updated, all looks okay but received these errors, I chose to accept them but just wanted to confirm with you that this isn't an issue.

The following error occurred: RENAME TABLE perch2_content_resources TO perch2_resource_log SQLSTATE[HY000]: General error: 1017 Can't find file: './db440814821/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 'db440814821.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 'db440814821.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 'db440814821.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 'db440814821.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 'db440814821.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 'db440814821.perch2_resource_log' doesn't exist

Help greatly appreciated as always.

Cheers

Rob

Rob Hawkins

Rob Hawkins 0 points

  • 7 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you able to accept the errors and proceed?

They don't look like they'll actually be an issue.

Hi Drew,

As mentioned above I did accept them but just wanted to be sure they were not going to cause a problem at a later stage. Sounds like it's okay then?

Cheers

Rob

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yeah, should be fine. The nature of the update process is that at times it will try to do things that either have already been done, or don't need to be.

Ok, I'll carry on then!

Cheers