Search result is not full

Let us know how we are doing -

Search result is not full

Postby Bidouille » Wed Feb 07, 2018 7:43 pm

Hello,

If I try a search with https://forum.openoffice.org/en/forum/s ... ked+unknow
It results only one thread.
With a search engine, we have more:
https://www.qwant.com/?q=unknow+locked+ ... .org%2Fen&

Maybe a database reindex solve it
User avatar
Bidouille
Volunteer
 
Posts: 213
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Search result is not full

Postby RusselB » Wed Feb 07, 2018 11:49 pm

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.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
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.
RusselB
Volunteer
 
Posts: 4320
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search result is not full

Postby Hagar Delest » Wed Feb 07, 2018 11:55 pm

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.
AOO 4.1.5 on Xubuntu 18.04 and on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28025
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Search result is not full

Postby robleyd » Thu Feb 08, 2018 1:11 am

Seems to be two results now including this topic :-)
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1578
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Search result is not full

Postby RusselB » Thu Feb 08, 2018 2:21 am

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.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
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.
RusselB
Volunteer
 
Posts: 4320
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search result is not full

Postby robleyd » Thu Feb 08, 2018 2:51 am

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
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1578
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Search result is not full

Postby robleyd » Thu Feb 08, 2018 6:26 am

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   Expand viewCollapse view
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
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.1.5 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1578
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Site Feedback

Who is online

Users browsing this forum: No registered users and 2 guests