Site Problems??

[JET]

How about making the search so you can use 3 letter words? There are a lot of them that would be helpful, E85, Evo, etc.

[scheides]

Originally Posted by JET

How about making the search so you can use 3 letter words? There are a lot of them that would be helpful, E85, Evo, etc.

Good idea! I lowered it to 3. I can do 2 as well, if someone can think of a good reason why?

[asshanson]

Originally Posted by scheides

Good idea! I lowered it to 3. I can do 2 as well, if someone can think of a good reason why?

Isn't that a change in the MySQL database settings for full-text searches? Does that require you to rebuild the indexes or is it automatic?

If you lower it to 2 the index will get a lot larger, probably not necessary.


Edit: After one search it's very apparent, this is only going to take effect on new posts unless you manually tell it to rebuild the search indexes.

Also, please automatically include a star after each search word. Otherwise I have to remember to type in turbo* oxygen* in my searches if I wanted to find posts with turbos and some word form of oxygen. It looks like it's already splitting up the search by words so it shouldn't be too hard to add them: ... AGAINST ('+$word1* +$word2* ...' IN BOOLEAN MODE) ...

[scheides]

Originally Posted by slowboy

Isn't that a change in the MySQL database settings for full-text searches? Does that require you to rebuild the indexes or is it automatic?

If you lower it to 2 the index will get a lot larger, probably not necessary.


Edit: After one search it's very apparent, this is only going to take effect on new posts unless you manually tell it to rebuild the search indexes.

Also, please automatically include a star after each search word. Otherwise I have to remember to type in turbo* oxygen* in my searches if I wanted to find posts with turbos and some word form of oxygen. It looks like it's already splitting up the search by words so it shouldn't be too hard to add them: ... AGAINST ('+$word1* +$word2* ...' IN BOOLEAN MODE) ...

Hit me up with a link or two on this info, mostly because I can't be bothered to search myself.

[asshanson]

Edit: guess I misunderstood.

To rebuild an index: REPAIR TABLE tbl_name QUICK;
You'll have to do this for every table with a full-text index that you're searching.

As for adding a * to searches, you'll have to look at vBulletin code to see wherever it's doing its searches. Look for "in boolean mode" or something like that. See http://dev.mysql.com/doc/refman/5.0/...t-boolean.html for the SQL syntax for MySQL.