db issues upgrading from 4.6.0 to 5.8.0

Ian Watson shared this problem 7 months ago
New Problem

Hi,

A recent mySQL upgrade by my host caused my installation of clientexec 4.6.0 to break due to deprecated OLD_PASSWORD function.

I backed up my db and attempted to upgrade to version 5.8.0 but install.php reported the installation as corrupt, I believe because of an incompatible version of ionCube.

I then attempted to upgrade to version 5.7.0 but ran into the same issue with the deprecated OLD_PASSWORD function.

My webhosts encouraged me to upgrade PHP on my webserver to version 7.2 and attempt to install 5.8.0 again. I went through the process and encountered the error below. I then restored my db from backup and went through the process again only to receive the same error on install.

Thanks. Ian

An error has occurred with the given operation 
It appears you were in the middle of an upgrade process.
The database is in an inconsistent state. After fixing the cause of this error, restore the backup you made before the upgrade, and initiate the upgrade process again.

Type: User Error (256) 
Description: QUERY: CREATE TABLE `files_status` ( `id_file` INT UNSIGNED NOT NULL, `id_status` INT NOT NULL, PRIMARY KEY (`id_file`, `id_status`) ); - ERROR: Table 'files_status' already exists 
Request: GET /billing/index.php?fuse=admin&action=runinstallation&controller=installer&lastVersion=5.0.0a2&upgraded=a:10:{s:7:%22newedge%22;i:1;s:4:%22home%22;i:1;s:7:%22clients%22;i:1;s:7:%22domains%22;i:1;s:7:%22billing%22;i:1;s:7:%22support%22;i:1;s:13:%22knowledgebase%22;i:1;s:5:%22files%22;i:1;s:7:%22reports%22;i:1;s:5:%22admin%22;i:1;} 
Script: home/sweetukn/public_html/billing/library/CE/MySQL.php 
Line Number: 179 
Stack:
home/sweetukn/public_html/billing/library/CE/MySQL.php (179) : trigger_error
home/sweetukn/public_html/billing/library/setup/scripts/upgrade_5_0_0a4.php (89) : CE_MySQL::query
home/sweetukn/public_html/billing/modules/admin/models/InstallerGateway.php (551) : unknown
home/sweetukn/public_html/billing/modules/admin/models/InstallerGateway.php (311) : InstallerGateway::_runPHPScript
home/sweetukn/public_html/billing/modules/admin/models/InstallerGateway.php (219) : InstallerGateway::_upgradeModule
home/sweetukn/public_html/billing/modules/admin/models/InstallerGateway.php (156) : InstallerGateway::_installModules
home/sweetukn/public_html/billing/modules/admin/controllers/InstallerController.php (764) : InstallerGateway::_processModules
home/sweetukn/public_html/billing/library/Zend/Controller/Action.php (516) : Admin_InstallerController::runinstallationAction
home/sweetukn/public_html/billing/library/Zend/Controller/Dispatcher/Standard.php (295) : Zend_Controller_Action::dispatch
home/sweetukn/public_html/billing/library/Zend/Controller/Front.php (954) : Zend_Controller_Dispatcher_Standard::dispatch
home/sweetukn/public_html/billing/library/CE/Lib.php (256) : Zend_Controller_Front::dispatch
home/sweetukn/public_html/billing/library/front.php (9) : CE_Lib::route
home/sweetukn/public_html/billing/index.php (35) : require