Error when upgrade from 7.2 to 7.3 Duplicate column name id

[nimafire]

Hey

can anyone have solution ?

Unable to complete incremental updates: Unable to import the 7.3.0 Alpha1 database file. Unable to import /home/user/public_html/my/resources/sql/upgrade730alpha1.sql: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'id'

 

drop table "tbljobs_queue" isnt solve the problem

[mustardman]

I think I had a similar problem awhile back and WHMCS told me to delete that upgrade7.x*.sql file which solved the problem for me.  In that case it was because it was trying to update a version that never existed in the wild or was removed afterwards.  It may not be the same problem.  It was awhile ago in v7.1.x times and I many not be recalling the details correctly.  I accept no responsibility for what may happen.

Edited October 12, 2017 by mustardman

[WHMCS John]

Hi,

This error indicates that a partial update was made to your database, so when WHMCS tries it again, it fails because some of the columns already exist.

Ideally you should drop the database, restore your backups from before the first upgrade attempt, then try again. But I appreciate that might not be practical.

Therefore in this particular instance, you can remove the column causing this error, so that next time the updater runs, it will be successful:

ALTER TABLE `tbladdonmodules` DROP `id`;

As always, before making changes to your database, please backup.

[hmaddy]

/home/hosvk8/public_html/clients/resources/sql/upgrade820alpha1.sql: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ipaddress' []