WHMCS 8.2.1 migration error

[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.

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
        )

)

 

[linux4me]

I think this means you need to activate and configure the Support Manager plugin (Settings > Plugins > Available > Support Manager) before doing the import.