Documentation Code Eelctrolab | Authentification Git HTTP/S

Skip to content

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()