Bug lors d'une recherche dans les nouveaux messages
SQL ERROR [ postgres ]
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 5: ORDER BY t.topic_last_post_time DESC ^ []
SQL
SELECT DISTINCT t.topic_id FROM phpbb_topics t, phpbb_posts p WHERE (to_tsvector ('french', p.post_subject || ' ' || p.post_text) @@ to_tsquery ('french', 'fsdf ')) AND t.topic_id = p.topic_id AND (p.post_visibility = 1 OR p.forum_id IN (5, 7, 9, 10, 11, 12, 13, 15, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 45, 46, 47, 48, 49, 50, 51, 53, 54, 55, 56)) ORDER BY t.topic_last_post_time DESC LIMIT 250 OFFSET 0
BACKTRACE
FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 855 CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/postgres.php LINE: 191 CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/postgres.php LINE: 250 CALL: phpbb\db\driver\postgres->sql_query()
FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 261 CALL: phpbb\db\driver\postgres->_sql_query_limit()
FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 321 CALL: phpbb\db\driver\driver->sql_query_limit()
FILE: [ROOT]/phpbb/search/fulltext_postgres.php LINE: 542 CALL: phpbb\db\driver\factory->sql_query_limit()
FILE: [ROOT]/search.php LINE: 565 CALL: phpbb\search\fulltext_postgres->keyword_search()