Forum
Update from 2.4 to latest throws errors on live site but not on local server
I just updated perch from 2.4 to the latest version. I did this on my local test server first wothout any issues. However when I did it on the live serve I got these errors:
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 'bd_cms.perch2_categories' doesn't exist
The following error occurred:
DROP INDEX idx_uni
ON perch2_resource_log
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bd_cms.perch2_resource_log' doesn't exist
The following error occurred:
ALTER IGNORE TABLE perch2_resource_log
ADD UNIQUE INDEX idx_uni
(appID
, itemFK
, itemRowID
, resourceID
)
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bd_cms.perch2_resource_log' doesn't exist
The tables in question do exist though.....
It sounds like Perch has already fixed things up for you.