Hi all, I've installed Blesta to give it a try but when I tried to do an import from my WHMCS installation It gives me errors. I've been looking on the web about this kind of error but I can't solve it yet, does any one knows what is happening?
I have CentOS 8, mysql 8.0.21
I've even modified the blesta.php in DB config to this, but it did not works.
Configure::set('Blesta.database_info',['driver'=>'mysql','host'=>'localhost','port'=>'3306','database'=>'DBNAME','user'=>'DBUSER','pass'=>'DBPASS','persistent'=>false,'charset_query'=>"SET NAMES 'utf8'",//'sqlmode_query' => "SET sql_mode='TRADITIONAL'", //this is the original'sqlmode_query'=>"SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''))",// here is what I changed//'sqlmode_query' => "SET sql_mode=''", // I tried this too'options'=>[]]);
Most of the tables of WHMCS are imported well but this don't.
This is the import log on debug mode:
decrypted 30 values using WHMCS' custom algorithm
decrypt took: 0.0005 seconds
total time took: 7.3194 seconds
Array
(
[error] => Array
(
[0] =>
[1] => importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DBNAME.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
[2] => importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196
[3] => 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
)
)
Question
kztneda
Hi all, I've installed Blesta to give it a try but when I tried to do an import from my WHMCS installation It gives me errors. I've been looking on the web about this kind of error but I can't solve it yet, does any one knows what is happening?
I have CentOS 8, mysql 8.0.21
I've even modified the blesta.php in DB config to this, but it did not works.
Most of the tables of WHMCS are imported well but this don't.
This is the import log on debug mode:
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.