Problem with phpBB search

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Post Reply
User avatar
LuuLa
Registered User
Posts: 110
Joined: Thu Feb 19, 2004 4:25 pm

Problem with phpBB search

Post by LuuLa » Mon May 21, 2018 4:57 pm

Hello. I created a new post with just this content:

Code: Select all

[url=https://www.someTLD.com/folder/someHTMLpage_12345.html]Some Text[/url]
When I now search for "1 2 3 4 5" (without spaces), the search does not return this new post. I even do not find this post when I search for "1 2 3 4 5" (without spaces) here, on phpbb.com What can I do to find it? Please help.
Last edited by LuuLa on Mon May 21, 2018 7:06 pm, edited 1 time in total.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Problem with phpBB search

Post by Mick » Mon May 21, 2018 6:38 pm

Please fill out the Support Request Template and post it back here to enable us to assist you better.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

User avatar
LuuLa
Registered User
Posts: 110
Joined: Thu Feb 19, 2004 4:25 pm

Re: Problem with phpBB search

Post by LuuLa » Mon May 21, 2018 7:05 pm

Support Request Template
What version of phpBB are you using? phpBB 3.1.1
What is your board's URL? No answer given
Who do you host your board with? superb.net
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? as provided
What language(s) is your board currently using? english
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Nothing
Please describe your problem. Hello. I created a new post with just this content:

Code: Select all

[url=https://www.someTLD.com/folder/someHTMLpage_12345.html]Some Text[/url]
When I now search for "1 2 3 4 5" (without spaces), the search does not return this new post. I even do not find this post when I search for "1 2 3 4 5" (without spaces) here, on phpbb.com What can I do to find it? Please help.
Generated by SRT Generator

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68024
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Problem with phpBB search

Post by KevC » Mon May 21, 2018 7:08 pm

Yes it does

The search on this site takes a little time to catch up. I think it's a few hours behind the post time due to the way the search tables are indexed on here.
Attachments
Screen Shot 2018-05-21 at 20.07.38.png
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
LuuLa
Registered User
Posts: 110
Joined: Thu Feb 19, 2004 4:25 pm

Re: Problem with phpBB search

Post by LuuLa » Mon May 21, 2018 7:11 pm

I did a mistake, using the string "1 2 3 4 5" (without spaces) in my previous posts, so it was indexed and could be found. Later on, I changed that to "1 2 3 4 5". But we could reproduce it by using:

Code: Select all

[url=https://www.someTLD.com/folder/someHTMLpage_67890.html]Some Text[/url]
Some Text

Search for the 5 digits in the code above.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68024
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Problem with phpBB search

Post by KevC » Mon May 21, 2018 8:05 pm

That works too
Attachments
Screen Shot 2018-05-21 at 21.05.12.png
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
LuuLa
Registered User
Posts: 110
Joined: Thu Feb 19, 2004 4:25 pm

Re: Problem with phpBB search

Post by LuuLa » Tue May 22, 2018 3:57 pm

KevC wrote:
Mon May 21, 2018 8:05 pm
That works too
Strange. But it does not work on my board. So I catched the SQL statement from includes/search/fulltext_mysql.php and entered it "by hand" on phpAdmin. It was

Code: Select all

SELECT p.post_id FROM phpbb_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST ('+12345 ' IN BOOLEAN MODE) AND (p.post_approved = 1 OR p.forum_id NOT IN (13, 15, 17, 18, 25, 26, 27, 32, 37, 38, 39, 44, 47, 51, 56, 63, 64, 68, 69, 70, 71, 72, 73, 76, 77, 78, 80, 87, 89, 95, 97, 99, 103)) ORDER BY p.post_time DESC
Then, I entered a much simpler SQL search:

Code: Select all

SELECT p.post_id FROM phpbb_posts p WHERE p.post_text LIKE '%12345%' AND (p.post_approved = 1 OR p.forum_id NOT IN (13, 15, 17, 18, 25, 26, 27, 32, 37, 38, 39, 44, 47, 51, 56, 63, 64, 68, 69, 70, 71, 72, 73, 76, 77, 78, 80, 87, 89, 95, 97, 99, 103)) ORDER BY p.post_time DESC
This gave me the post_id I was looking for!


Maybe, it has something to do with the indexing? Where can I find the indexing process?

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 20 guests