Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 4.12.1
-
Fix Version/s: Short Term
-
Component/s: Plugins
-
Labels:None
Description
The import manager no longer works for WHMCS version 8, probably due to changed implemented in that version that affect users.
Staff users are imported, but that's all.
Logs written during import:
==> /general-info-2020-10-19.log <==
[2020-10-19 20:18:52] general.INFO: Created Staff
[2020-10-19 20:18:52] general.INFO: Created Staff
{"user_id":"4","first_name":"Admin","last_name":"Three","email":"email2@address.com","status":"active","id":"3"}The following errors are displayed on the page:
The import completed but the following errors ocurred:
importClients: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY' on line 196
importContacts: There is already an active transaction on line 231
importTaxes: There is already an active transaction on line 231
importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
importInvoices: There is already an active transaction on line 231
importTransactions: There is already an active transaction on line 231
importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196
importPackageOptions: There is already an active transaction on line 231
importServices: There is already an active transaction on line 231
importSupportDepartments: There is already an active transaction on line 231
importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'blestau_whmcs.tbladmins.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196
importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196
importMisc: SQLSTATE[42000]: Syntax error or access violation: 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 '* FROM `tbltickets`, `tblaffiliates`, `tblconfiguration` LEFT JOIN `tbladmins` O' at line 1 on line 196
The importer should be backwards compatible with versions < 8, so if we need to add another link besides "5.2" for which the importer was originally designed, we should do that.. and if so, rename 5.2 to "5.2-7.10"