Howto : Enable FullText Searching in vBulletin 3.0.2/3

[Tailfeathers]

I checked my db in phpmyadmin and it seems like my word table is already blank (it's only 1kb and it has nothing to browse). Thanks!

[Zachery]

Originally Posted by ShiningArcanine

After spending an hour looking over vBulletin's source code (for the first time). I found out exactly why you didn't just post a list of queries... the datastore contains a serialized version of $vboptions. :disappointed: As they say, live and learn.

I know how to update the datastore, its just simpiler this way

[sabret00the]

just for clarity, if i make the mod, will i still have to build my index's or will it be done automaticall?

[Andreas]

When you execute the queries to add the indexes to thread and post table mySQL will built them automatically.

[Boofo]

Originally Posted by 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.

Do we run these in addition to turning this on? And how do we update the datastore?

[Zachery]

Originally Posted by Boofo

Do we run these in addition to turning this on? And how do we update the datastore?

Bob, its best to it as my instructions in the first post instead of quersy.

[mtha]

Originally Posted by Zachery

I know how to update the datastore, its just simpiler this way

a query to empty that value in datastore, the value should be rebuilt itself , However, it's still safer to use ACP


I can see that this piece of beautiful work is working but not perfectly
you still have to improve it.

I did few quick test with UTF-8, and it was able to search fine, but the Highlight didnt do the job properly. It didnt highlight some special characters.

[gorman]

Activated it. So far not a single problem. Let's cross fingers. Should it improve performance, apart from saving some space?

[adhari_com]

So shall we drop the 'word' table? as it's no longer needed?

[eoc_Jason]

This would be nice if someone would link to it from the vb.com discussion thread, a lot of people have asked and they said to look here... yet it took me quite a few search trys to find this thread (how ironic)... lol