Forum

Fatale : invalid query. (ERRNO 1054) Unknown column 'note.average_notes' in 'order clause'query: SELECT g.id, g.idcat, g.name, g.path, g.timestamp, g.aprob, g.width, g.height, g.user_id, g.views, g.aprob, m.login, m.user_groups, m.level, notes.average_notes, notes.number_notes, note.note

FROM phpboost_gallery g

LEFT JOIN phpboost_member m ON m.user_id = g.user_id

LEFT JOIN phpboost_comments_topic com ON com.id_in_module = g.id AND com.module_id = 'gallery'

LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = g.id AND notes.module_name = 'gallery'

LEFT JOIN phpboost_note note ON note.id_in_module = g.id AND note.module_name = 'gallery' AND note.user_id = -1

WHERE g.idcat = '1' AND g.aprob = 1

ORDER BY note.average_notes DESC

LIMIT 16 OFFSET 0





[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:49 - MySQLQuerier->execute(string, array)

[1] /kernel/framework/io/db/DBQuerier.class.php:51 - MySQLQuerier->select(string, array, int)

[2] /kernel/framework/db/Sql.class.php:584 - DBQuerier->select(string, array, int)

[3] /kernel/framework/db/Sql.class.php:191 - Sql->select(string)

[4] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:511 - Sql->query_while(string, int, string)

[5] /gallery/phpboost/GalleryHomePageExtensionPoint.class.php:39 - GalleryHomePageExtensionPoint->get_view()

[6] /gallery/gallery.php:288 - GalleryHomePageExtensionPoint->get_home_page()