cannot migrate from whmcs 8.1

[screege]

Hi im testing blesta because of license issues with whmcs, when tryin to import with 8.0 I only get this instantly my whmcs is 8.1:

 

importClients: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #58 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sgx_billing.tblusers.email' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196

importContacts: 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 `tblclients`, `tblcontacts` LEFT JOIN `tblcurrencies` ON `tblcurrencies`.' at line 1 on line 196

importTaxes: 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 `tblclients`, `tblcontacts`, `tbltax` LEFT JOIN `tblcurrencies` ON `tb' at line 1 on line 196

importCurrencies: 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 `tblclients`, `tblcontacts`, `tbltax`, `tblcurrencies` LEFT JOIN `t' at line 1 on line 196

importInvoices: 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 `tblclients`, `tblcontacts`, `tbltax`, `tblcurrencies`, `tblconf' at line 1 on line 196

importTransactions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importPackageOptions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importServices: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importDomains: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importAffiliates: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

 

Can anyone help?

 

Regards,

[Paul]

On 6/23/2023 at 7:23 AM, screege said:

Hi im testing blesta because of license issues with whmcs, when tryin to import with 8.0 I only get this instantly my whmcs is 8.1:

 

importClients: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #58 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sgx_billing.tblusers.email' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196

importContacts: 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 `tblclients`, `tblcontacts` LEFT JOIN `tblcurrencies` ON `tblcurrencies`.' at line 1 on line 196

importTaxes: 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 `tblclients`, `tblcontacts`, `tbltax` LEFT JOIN `tblcurrencies` ON `tb' at line 1 on line 196

importCurrencies: 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 `tblclients`, `tblcontacts`, `tbltax`, `tblcurrencies` LEFT JOIN `t' at line 1 on line 196

importInvoices: 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 `tblclients`, `tblcontacts`, `tbltax`, `tblcurrencies`, `tblconf' at line 1 on line 196

importTransactions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importPackageOptions: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importServices: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importDomains: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importAffiliates: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 196

 

Can anyone help?

 

Regards,

only_full_group_by needs to be disabled. This is listed in the 3rd yellow info box from the top on the requirements page here https://docs.blesta.com/display/user/Requirements