Jump to content
Sign in to follow this  
sonuyos

Unable to install 6.0.0

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated