Search the Community

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

Whenever I try to log in to the Staff Area with correct Admin Creditionals (correct username and password) I am immediately forced-logged out. Any help? Any suggestions?

Hello, I am using Fraudlabs Pro for fraud prevention on my Blesta install. I noticed, on each order I receive I get at least 3 email's (Usually more) from FLP saying I have a transaction pending review. In turn, all of my Fraudlabs Pro credits (Free plan 500 credits) get eaten up with only 100-125 order's. Has anyone else noticed this or does anyone know of a fix? Thanks, Cam

i have blesta trial license. in this month,my all invoices has been generated with Wrong Currency . My Country's currency is LKR but all are generated with $ Sign Please see my attachment