AutoUpgrade Cannot Update DB

[BRJP]

Dear All,

I have moved my HostBill to a new server and all is working apart from AutoUpgrade. 

It seems like its downloading the file, unpacking etc is working but when it comes to update the database it throws this error and halts.

Upgrade failed, unable to perform database upgrade, please revert your backup

Any idea what could be the problem?

Brad

[hbillclient]

Could be caused by timeout issues with your MySQL server. Also, check your config file for the proper MySQL credentials for the upgrade to work.

[BRJP]

Thank you.

I looked a little more (performed a manual upgrade) which gave me a clearer error message.   It was complaining about duplicate heading of "ADMIN_ONLY" in the hb_knowledgebase_cat table.  I had to remove this SQL to make sure the upgrade finished properly. 

I will log a bug with KBKP just in case its a wider issue.

Brad

[hbillclient]

Check the changelog, this is the issue:

https://www.hostbillforums.com/index.php/topic,1754.0.html

    [Knowledgebase] Added: Its now possible to define Admin-only categories

That seems to be the issue.

Thanks.

[BRJP]

Thanks for the help. 

[hbillclient]

Welcome and by the way did you just get rid of the sql or changed something to make use of the new feature?

[BRJP]

The error was stating that the column/index was already there and it was a duplicate.  So I removed the SQL file and run again and all was fine.  My view was that if its a duplicate then the risk was low.