General Error

SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'live_forum.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]

SQL

SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_posts p WHERE p.poster_id = 5416 AND (p.forum_id NOT IN (23, 25, 28) AND p.post_visibility = 1) AND p.forum_id NOT IN (23, 25, 28) ORDER BY p.post_time DESC

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/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/search/fulltext_native.php
LINE: 1197
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/search.php
LINE: 550
CALL: phpbb\search\fulltext_native->author_search()

Please notify the board administrator or webmaster: contact@trials.com.au