Page 1 of 1
[Solved] Forum search by topics broken?
Posted: Thu Jan 04, 2018 10:22 pm
by Hagar Delest
Has anyone experienced a failure of the advanced search when it is set to "display results as topics"?
I get for example:
Code: Select all
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.
Re: Forum search by topics broken?
Posted: Thu Jan 04, 2018 10:24 pm
by RoryOF
I confirm.
Perhaps an index problem arising from recent server disk transfers?
Re: Forum search by topics broken?
Posted: Thu Jan 04, 2018 10:25 pm
by Hagar Delest
Thanks Rory.
I thought so.
Will send a message on the dev ML.
Re: Forum search by topics broken?
Posted: Thu Jan 04, 2018 10:50 pm
by charlie.it
I confirm the same error message.
Re: Forum search by topics broken?
Posted: Thu Jan 04, 2018 10:54 pm
by charlie.it
Also in the Italian forum:
Code: Select all
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()
Re: Forum search by topics broken?
Posted: Thu Jan 04, 2018 11:00 pm
by Hagar Delest
Thanks. Same with the French forum, I've reported it to the list.
Re: Forum search by topics broken?
Posted: Fri Jan 05, 2018 3:04 pm
by Jan_J
PL as above
Re: Forum search by topics broken?
Posted: Fri Jan 05, 2018 6:29 pm
by RPG
The Dutch forum does have the same problem.
Romke
Re: Forum search by topics broken?
Posted: Fri Jan 05, 2018 8:22 pm
by Zizi64
The Hungarian forum has same problem.
Általános hiba
SQL ERROR [ mysqli ]
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.
Kérjük, értesítsd a fórum adminisztrátorát vagy a webmestert:
ooo-forum-hu-service@apache.org
Re: [Solved] Forum search by topics broken?
Posted: Wed Jan 10, 2018 11:34 pm
by Hagar Delest
For the record, it was a bug, fixed now.
Re: [Solved] Forum search by topics broken?
Posted: Thu Jan 11, 2018 8:58 am
by charlie.it
Thanks