Unable to complete incremental updates: Unable to import the 8.12.0 database file

[ghmercado]

i am trying to update my whmcs installation from 8.11.2 to 8.12.0

after downloading a copy of my db via phpmyadmin

i run the install process, the System Requirements Check Results says I pass all requirements, then i get

Unable to complete incremental updates: Unable to import the 8.12.0 database file. Unable to import /home/wpgahm/public_html/clients/resources/sql/upgrade8120release1.sql: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscriptionid'


any help please thank you

 

Edited 19 hours ago by ghmercado
removed screencap that shows path to files

[ghmercado]

this was fixed by executing this line to add the missing dir in phpmyadmin

 

ALTER TABLE `tblhostingaddons` ADD `subscriptionid` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' AFTER `notes`;

 

[WHMCS John]

Hi @ghmercado,

This indicates that a column is missing from a table. In this case the tblhostingaddons database table is missing the subscriptionid column. This added in WHMCS 7.9.2.

Creating the missing column and then re-running the update process via install.php is the correct solution:

ALTER TABLE `tblhostingaddons` ADD `subscriptionid` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' AFTER `notes`;