Forum
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
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
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