#22 Account lab plus installtion error

[Sherin]

getting error when installing Account lab plus. Seems installtion is trying to pupoluate data to non-existing tables. We have downloaded the package from https://www.netenberg.com/accountlabplus.php

============
SQL:"ALTER TABLE order_conf ADD u_invoice_date INT( 3 ) NOT NULL DEFAULT '90'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE order_conf ADD build INT( 11 ) NOT NULL DEFAULT '1' ";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE order_conf ADD ask_login_info ENUM( '1', '0' ) NOT NULL ";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE sub_order ADD cat_id INT( 11 ) NOT NULL DEFAULT '1' AFTER parent_id";
MYSQL ERROR : 1146: Table 'cleardes_acclab.sub_order' doesn't exist
SQL:"ALTER TABLE tax CHANGE tax_amount tax_amount DECIMAL( 4, 2 ) NOT NULL DEFAULT '0.00'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.tax' doesn't exist
SQL:"ALTER TABLE customers ADD creation_date DATE NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.customers' doesn't exist
SQL:"UPDATE order_conf SET build='2'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:" CREATE TABLE extra_fields ( field_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , cust_id INT( 11 ) NOT NULL , sub_id INT( 11 ) NOT NULL , inv_no INT( 11 ) NOT NULL ) TYPE = MyISAM";
MYSQL ERROR : 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MyISAM' at line 8
SQL:"ALTER TABLE customers CHANGE discount discount DECIMAL( 4, 2 ) NOT NULL DEFAULT '0.00'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.customers' doesn't exist
SQL:"ALTER TABLE payment_log ADD posted_vars TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.payment_log' doesn't exist
SQL:"ALTER TABLE payment_log ADD payment_method VARCHAR( 25 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.payment_log' doesn't exist
SQL:"ALTER TABLE order_conf ADD en_html_editor ENUM( '1', '0' ) NOT NULL DEFAULT '1'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE invoices CHANGE transaction_id transaction_id VARCHAR( 255 ) NOT NULL DEFAULT '0'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.invoices' doesn't exist
SQL:"UPDATE order_conf SET build='3'";
MYSQL ERROR : 1146: Table 'cleardes_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE hosting_price ADD plan_friendly_name VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD activation_mail_template TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD suspended_mail_template TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD cpanel_reseller ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD cpr_profile_id INT( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD plesk_profile_id INT( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD cip ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD cgi ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD quota VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD frontpage ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD cp VARCHAR( 25 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxftp VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxsql VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxpop VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxlst VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxsub VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD bwlimit VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD hasshell ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxpark VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD maxaddon VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'cleardes_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE hosting_price ADD da_reseller ENUM( '0', '1', '2', '3' ) NOT NULL";
:
:
:
:
:
:
============

[Digin]

When you use a new version of MySQL, this errors occurs. The solution is to change all the text 'TYPE = MYISAM' to 'ENGINE = MYISAM' in the file \system\config\sqls.php