Forum

Thread tagged as: Problem, Error

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

Lisa Morena

Lisa Morena 1 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

It sounds like Perch has already fixed things up for you.