Comment to 'I keep getting database errors'
  • Query:

    SELECT `bx_photos_entries`.`id` as `id`, `bx_photos_entries`.`title` as `title`, `bx_photos_entries`.`text` as `text`, `bx_photos_entries`.`thumb`, `bx_photos_entries`.`author` as `author`, `bx_photos_entries`.`added` as `added`, `bx_photos_entries`.`views` FROM `bx_photos_entries` WHERE 1 AND `bx_photos_entries`.`status` ='active' AND `bx_photos_entries`.`status_admin` ='active' AND `bx_photos_entries`.`allow_view_to` IN(3) ORDER BY `date` DESC LIMIT 0, 12

    Mysql error:

    Unknown column 'date' in 'order clause'

    Location:

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

    collation_connection:

    utf8mb4_unicode_ci