[Solved] Forum search by topics broken?

Let us know how we are doing -
Post Reply
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

[Solved] Forum search by topics broken?

Post 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.
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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Forum search by topics broken?

Post by RoryOF »

I confirm.

Perhaps an index problem arising from recent server disk transfers?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Forum search by topics broken?

Post by Hagar Delest »

Thanks Rory.
I thought so.
Will send a message on the dev ML.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Forum search by topics broken?

Post by charlie.it »

I confirm the same error message.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Forum search by topics broken?

Post 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()
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Forum search by topics broken?

Post by Hagar Delest »

Thanks. Same with the French forum, I've reported it to the list.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Jan_J
Posts: 167
Joined: Wed Apr 29, 2009 1:42 pm
Location: Poland

Re: Forum search by topics broken?

Post by Jan_J »

PL as above
JJ ∙ https://forum.openoffice.org/pl/
LO (7.6) ∙ Python (3.11|3.10) ∙ Unicode 15 ∙ LᴬTEX 2ε ∙ XML ∙ Unix tools ∙ Linux (Rocky|CentOS)
RPG
Volunteer
Posts: 2250
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Forum search by topics broken?

Post by RPG »

The Dutch forum does have the same problem.

Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Forum search by topics broken?

Post 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
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.
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Forum search by topics broken?

Post by Hagar Delest »

For the record, it was a bug, fixed now.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: [Solved] Forum search by topics broken?

Post by charlie.it »

Thanks :super:
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
Post Reply