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,
