Page 1 of 1

[Solved] Forum search by topics broken?

PostPosted: 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   Expand viewCollapse view
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?

PostPosted: 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?

PostPosted: 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?

PostPosted: Thu Jan 04, 2018 10:50 pm
by charlie.it
I confirm the same error message.

Re: Forum search by topics broken?

PostPosted: Thu Jan 04, 2018 10:54 pm
by charlie.it
Also in the Italian forum:
Code: Select all   Expand viewCollapse view
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?

PostPosted: 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?

PostPosted: Fri Jan 05, 2018 3:04 pm
by Jan_J
PL as above

Re: Forum search by topics broken?

PostPosted: Fri Jan 05, 2018 6:29 pm
by RPG
The Dutch forum does have the same problem.

Romke

Re: Forum search by topics broken?

PostPosted: 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?

PostPosted: 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?

PostPosted: Thu Jan 11, 2018 8:58 am
by charlie.it
Thanks :super: