Site Problems??

[asshanson]

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]

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/en/fulltext-boolean.html for the SQL syntax for MySQL.

[FattyBoomBatty]

He wasn't mad at you, he just wants you to send a link because he's lazy. You were helpful, I understood, and I sock at computer language.

And here's a good reason not to include two letter words: FU !

[asshanson]

I guess first I should have asked, are you using the default vBulletin search or the MySQL built-in full text searches? If you're using vBulletin search engine I have no idea how to make the changes.

[scheides]

Anyone else seeing the weird stripe across the top in Firefox? Inbetween the nav menu and the forum - subforum listings

[AJ]

I see a big open area, and I didn't touch anything, I swear.

[JET]

It started doing it yesterday, the ads are messed up. Also I have to hit back twice to go back instead of once, this is IE7.

[scheides]

There was a google ads reference in there for some reason, like the template reverted to an old or something. Might have been something non-working when the ads were setup, and now it started working, or vice-versa. Oh well, all better now!

[asshanson]

The main forums page is about 3 screens wide in Safari. Just started doing it today. It loads normal at first, then it seems like it loads something at the bottom and it goes super wide. Could be the shoutbox?