Unable to install 6.0.0

[sonuyos]

Am unable to upgrade from my current whmcs to 6.0.0

 

Am getting this error

 

Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import /home/USER/public_html/billing/resources/sql/upgrade600alpha1.sql: Table 'tblupdatehistory' already exists

 

Not sure what to do,

 

I was told to do this from support, but not sure how to do that either,

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` ;

Please help as the support is offline atm

[lowprofiler]

The table exist already. Make a backup first.

Insert the code in phpmyadmin sql query box to apply the code. The code will delete the existing tables.

 

After that you can try again

[sonuyos]

The table exist already. Make a backup first.

Insert the code in phpmyadmin sql query box to apply the code. The code will delete the existing tables.

 

After that you can try again

 

I tried Am getting this error while running it in phpmyadmin

 

Error

SQL query:

 

ALTER TABLE `tblconfiguration` DROP `created_at` ,

DROP `updated_at` ;

 

 

MySQL said: Documentation

 

#1091 - Can't DROP 'created_at'; check that column/key exists

[lowprofiler]

Skip that command. Remove it from query.

[sonuyos]

Skip that command. Remove it from query.

 

Tried,

 

there is alternate prob

[lowprofiler]

all right, how about telling us the issue?

[sonuyos]

Thanks,

 

finally worked it out

 

Had to manually remove each line before error line

[leena]

This worked partially. After deleting these tables we restarted the installing process but it says our site is only on version6

 

Upgrade Your Installation

 

We have detected that you are already running WHMCS Version 6.0.0.

 

This installer script can only upgrade as far as 6.0.0 so there is no update to perform.

 

But we are not able to login to admin infact we just get blank screen not even login screen. Can any one please help to fix this. Opened Support ticket no response yet from many hrs