Issues with searching on PCF site
Issues with searching on PCF site
Hi
Just want to find out if I am the only one with this issue. I click the "profile" button (under everyones posts) and there you have an option to "Search all users posts". All OK thus far. I get a list of say, 20 odd last posts made by that member. When I click the page numbers at the bottom to see whats on the next pages I get "No topics or posts met your search criteria".
This is not only on that feature... if you search just about anything else using the search-engine what ever is on another page will give that message...
Help?
Just want to find out if I am the only one with this issue. I click the "profile" button (under everyones posts) and there you have an option to "Search all users posts". All OK thus far. I get a list of say, 20 odd last posts made by that member. When I click the page numbers at the bottom to see whats on the next pages I get "No topics or posts met your search criteria".
This is not only on that feature... if you search just about anything else using the search-engine what ever is on another page will give that message...
Help?
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
OK, I've done some research into the phpBB 2 search algorithm, and it may not be even worth bothering to fix this. For the time being.
The search function of phpBB uses 3 tables:
My feeling is to ignore this problem for now and revisit it when we look into migrating to phpBB 3. Two reasons for this: firstly, phpBB 3 has a better search algorithm for large boards (which is a mysql fulltext search option), and secondly, the search index has to be recreated from scratch anyway when converting, so it doesn't really make sense to rebuild it now.
The search function of phpBB uses 3 tables:
- search_wordlist (this contains a unique entry for each word that has been posted in the forum)
- search_wordmatch (this contains pairs of data of which posts include which words from the search_wordlist)
- search_results (this contains the last searches the users executed)
My feeling is to ignore this problem for now and revisit it when we look into migrating to phpBB 3. Two reasons for this: firstly, phpBB 3 has a better search algorithm for large boards (which is a mysql fulltext search option), and secondly, the search index has to be recreated from scratch anyway when converting, so it doesn't really make sense to rebuild it now.
Kia kaha, Kia māia, Kia manawanui.
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
I don't know yet.I34z1k wrote:Out of curiousity, when do you plan to change to phpBB 3?
It's a real mission. We're looking at the forum being out of commission for an entire weekend at MINIMUM, folks. This is, once again, due to the sheer size of the forum.I34z1k wrote:How much of a mission is it going to be to do the crossover?
Kia kaha, Kia māia, Kia manawanui.
schase wrote:<ot>
Ronald, do you have any experience at all with Fireboard?
</ot>
psst who is Ronald?
"Integrity" and "integer" both contain a Latin root meaning "whole; complete." The root sense, then, is that people may be said to be acting with integrity when their beliefs, words, and actions have a sense of unity or wholeness.
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
jee wrote:schase wrote:<ot>
Ronald, do you have any experience at all with Fireboard?
</ot>
psst who is Ronald?
And yes, I have been called Ronald McDonald before.
To answer schase's question: no, never used it. I can play around with it though, but that will only be when I have a few hours of free time - something that's a bit lacking right now.
Kia kaha, Kia māia, Kia manawanui.
There's 2 search functions on the site. The one at the top works for forum posts, the other one (on the left) looks for submitted articles and news. They work for me, although I think it needs to be tuned for quotations for even more accurate searches.
Search by user forum posts by post and with "the" or "a" as the keywords. It doesn't like blank, RON please change this on PHPBB3?
How big is the database? I remember Cameron said it was 100MB. But going to PHPBB3 probably means changing table structures and some good T-SQL knowledge to do the conversion. Maybe a fresh BB3 install is needed as a dual boot option and you can slowly pull the data across from the BB2 tables. MySQL Administrator is an excellent tool for MySQL databases, you can even use a windows PC to connect to the database engines, the frontend is good and works in Linux.
Search by user forum posts by post and with "the" or "a" as the keywords. It doesn't like blank, RON please change this on PHPBB3?
How big is the database? I remember Cameron said it was 100MB. But going to PHPBB3 probably means changing table structures and some good T-SQL knowledge to do the conversion. Maybe a fresh BB3 install is needed as a dual boot option and you can slowly pull the data across from the BB2 tables. MySQL Administrator is an excellent tool for MySQL databases, you can even use a windows PC to connect to the database engines, the frontend is good and works in Linux.
DFI LanParty X48 LT-2TR
Intel Q9450 @ 3.2Ghz
Dell 24" 2408WFP | Phillips 37" 1080p
Sapphire HD4870 X2 2GB
4GB Corsair DDR-2 1066 | Thermalrite 120 Ultra Extreme | G9 Mouse | G15 Keyboard
Vista Ultimate x64
Intel Q9450 @ 3.2Ghz
Dell 24" 2408WFP | Phillips 37" 1080p
Sapphire HD4870 X2 2GB
4GB Corsair DDR-2 1066 | Thermalrite 120 Ultra Extreme | G9 Mouse | G15 Keyboard
Vista Ultimate x64
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
The search index won't index words that it regards as common. The mysql fulltext search option introduced with phpBB 3 may make this better though.Hex_Rated wrote:Search by user forum posts by post and with "the" or "a" as the keywords. It doesn't like blank, RON please change this on PHPBB3?
At the time of me posting this, it's around 580MB. The posts and posts_text tables (290MB combined) as well as the aforementioned search_wordmatch table (193MB and 12.8 million rows) are the main culprits. (And you wonder why I said that the search algorithm doesn't scale well on large boards?)Hex_Rated wrote:How big is the database? I remember Cameron said it was 100MB.
The phpBB developers did write a conversion script to do this. You have to install a fresh copy of phpBB 3, then run the conversion script. All it does is populate the phpBB 3 tables and copy additional files (such as the avatars) across. It leaves the old database untouched. Obviously you would disable the old forum while you run the conversion, otherwise you'll end up with inconsistent data.Hex_Rated wrote:But going to PHPBB3 probably means changing table structures and some good T-SQL knowledge to do the conversion. Maybe a fresh BB3 install is needed as a dual boot option and you can slowly pull the data across from the BB2 tables
I did mention the problem earlier though - on large boards, it takes a while. A very long while.
Kia kaha, Kia māia, Kia manawanui.