ambitionen

  •  ·  Premium
  • 1 friends
  • R

    3 followers
  • 484 views
Add new...
 
 
·
Added a discussion

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, 24

Mysql 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 1

Location:
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
·
Added a discussion

When I try to add fields to e.g. organization an error message comes "A name with at least 3 characters is required"
So whatever I enter it is not accepted
Also the type changes ... I wanted TEXT and it displays BLOCK HEADER

  • 417
ambitionen Discussions
SQL Error: SELECT FROM sys_profiles ...
Adding fields