Update error

[saeeddeeas]

Hello we can not update whmcs 5 to whmcs 6.2.2

please help me

[zomex]

Did you take a backup of your database and files before upgrading? I'd recommend restoring them and then have WHMCS check your database prior to running the upgrade again.

[WHMCS John]

Hi,

The error indicates that a previous failed upgrade attempt has been made on your database. Please drop the WHMCS database and restore your pre-upgrade backup.

 

Then run the upgrade script once.

 

Should you encounter any errors, please post the contents of the /install/logs/installer.log file for us to review.

[saeeddeeas]

Hi,

The error indicates that a previous failed upgrade attempt has been made on your database. Please drop the WHMCS database and restore your pre-upgrade backup.

 

Then run the upgrade script once.

 

Should you encounter any errors, please post the contents of the /install/logs/installer.log file for us to review.

 

[2016-02-13 15:30:01][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:30:12][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:30:12][WHMCS Installer] INFO: Previous install not detected; a fresh install will be attempted []
[2016-02-13 15:30:58][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:30:58][WHMCS Installer] INFO: Previous install not detected; a fresh install will be attempted []
[2016-02-13 15:31:07][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:32:32][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:32:32][WHMCS Installer] INFO: New configuration file has been written []
[2016-02-13 15:32:32][WHMCS Installer] ERROR: Previous WHMCS database found after configuration file was created []
[2016-02-13 15:33:35][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:33:38][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:33:38][WHMCS Installer] INFO: Previous install detected []
[2016-02-13 15:33:38][WHMCS Installer] DEBUG: An upgrade from 5.3.11-release.1 to 6.2.1-release.1 will be attempted. []
[2016-02-13 15:33:53][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:33:53][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2016-02-13 15:33:53][WHMCS Installer] INFO: Applying Updates for 5.3.12-release.1 []
[2016-02-13 15:33:53][WHMCS Installer] INFO: Removing any obsolete file and directories []
[2016-02-13 15:33:53][WHMCS Installer] INFO: Applying Updates for 6.0.0-alpha.1 []
[2016-02-13 15:33:56][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import /home/usere-may-site/public_html/portal/resources/sql/upgrade600alpha1.sql: Table 'usere-may-site_usere-may-site202.tblactivitylog' doesn't exist []
[2016-02-13 15:33:56][WHMCS Installer] ERROR: Upgrade process terminated due to error. []
[2016-02-13 15:34:06][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:34:40][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:34:44][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:34:44][WHMCS Installer] INFO: Previous install detected []
[2016-02-13 15:34:44][WHMCS Installer] DEBUG: An upgrade from 5.3.12-release.1 to 6.2.1-release.1 will be attempted. []
[2016-02-13 15:34:53][WHMCS Installer] DEBUG: Installer bootstrapped []
[2016-02-13 15:34:54][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2016-02-13 15:34:54][WHMCS Installer] INFO: Applying Updates for 6.0.0-alpha.1 []
[2016-02-13 15:34:54][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import /home/usere-may-site/public_html/portal/resources/sql/upgrade600alpha1.sql: Table 'tblupdatehistory' already exists []
[2016-02-13 15:34:54][WHMCS Installer] ERROR: Upgrade process terminated due to error. []

[saeeddeeas]

please help me

[WHMCS John]

Hi,

That logs show that you're missing the tblactivitylog table from your database. Please restore your pre-upgrade database backup once more, then run the following query to create the missing table:

 

CREATE TABLE `tblactivitylog` (
 `id` int(10) NOT NULL AUTO_INCREMENT,
 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `description` text NOT NULL,
 `user` text NOT NULL,
 `userid` int(10) NOT NULL,
 `ipaddr` text NOT NULL,
 PRIMARY KEY (`id`),
 KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

Then run the installation script again. This time you will not encounter the same error.