7.5.2->7.6 Failed

[iHelpersLLC]

Tried to run the update and got this error:

Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/xx/public_html/ihexx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihexx_ihelxxs_whmcs5.tblioncube_file_log' doesn't exist

Error log says:

[2018-07-31 10:55:19][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:55:29][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:55:30][WHMCS Installer] INFO: Previous install detected []
[2018-07-31 10:55:31][WHMCS Installer] DEBUG: An upgrade from 7.5.2-release.1 to 7.6.0-release.1 will be attempted. []
[2018-07-31 10:55:52][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:55:52][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2018-07-31 10:55:52][WHMCS Installer] INFO: Applying Updates for 7.6.0-alpha.1 []
[2018-07-31 10:55:52][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/ihexx/public_html/ihxx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihexx_ihxx_whmcs5.tblioncube_file_log' doesn't exist []
[2018-07-31 10:56:04][WHMCS Installer] ERROR: Upgrade process terminated due to error. []
[2018-07-31 10:57:16][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:57:19][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:57:19][WHMCS Installer] INFO: Previous install detected []
[2018-07-31 10:57:19][WHMCS Installer] DEBUG: An upgrade from 7.5.2-release.1 to 7.6.0-release.1 will be attempted. []
[2018-07-31 10:57:23][WHMCS Installer] DEBUG: Installer bootstrapped []
[2018-07-31 10:57:23][WHMCS Installer] INFO: Applying incremental updates to existing installation []
[2018-07-31 10:57:23][WHMCS Installer] INFO: Applying Updates for 7.6.0-alpha.1 []
[2018-07-31 10:57:23][WHMCS Installer] ERROR: Unable to complete incremental updates: Unable to import the 7.6.0 Alpha1 database file. Unable to import /home/ihxx/public_html/ihxx/resources/sql/upgrade760alpha1.sql: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ihxx_ihelxx_whmcs5.tblioncube_file_log' doesn't exist []
[2018-07-31 10:57:23][WHMCS Installer] ERROR: Upgrade process terminated due to error. []
 

Easy way forward ?

Edited July 31, 2018 by iHelpersLLC

[string]

According to the error message, the table 'tblioncube_file_log' does not exist. 

Executing the following SQL query probably helps you:

CREATE TABLE IF NOT EXISTS `tblioncube_file_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` text COLLATE utf8_unicode_ci NOT NULL,
  `content_hash` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `encoder_version` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bundled_php_versions` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `loaded_in_php` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Normally this table should be created when upgrading to version 7.5.0.

Version 7.5.0 also did the following on upgrade:

INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES (1, 146);

It is probably in your interest to check if the permid 146 exists in your database.
If not, something went wrong at the upgrade. Then i recommend to contact the WHMCS support. 

Edited July 31, 2018 by string

[iHelpersLLC]

That did the trick, thank you!