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
)
)