Query:
SELECT FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sys_profiles`.`content_id` INNER JOIN `sys_accounts` ON `sys_accounts`.`id`=`sys_profiles`.`account_id` WHERE 1 AND `sys_profiles`.`status` ='active' AND `sys_profiles`.`type` ='bx_persons' ORDER BY `bx_persons_data`.`added` DESC LIMIT 0, 24Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `sys_profiles` INNER JOIN `bx_persons_data` ON `bx_persons_data`.`id`=`sy' at line 1Location:
The error was found in getAll function in the file /****/inc/classes/BxDolSearch.php at line 684.collation_connection:
utf8mb4_unicode_ci
Its a fresh install with 3 users, actually I re-installed and to same error.
- 541