Search result is not full

Let us know how we are doing -
Post Reply
Bidouille
Volunteer
Posts: 574
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Search result is not full

Post by Bidouille »

Hello,

If I try a search with search.php?st=0&sk=t&sd=d&sr=topics&key ... ked+unknow
It results only one thread.
With a search engine, we have more:
https://www.qwant.com/?q=unknow+locked+ ... e.org%2Fen&

Maybe a database reindex solve it
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search result is not full

Post by RusselB »

The first search is looking for the specific term "unknow" (without the quotation marks)
The second search is presuming that the search term should have a wildcard character at the end of the term. eg: unknow becomes unknow*, which matches the term unknow (as specified) and the term unknown (as matched with the wildcard)
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Search result is not full

Post by Hagar Delest »

Good catch!
I've relaunched the search index (414525 words) few minutes ago, Will see if there is any difference. But I guess not at all.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
robleyd
Moderator
Posts: 5037
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Search result is not full

Post by robleyd »

Seems to be two results now including this topic :-)
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search result is not full

Post by RusselB »

Since there appears to be a bit more than an hour from when Hagar relaunched the search index and Robleyd's post, I'm having to wonder if my earlier post isn't the actual problem.
Namely a non-wildcard search on the forum vs. A wildcard search using the 3rd party (website) search
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
robleyd
Moderator
Posts: 5037
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Search result is not full

Post by robleyd »

The evidence so far suggests you are correct RusselB. Having obviously too much time on my hands, I'm going to have a scratch through the source of phpBB and see if I can get a definitive answer.
 Edit: Seems my php skills have degraded from lack of use - didn't get an answer :-) 
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
User avatar
robleyd
Moderator
Posts: 5037
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Search result is not full

Post by robleyd »

Update: after applying a few more brain cells to the problem, I have a result.

Short answer - the search is for the actual word only.

Long answer: phpBB uses a table of words to store the words in posts and the count of those words. When a search is requested, the SQL query is thus (for the example search above):

Code: Select all

SELECT word_id, word_text, word_common
FROM phpbb_search_wordlist
WHERE word_text IN ('locked', 'unknow')
ORDER BY word_count ASC
The query result from that is then used with other queries to build the search result page information.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Post Reply