WHMCS v6 upgrade issue

[sneakygorilla]

I've submitted a ticket over a day ago and still waiting to hear back... ticket #NEL-113504

 

Is anyone able to shed some light on what to do?

 

I am trying to upgrade my WHMCS to v6.01 - however am having endless issues.

I have tried to do it via the upgrade on Softaculous and also manually by uploading the files to my server... still till no avail...

 

I have had no issues with upgrading WHMCS before...

 

This is the error log:

[2015-07-25 03:18:23][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-25 03:18:23][WHMCS Installer] INFO: Previous install detected []
[2015-07-25 03:18:23][WHMCS Installer] DEBUG: An upgrade from 5.3.11-release.1 to 6.0.1-release.1 will be attempted. []
[2015-07-25 03:18:23][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-25 03:18:23][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2015-07-25 03:18:23][WHMCS Installer] INFO: Applying Updates for 5.3.12-release.1 []
[2015-07-25 03:18:24][WHMCS Installer] INFO: Removing any obsolete file and directories []
[2015-07-25 03:18:24][WHMCS Installer] INFO: Applying Updates for 6.0.0-alpha.1 []
[2015-07-25 03:18:32][WHMCS Installer] INFO: Performing Update Action: removeDuplicateSettings []
[2015-07-25 03:18:32][WHMCS Installer] INFO: Performing Update Action: convertMailTemplateBooleanColumns []
[2015-07-25 03:18:32][WHMCS Installer] INFO: Performing Update Action: convertClientUnixTimestampColumns []
[2015-07-25 03:18:33][WHMCS Installer] INFO: Performing Update Action: convertClientBooleanColumns []
[2015-07-25 03:18:33][WHMCS Installer] INFO: Performing Update Action: convertDomainBooleanColumns []
[2015-07-25 03:18:33][WHMCS Installer] INFO: Performing Update Action: convertProductBooleanColumns []
[2015-07-25 03:18:34][WHMCS Installer] INFO: Performing Update Action: convertProductGroupBooleanColumns []
[2015-07-25 03:18:34][WHMCS Installer] INFO: Performing Update Action: convertDownloadBooleanColumns []
[2015-07-25 03:18:34][WHMCS Installer] INFO: Performing Update Action: convertDownloadCategoryBooleanColumns []
[2015-07-25 03:18:34][WHMCS Installer] INFO: Performing Update Action: migrateProductDownloadIdsToItsTable []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: migrateProductUpgradeIdsToItsTable []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: convertServiceBooleanColumns []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: convertAnnouncementBooleanColumns []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: updateAdminUserForAutoReleaseModule []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: createServiceUnsuspendedEmailTemplate []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: addManualUpgradeRequiredEmailTemplate []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: convertNoMD5Passwords []
[2015-07-25 03:18:35][WHMCS Installer] INFO: Performing Update Action: populateTopLevelDomainsAndCategories []
[2015-07-25 03:21:16][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-25 03:21:19][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-25 03:21:19][WHMCS Installer] INFO: Previous install detected []
[2015-07-25 03:21:19][WHMCS Installer] DEBUG: An upgrade from 5.3.12-release.1 to 6.0.1-release.1 will be attempted. []
[2015-07-25 03:21:25][WHMCS Installer] DEBUG: Installer bootstrapped []
[2015-07-25 03:21:25][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2015-07-25 03:21:25][WHMCS Installer] INFO: Applying Updates for 6.0.0-alpha.1 []
[2015-07-25 03:21:25][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import /home/public_html/resources/sql/upgrade600alpha1.sql: Table 'tblupdatehistory' already exists []
[2015-07-25 03:21:25][WHMCS Installer] ERROR: Upgrade process terminated due to error. []

 

 

I have tried to run this via phpMyAdmin, which was on a previous post:

DROP TABLE `tblupdatehistory`;
ALTER TABLE `tblemailtemplates` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblconfiguration` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblclients` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblnetworkissues` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblservers` DROP `port` ;
DROP TABLE `tblserversssoperms`;
DROP TABLE `tblknowledgebasetags`;
ALTER TABLE `tblnetworkissues` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblproducts` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblproductgroups` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tbldownloads` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tbldownloadcats` DROP `created_at` ,
DROP `updated_at` ;
DROP TABLE `tblproduct_downloads`;
DROP TABLE `tblproduct_upgrade_products`;
ALTER TABLE `tbldomains` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tbldomainsadditionalfields` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblhosting` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblannouncements` DROP `created_at` ,
DROP `updated_at` ;
DROP TABLE `tbltlds`;
DROP TABLE `tbltld_categories`;
DROP TABLE `tbltld_category_pivot`;
ALTER TABLE `tblhostingaddons` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblcontacts` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblcancelrequests` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblquoteitems` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tblaffiliates` DROP `created_at` ,
DROP `updated_at` ;
ALTER TABLE `tbladminsecurityquestions` DROP `created_at` ,
DROP `updated_at` ;

 

Nothing seems to be working...

Any help would be greatly appreciated.

 

Thanks

[Soufan]

Back up your existing database, setup a brand new WHMCS 6.0.1 install, then import your old database