Jump to content

kztneda

Members
  • Posts

    1
  • Joined

  • Last visited

kztneda's Achievements

  1. 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 ) )
×
×
  • Create New...