Forum

Thread tagged as: Question, Problem, Error

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

~~~

mark buckley

mark buckley 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

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

Drew McLellan

Drew McLellan 2638 points
Perch Support

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.