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