Upgrade whmcs 6.01 error: Duplicate column name 'passwordhash'

[JackRabbit]

I'm trying to upgrade to whmcs 6.01 and I'm getting this error:

[2015-07-27 10:40:45][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-27 10:40:49][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-27 10:40:49][WHMCS Installer] INFO: Previous install detected []
[2015-07-27 10:40:49][WHMCS Installer] DEBUG: An upgrade from 5.3.8-release.1 to 6.0.1-release.1 will be attempted. []
[2015-07-27 10:40:59][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-27 10:40:59][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2015-07-27 10:40:59][WHMCS Installer] INFO: Applying Updates for 5.3.9-release.1 []
[2015-07-27 10:40:59][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 5.3.9 database file. Unable to import /home/raretees/public_html/jackrabbit/whmcs/resources/sql/upgrade539release1.sql: Duplicate column name 'passwordhash' []
[2015-07-27 10:40:59][WHMCS Installer] ERROR: Upgrade process terminated due to error. []

 

(I can't log into whmcs to put in a ticket since I'm using whmcs through a reseller)

[brian!]

(I can't log into whmcs to put in a ticket since I'm using whmcs through a reseller)

take a look at the link below - I think you should still be able to submit a ticket.

 

http://www.whmcs.com/reseller-support/

 

No matter whether you buy direct or from a reseller, we've always provided direct technical support to all of our users. Below you’ll find access to submit a ticket with our tech support team.

[JackRabbit]

Ah, ok thanks Brian. I managed to figure this out myself. I created a backup of the database then dropped the 'passwordhash' table. This fixed any error and installing version 6.01 was quick.