Forum
Upgrade (to ver 3 Perch) errors
I upgraded form 2.x to latest 3 and all seemed fine locally.
I then continued to my staging post where I got various errors below. Then in subsequently trying to get the diagnostics to post here - I had to log in again - it then said (see below)
Did this fail (and if so what should I do) or did it succeed?
Can anyone help?
SECOND MESSAGE-
Software Update
Successfully updated to version 3.1.1
Continue.
FIRST MESSAGE- Software Update
The following error occurred:
RENAME TABLE `perch2_content_resources` TO `perch2_resource_log`
SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user 'dasolcou_tedu1'@'localhost' for table 'perch2_content_resources'
The following error occurred:
ALTER TABLE `perch2_resource_log` DROP PRIMARY KEY
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dasolcou_ted_pch.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 'dasolcou_ted_pch.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 'dasolcou_ted_pch.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 'dasolcou_ted_pch.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 'dasolcou_ted_pch.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 'dasolcou_ted_pch.perch2_resource_log' doesn't exist
Please check the messages
Contact us if you are unsure how to resolve these problems, or accept these errors and continue.
Diagnostics report:
Perch: 3.1.1, PHP: 5.6.35, MySQL: 10.0.34-MariaDB, with PDO
Server OS: Linux, litespeed
Installed apps: content (3.1.1), assets (3.1.1), categories (3.1.1), perch_blog (5.6.1), perch_events (1.9.5), perch_gallery (2.8.9)
App runtimes: <?php $apps_list = [ 'perch_blog', 'perch_events', 'perch_gallery', ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/dasolcou/public_html/grx99.com/perch
PERCH_CORE: /home/dasolcou/public_html/grx99.com/perch/core
PERCH_RESFILEPATH: /home/dasolcou/public_html/grx99.com/perch/resources
Image manipulation: GD
PHP limits: Max upload 128M, Max POST 256M, Memory: 512M, Total max file upload: 128M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: www.grx99.com
DOCUMENT_ROOT: /home/dasolcou/public_html/grx99.com
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
~~~
Have you checked what permissions your database user has?
Alter, Create, Delete, Select, Insert & Update
Presumably beeds 'Drop' too? Anything else?
Will I then need to re-reun anything or do anything or will that fix it?
Cheers - Mark
Yes, looks like you need to add Drop. You could add everything, and then remove anything you're uncomfortable with once the upgrade is done.