I keep getting database errors

I keep getting database errors in my email. Does anyone know what this means?

Mysql error:

Unknown column 'date' in 'order clause'

  • 354
  • More
Replies (6)
    • Hello, you do not have more detail than that on the error?

      • 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

        • There is no column named 'date' in the `bx_photos_entries` table. Not sure if this is a coding issue or if you manually changed any of the search functions. 

          zwfadnfeqsimpt95v9tphihgfqfdrhan.png

          • I didn't change anything. These errors have been coming up every week or so.

            • So you don't get these DB errors all the time then right? Does the photo module work OK? Do you happen to know WHEN it is you get that error? Such as, when you actually try to search the photos?

              • I got errors like this on videos and photos on these dates:

                Aug 11, 12, 15, 16, 25, 26, 28, 29, 30

                Sept 1, 3, 5, 6, and today

                And its multiple error emails per day. It seems like it is just random.

                Login or Join to comment.