Short word limit for vB search

Status
Not open for further replies.

Yashraj

Active Member
558
2012
155
0
Hi, vbulletin forums don't allow you to search for short words or common words and thus giving this error:

The following words are either very common, too long, or too short and were not included in your search

Has any solution to it invented?
 
1 comment
The minimum and maximum length of words to be indexed is defined by the ft_min_word_len and ft_max_word_len system variables (available as of MySQL 4.0.0). See Section 5.3.3, “Server System Variables”. The default minimum value is four characters. The default maximum depends on your version of MySQL. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you need to edit my.cnf (or my.ini on Windows systems) and set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes. Also note particularly the remarks regarding myisamchk in the instructions following this list.

http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html
 
Status
Not open for further replies.
Back
Top