Wordpress Themes - WP Forum at BFA
There will be no more development for Atahualpa (or any other theme), and no support. Also no new registrations. I turned off the donation system. I may turn the forum to read only if it gets abused for spam. Unfortunately I have no time for the forum or the themes. Thanks a lot to the people who helped in all these years, especially Larry and of course: Paul. Take care and stay healthy -- Flynn, Atahualpa developer, Sep 2021

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

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


  #1  
Old Apr 21, 2009, 05:41 AM
Flynn's Avatar
Flynn
 
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

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:	2724
Size:	21.5 KB
ID:	92  Click image for larger version

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

Name:	vbulletin-repair-tables.gif
Views:	2784
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 09:58 PM.


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