vijuga
 added a discussion 


I have included in the Zend Opcache Cpanel.  I got an email as soon as I saved the settings.

Please help

Database error in Vijuga


Query:
SELECT FROM `bx_albums_albums` WHERE 1 AND `bx_albums_albums`.`author` ='1688' AND `bx_albums_albums`.`status` ='active' AND `bx_albums_albums`.`status_admin` ='active' ORDER BY `bx_albums_albums`.`added` DESC LIMIT 0, 12

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 `bx_albums_albums` WHERE 1 AND `bx_albums_albums`.`author` ='1688' AND `bx_' at line 1

Location:
The error was found in getAll function in the file /home/vijugaco/public_html/inc/classes/BxDolSearch.php at line 684.

collation_connection:
utf8mb4_unicode_ci

Debug backtrace:

  • 312
Comments
  • Hello vijuga !

    This error means that no fields were chosen for the selection. Please specify what changes did you make recently with your Albums fields and in what page you see the message "Database error"?

    0 0 0 0 0 0
    • LeonidS

      I didn't touch anything on the albums.


      As the problem arose

      1.First time I included PHP accelerators in Cpale ie (Zend Opcache (ex. Zend Optimizer +))


      2. A few minutes later I received an email with this message

      "Database error in Swirl


      Query:

      SELECT FROM `bx_albums_files2albums` INNER JOIN` bx_albums_albums` ON `bx_albums_albums`.`id` =` bx_albums_files2albums`. 1 AND `bx_albums_files2albums`.`content_id` = '41 'ORDER BY` bx_albums_files2albums`.`order` ASC, `bx_albums_files2albums`.`id` ASC LIMIT 0, 12


      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 `bx_albums_files2albums` INNER JOIN` bx_albums_albums` ON `bx_albums_albu' at line 1


      Location:

      The error was found in getAll function in the file /home/vijugaco/public_html/inc/classes/BxDolSearch.php at line 684.


      collation_connection:

      utf8mb4_unicode_ci


      Debug backtrace: "

      0 0 0 0 0 0
      • Please go to Studio > Albums and the check the following setting, at least one checkbox must be checked here:

        0 0 0 0 0 0
        • Alex T,


          I just made this opt and again comes an email with the same content


          0 0 0 0 0 0
          • Do you have any modifications in any files ?

            0 0 0 0 0 0

            • The only thing I've been doing is turning on this PHP accelerator and I'm getting those messages right away

              0 0 0 0 0 0
              • Could you please provide Studio access to your site to check this problem ?

                0 0 0 0 0 0
                • It looks like bug - https://github.com/unaio/una/issues/2299

                  Thank you for the report

                  0 0 0 0 0 0
                  Not logged in users can't 'Comments Post'.
                  Info

                  UNA - Social Media Software Framework

                  Close