Database error UNA 9.0.0-RC11 Unknown column 'date' in 'order clause'
I am getting emails every few hours from my UNA server about the following error
Any solution to this ?
Thanks
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/path_to_una/inc/classes/BxDolSearch.php at line 684.
collation_connection:
utf8mb4_unicode_ci
-
Hello mkonline!
Please send me via Messenger the full letter with this error.
-
I get this error too. It happens with photos app and the videos app.
Query:
SELECT `bx_videos_entries`.`id` as `id`, `bx_videos_entries`.`title` as `title`, `bx_videos_entries`.`text` as `text`, `bx_videos_entries`.`duration`, `bx_videos_entries`.`thumb`, `bx_videos_entries`.`poster`, `bx_videos_entries`.`video`, `bx_videos_entries`.`author` as `author`, `bx_videos_entries`.`added` as `added`, `bx_videos_entries`.`views` FROM `bx_videos_entries` WHERE 1 AND `bx_videos_entries`.`status` ='active' AND `bx_videos_entries`.`status_admin` ='active' AND `bx_videos_entries`.`allow_view_to` IN(3) ORDER BY `date` DESC LIMIT 0, 12Mysql error:
Unknown column 'date' in 'order clause' -
Hey guys, you're sure all the modules are updated, be careful in some cases, there are several successive updates for the same module ...
-
Photos and Videos modules are version 9.0.4 with me...
-
Hi all!
Yes, 9.0.4 is the last version. So if someone will meet this error on your UNA site - send me please via Messenger the URL with the error and operator access. From my side I can't "catch" it :-)
