cashcorp
Regular Member
- Feb 8, 2008
- 474
- 288
<<<Stupid for not figuring this out on his own
-
Please take a moment to look over the Suggestions & Feedback rules before making a post: READ RULES HERE
BHW Search sucks :(
- Thread starter flow
- Start date
<<<Stupid for not figuring this out on his own
popzzz
Supreme Member
- Apr 12, 2009
- 1,314
- 13,986
I'm resurrecting this OLD thread because the topic is STILL current and pertinent today.
I specifically made a post on how to fix this (that was deleted) as well.
We desperately need the ability to make SPECIFIC quoted searches to search the vast amount of resources here on BHW that is growing larger every day!
As already pointed out we CANNOT make a specific "and" search that would bring back the limited specific results we desire such as "ebay secrets revealed" for example because until the fulltext search engine is enabled the results will be anything with ANY of the THREE of the words in the subject with could be hundreds and just renders it USELESS!
Sweetfunny has kindly pointed out how to do it so can someone not get the job done?
If it will help any I would gladly help get it straightened out as I am sure others would as well..
In addition to Sweetfunny's post on how to enable the fulltext search engine there is a link on How to enable 3-letter-words in Vbulletin w/ MySQL fulltext search that I can't post because it goes to another forum so I will try to post the details here.
Here goes:
You will need access to the MySQL my.cnf configuration file and be able to restart the MySQL server to apply the changes. On a shared hosting account you will most likely not be able to do this unless you have a control panel that allows you to edit the MySQL configuration
1. Make sure Vbulletin Options -> Search Type is set to MySQL full text search. Note: "Search Type" is an extra menu item in the vertical menu on the left side
(see image #1)
2. At Vbulletin Options -> Message Searching Options -> Search Index Minimum Word Length put 3 into the text field
(see image #2)
Edit May 1, 2009: This step 2. may be not necessary as it relates to the VBulletin default search and not the MySQL fulltext search.
3. Now to the hard part. Edit your MySQL's my.cnf file to add this
Code:
[mysqld]
ft_min_word_len=3
[myisamchk]
ft_min_word_len=3In Centos/Linux my.cnf is located at /etc/my.cnf. In FreeBSD it is at /usr/local/etc/my.cnf.
Save the edited my.cnf and restart the MySQL server.
4. Back in Vbulletin, at Maintenance -> Repair/Optimize Tables, select the "Post" and the "Thread" table and click "Continue". I selected all tables at this stage as it won't hurt to check/optimize them all.
(see image #3)
5. At Maintenance -> Update Counter -> Rebuild Search Index, click on "Click Here to do so!" and then on Rebuild Search Index
HTH .... :cool2:
masterwaldo
Registered Member
- Jul 3, 2008
- 95
- 50
It's not just BHW search suck. I think all forum that I went, their search is always suck. But I usually just use google search to look for anything in BHW.
This is how I do, and it can be applied to any forum or any website:
And if I couldn't find any, I put quotes:
Usually, I always get what I want.
This is how I do, and it can be applied to any forum or any website:
And if I couldn't find any, I put quotes:
Usually, I always get what I want.