[Solved] Forum search by topics broken?

Let us know how we are doing -

[Solved] Forum search by topics broken?

Postby Hagar Delest » Thu Jan 04, 2018 10:22 pm

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.
Last edited by Hagar Delest on Wed Jan 10, 2018 11:33 pm, edited 1 time in total.
Reason: tagged [Solved].
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28291
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Forum search by topics broken?

Postby RoryOF » Thu Jan 04, 2018 10:24 pm

I confirm.

Perhaps an index problem arising from recent server disk transfers?
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27676
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Forum search by topics broken?

Postby Hagar Delest » Thu Jan 04, 2018 10:25 pm

Thanks Rory.
I thought so.
Will send a message on the dev ML.
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28291
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Forum search by topics broken?

Postby charlie.it » Thu Jan 04, 2018 10:50 pm

I confirm the same error message.
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 304
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Forum search by topics broken?

Postby charlie.it » Thu Jan 04, 2018 10:54 pm

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()
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 304
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Forum search by topics broken?

Postby Hagar Delest » Thu Jan 04, 2018 11:00 pm

Thanks. Same with the French forum, I've reported it to the list.
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28291
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Forum search by topics broken?

Postby Jan_J » Fri Jan 05, 2018 3:04 pm

PL as above
JJ ∙ http://forum.openoffice.org/pl/
LO (6.1|6.0) ∙ AOO 4.1.5 ∙ Python (3.7|2.7) ∙ Unicode 11 ∙ LᴬTeX 2ε ∙ XML ∙ Unix tools ∙ Linux (2.6|3.x) ∙ Fedora ∙ CentOS ∙ SUSE
Jan_J
 
Posts: 142
Joined: Wed Apr 29, 2009 1:42 pm
Location: Poland

Re: Forum search by topics broken?

Postby RPG » Fri Jan 05, 2018 6:29 pm

The Dutch forum does have the same problem.

Romke
LibreOffice 6.1.3.2 on openSUSE Leap 15
RPG
Volunteer
 
Posts: 2151
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Forum search by topics broken?

Postby Zizi64 » Fri Jan 05, 2018 8:22 pm

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; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
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
Zizi64
Volunteer
 
Posts: 7465
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Forum search by topics broken?

Postby Hagar Delest » Wed Jan 10, 2018 11:34 pm

For the record, it was a bug, fixed now.
AOO 4.1.6 on Xubuntu 18.10 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28291
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] Forum search by topics broken?

Postby charlie.it » Thu Jan 11, 2018 8:58 am

Thanks :super:
charlie
macOS 10.12 Sierra: Open Office 4.1.5 - LibreOffice 5.4.3.2
Windows 7 pro (VirtualBox): Open Office 4.1.5 - LibreOffice 5.4.4.2
Ubuntu 17.04 LTE (VirtualBox): LibreOffice 5.1.6.2
http://www.charlieopenoffice.altervista.org
User avatar
charlie.it
Volunteer
 
Posts: 304
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy


Return to Site Feedback

Who is online

Users browsing this forum: No registered users and 3 guests