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, 12

Mysql error:
Unknown column 'date' in 'order clause'