Problem with phpBB search

[LuuLa]

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.

[Mick]

Please fill out the Support Request Template and post it back here to enable us to assist you better.

[LuuLa]

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

[KevC]

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.

[LuuLa]

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.

[KevC]

That works too

[LuuLa]

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?