General Error
SQL ERROR [ mysqli ]
Expression #1 of ORDER BY clause is not in SELECT list, references column 'forumaoo_en.t.topic_last_post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]
SQL
SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM phpbb_en_topics t, phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY t.topic_last_post_time DESC LIMIT 250
The same search works fine when it is to be displayed as posts.
Last edited by Hagar Delest on Wed Jan 10, 2018 11:33 pm, edited 1 time in total.
Reason:tagged [Solved].
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Errore Generale
SQL ERROR [ mysqli ]
Expression #1 of ORDER BY clause is not in SELECT list, references column 'forumaoo_it.t.topic_last_post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]
SQL
SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM phpbb_it_topics t, phpbb_it_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST ('+Base ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY t.topic_last_post_time DESC LIMIT 250
BACKTRACE
FILE: x1/var_lib_phpBB/com309/includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: x1/var_lib_phpBB/com309/includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()
FILE: x1/var_lib_phpBB/com309/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: x1/var_lib_phpBB/com309/includes/search/fulltext_mysql.php
LINE: 472
CALL: dbal->sql_query_limit()
FILE: x1/var_lib_phpBB/com309/search.php
LINE: 508
CALL: fulltext_mysql->keyword_search()
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
Expression #1 of ORDER BY clause is not in SELECT list, references column 'forumaoo_hu.t.topic_last_post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]
SQL hiba lépett fel az oldal generálása közben. Ha a probléma továbbra is fennállna, lépj kapcsolatba a fórum adminisztrátorával.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.