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.
Hello ambitionen!
I'm a little confused with MariaDB, but to check your trouble I need to have the operator and Control Panel access of your server where UNA was installed. Please provide it to me via Messenger.
ambitionen Just open the file BxDolSearch.php and search for the line
$this->aClasses = BxDolDb::getInstance()->fromCache('sys_objects_search', 'getAllWithKey',
Replace the next few lines with the code below
'SELECT `ID` as `id`,
`Title` as `title`,
`ClassName` as `class`,
`ClassPath` as `file`,
`ObjectName`,
`GlobalSearch`
FROM `sys_objects_search`
ORDER BY `Order` ASC', 'ObjectName'
Save and upload to your server in ****/inc/classes folder
Where is the difference ?? Seems to be the same (top SQL is the original from install)
R
I have the same error :-( Fresh install one User.
MySQL = 5.7.24
Hello Ralf!
And what PHP version has your serve with UNA? In the previous case, the most possible "too new PHP version" (7.3), waiting now his check with more usual.
R
Hello Leonid,
my PHP version is 7.3.1
was away this week and still pretty busy, so need another 2 or 3 days to go back to php 7.2. on my server. Will inform in this thread whether it was solved
Tried to downgrade from 7.3 to 7.2 ... so added 7.2. parallel ... but switching from 7.3. to 7.2. did not work.
Anyhow to my surprise its now working.
Maybe upgrading 7.3. modules did help, only idea I have for the moment
HI ambitionen!
No, we've applied a temporary fix, so an upgrade to PHP 7.3.1 doesn't relate to this problem (). Please continue to check your site properly.
So @Ralf - please "downgrade" if possible too.