Wordpress Themes - WP Forum at BFA
Click Here To DONATE! Support the theme development, get more attention and additional benefits based on your donation level. Your forum name will be highlighted.

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

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


Build custom WP THEMES, without
coding.
Click here for THEMEFRAME

From the author of Atahualpa, the #1 most
downloaded (700,000+) theme @ wordpress.org
  #1  
Old Apr 21, 2009, 05:41 AM
Flynn's Avatar
Flynn
 
3,765 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

Code:
[mysqld]
ft_min_word_len=3

[myisamchk]
ft_min_word_len=3
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:	976
Size:	21.5 KB
ID:	92  Click image for larger version

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

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

Bookmarks

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 05:56 AM.


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