Howto : Enable FullText Searching in vBulletin 3.0.2/3

[Daniel P]

Originally Posted by Zachery

You'll need to shut your boards down for security reasons and enter debug mode, or enable debug mode for yourself only.

Once done, go into the vBulletin AdminCP > and select vBulletin Options.

You will see an area called Version Info and Other Untouchables
At the bottom you will see

Fulltext Search

Run the two querys it says to, adjust for table prefixes.

Then click on yes and hit save.

This feature is not offcialy supported at this time, so enabling this is like hacking your forums

Thanks for pointing this out, Zach Much appreciated.

[Andreas]

This is really GREAT news!

Any idea how stable/reliable the code is already and when this will become "officially" available?

[Zachery]

No clue about stability, you NEED to be on mysql 4.0.2+ at least, and even if i did, and i really dont, i couldn't say.

[muse.mu]

thank you very much Zach!!

[ShiningArcanine]

Originally Posted by KirbyDE

This is really GREAT news!

Any idea how stable/reliable the code is already and when this will become "officially" available?

I'm running it on my forums and I haven't found any problems yet.

[Andreas]

We are using mySQL 4.0.20, so this shouldn't be a problem as fulltext search also works in a custom addon

I think i'll make a dump of the production database and just play around a bit with this.

[ShiningArcanine]

I did a little experimenting with queries and came up with the following.

Running this should turn fulltext on:

ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext);
ALTER TABLE thread ADD FULLTEXT INDEX (title);
UPDATE `setting` SET `value` = '1' WHERE `varname` = 'fulltextsearch' LIMIT 1 ;

Running this should turn fulltext off:

UPDATE `setting` SET `value` = '0' WHERE `varname` = 'fulltextsearch' LIMIT 1 ;
ALTER TABLE `post` DROP INDEX `title` ;
ALTER TABLE `thread` DROP INDEX `title`;

Edit: By the way, I recommend running these queries one at a time or in PHPMyAdmin.

Another Edit: I just fixed a careless mistake that didn't index pagetext. ^_^;;

3rd Edit: By the way, if you run those queries, you will want to go to vBulletin Options in the control panel and click "save." Otherwise the cached copy of $vboptions will contain the old settings.

[Dean C]

Moved to modifications hints and tips - cheers zach

[Andreas]

I somewhat doubt that these queries are correct - they only index titles, but not the post itself (pagetext)