SQL Error: SELECT FROM sys_profiles ...

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.

  • View
    551
  • More
Replies (9)

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

          image_transcoder.php?o=bx_froala_image&h=796&dpx=1&t=1546769972

          • 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.

                    Server APICGI/FastCGI
                    Virtual Directory Supportdisabled
                    Configuration File (php.ini) Path/etc/php/7.3/cgi
                    Loaded Configuration File/etc/php/7.3/cgi/php.ini
                    Scan this dir for additional .ini files/etc/php/7.3/cgi/conf.d


                    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. 

                      Login or Join to comment.