Cannot update to version 26-09 - SQLSTATE Error

Started by BRJP, September 26, 2014, 03:45:28 PM

BRJP

Dear All,

Using Auto-Update I get this really nasty error:

HostBill Upgrade Failed Something went wrong during upgrade process, following error occured during database operations: Following error :SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'hb_client_login_status' already exists occured during database update to version 2014-09-05.sql please load your database backup to ensure that your installation is stable, and/or contact HostBill supportFailed on query: CREATE TABLE `hb_client_login_status` ( `client_id` int(11) NOT NULL, `session_id` varchar(32) NOT NULL, `token` varchar(40) NOT NULL, `lastseen` datetime NOT NULL, PRIMARY KEY (`client_id`,`session_id`), KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Any ideas? Anyone else have this issue?
Kind regards,
Bradley Porter
--------------------
Find out more about SaneChoice Services at: https://www.sanechoice.cloud/

BRJP

Well, my guys managed to solve it by dropping the 'hb_client_login_status' table before the upgrade.  (Which was empty).

If the community is not having this issue then this could have been because of a failed previous attempt for us. 

Give me a shout if anyone else is having an upgrade issue.
Kind regards,
Bradley Porter
--------------------
Find out more about SaneChoice Services at: https://www.sanechoice.cloud/