Wordpress Themes - WP Forum at BFA
Click here to register or to donate.
Auto self-registration is not available here - far too many spammers. This forum has many, many backlinks and because of that there is an intense desire among spammers to drop their links here.

Wordpress Themes - WP Forum at BFA » Forum Usage » Forum How-To »

How to enable 3-letter-words in Vbulletin w/ MySQL fulltext search

Old Apr 21, 2009, 05:41 AM
Flynn's Avatar
3,768 posts · Oct 2008
Munich, Germany
I just did this on the forum here and thought I'd share my findings:

Note: This has nothing to do with WordPress. This is for the forum software "VBulletin"

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 attached image #1)

2. At Vbulletin Options -> Message Searching Options -> Search Index Minimum Word Length put 3 into the text field

(see attached 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


In 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 attached image #3)

5. At Maintenance -> Update Counter -> Rebuild Search Index, click on "Click Here to do so!" and then on Rebuild Search Index

Attached Thumbnails
Click image for larger version

Name:	vbulletin-searchtype.gif
Views:	1939
Size:	21.5 KB
ID:	92  Click image for larger version

Name:	vbulletin-message-searching-options.gif
Views:	1913
Size:	42.8 KB
ID:	93  Click image for larger version

Name:	vbulletin-repair-tables.gif
Views:	1975
Size:	42.2 KB
ID:	94  


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
How enable comment for pages ? (bytesforall theme) claudio4j Comments, trackbacks & pings 8 Feb 28, 2012 07:00 PM
Wordpress and VBulletin DanGarion Installing & running WordPress 2 Jul 11, 2009 08:21 AM
[SOLVED] Available Widgets -- Which Should I Enable fromtheranks Sidebars & Widgets 6 Jun 8, 2009 12:07 AM
First-letter styling? lilycarver Forum How-To 1 May 27, 2009 07:54 AM
3-letter words can now be used in search Flynn Forum How-To 0 Apr 21, 2009 05:37 AM

All times are GMT -6. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.