Database issues? WHMCS upgrade

Mikhail

Member
Jan 1, 2017
6
1
1
Melbourne, Australia
cPanel Access Level
DataCenter Provider
Hi,
I have a old whmcs that needs upgrading however the script to upgrade does not function I opened a ticket with WHMCS and they keep coming back to me that its the my sql performance that is causing the problem.
I have tried various changes to the my.cnf but nothing seems to work for the upgrade script they have.
I am running this on a VPS very low load only 5 domains none of them are big sites wordpress openecart etc for SOHO and ma and pa local buiness's.
Thanks in advance for any help.
Kind Regards,



MIKHAIL
 

Mikhail

Member
Jan 1, 2017
6
1
1
Melbourne, Australia
cPanel Access Level
DataCenter Provider
Error is something like this: Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import /home/path/public_html/myaccount/resources/sql/upgrade600alpha1.sql: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tblupdatehistory' already exists
 

Infopro

Well-Known Member
May 20, 2003
17,090
519
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter