'ad' is too short a word

[Carnage]

vborg search dosn't permit the word ad (and presumable ads) These are words people may search for wanting mods for ad managers/systems. Its a quick fix i think... can someone do it?

[HMBeaty]

Then again, if you put ad* it works ;)

[Paul M]

Its a quick fix i think... can someone do it?
No, it isnt, and no, we cant. :)

[mikey1991]

As redline put, you can make the search a wildcard search, by typing ads* or ad* as the asterix (* <- that thing there) makes it into a wildcard search and also helps make it pass the character limit :)

[imported_silkroad]

No, it isnt, and no, we cant. :)

Yes, it is easy to fix.

You can override the search limitation with individual words in a vB forum. For example, if the limitation is 3 letters but you want folks to be able to search for "ad" you just place the word "ad" in the inclusion list.

Can't be easier or quicker now can it? :D

[Marco van Herwaarden]

In that case please surprise us with your solution.

[Dismounted]

You can't override the server-level configuration for MySQL Fulltext Searching...

[imported_silkroad]

OK, be surprised. :D

The original poster said:

vborg search dosn't permit the word ad (and presumable ads) These are words people may search for wanting mods for ad managers/systems. Its a quick fix i think... can someone do it?

All the admins have to do is put the word "ad" in the "Words to be Included Despite Character Limit" section of the vB options.

(screenshot of vB AdminCP attached)

[imported_silkroad]

You can't override the server-level configuration for MySQL Fulltext Searching...

It is not difficult to change the server level configuration, for example see:

11.8. Full-Text Search Functions (http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html)

--------------- Added 1248094897 at 1248094897 ---------------

Actually, this is a better example reference:

11.8.6. Fine-Tuning MySQL Full-Text Search (http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html)

The minimum and maximum lengths of words to be indexed are defined by the ft_min_word_len and ft_max_word_len system variables. (See Section 5.1.3, “Server System Variables”.) The default minimum value is four characters; the default maximum is version dependent. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then you must restart the server and rebuild your FULLTEXT indexes. Note particularly the remarks regarding


Pretty easy, don't you agree?

--------------- Added 1248095090 at 1248095090 ---------------

I would venture to say that the entire change to the MySQL conf takes 15 seconds and the vB options config takes 15 seconds.

There will be a little more time for MySQL to rebuild the index after restart :-)

[Marco van Herwaarden]

OK, be surprised. :D

The original poster said:



All the admins have to do is put the word "ad" in the "Words to be Included Despite Character Limit" section of the vB options.

(screenshot of vB AdminCP attached)
The vB Options don't work if you are using MySQL Full text search, these options only work if you are using the vB internal search

[imported_silkroad]

Also, please note that another work-around that does not require any changes to vB or the MySQL configuration is to use Google site search.

(That is what we did, and it works great.)

So... there are many solutions to the problem, and all are pretty "quick and easy".

If you don't want to alter MySQL, then Google site search is a great alternative.

[Marco van Herwaarden]

We are not alone on this server. Changing the MySQL config would take a few minutes, rebuiolding the sewarch indexes would take a few days (!!!) and would leave all the Jelsoft sites offline during this.

[imported_silkroad]

The vB Options don't work if you are using MySQL Full text search, these options only work if you are using the vB internal search

So, then just alter the MySQL Full text search, LOL

It takes 15 seconds to make the change and a few minutes for MySQL to rebuild the index.

The issue is not "it is quick or easy" to do it. It seems you simply don't want to do it.

There is quite a difference in saying "it is not easy" versus "we don't want to do it".

--------------- Added 1248095946 at 1248095946 ---------------

The vB Options don't work if you are using MySQL Full text search, these options only work if you are using the vB internal search

(Or simply install Google site search, that is what we did, ROTFL... too easy)

--------------- Added 1248096434 at 1248096434 ---------------

We are not alone on this server. Changing the MySQL config would take a few minutes, rebuiolding the sewarch indexes would take a few days (!!!) and would leave all the Jelsoft sites offline during this.

Nonsense. Rebuilding a search index will not bring down this site. It is intensive, but will not bring down the site or sites. Do it on the weekend :-)

Anyway, to the original poster, it is obvious the site is not going to make any changes and will more-than-likely not install Google site search, so nevermind.. just do something with Google like:

ads site:vbulletin.org

--------------- Added 1248096832 at 1248096832 ---------------

For others interested in this for vB, the process to rebuild a vB MySQL fulltext search index is documented here:

How to enable 3-letter-words in Vbulletin w/ MySQL fulltext search (http://forum.bytesforall.com/showthread.php?t=1355)

... and no, it will not bring down your forum. That is why there are holidays and weekends :-)

[Wayne Luke]

Nonsense. Rebuilding a search index will not bring down this site. It is intensive, but will not bring down the site or sites. Do it on the weekend :-)

Not going to happen. All the official vBulletin sites would have to have their indexes rebuilt. Including the almost 1 million threads in the Support Ticket system and the customer database. Those systems will have to be taken offline until the indexes are rebuilt and that isn't something we're willing to do, even on a weekend and support knows no holidays. You will have to live with the limitations at this time.

[imported_silkroad]

Actually, it makes little difference to me, as I search with Google using site:blahblah.com . However, it makes a difference for many users on technical sites because 4 letters is way to short. Three letters is the recommended mininum for technical sites.

What most people do when they have production systems (and cannot risk building the index on line) is to simply rebuild the fulltext search index table on a development server and move the table(s) from development to production It is pretty easy to do this and well documented.