Howto : Enable FullText Searching in vBulletin 3.0.2/3
This feature is not offcialy supported at this time, so enabling this is like hacking your forums :)
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 :) |
Quote:
|
This is really GREAT news!
Any idea how stable/reliable the code is already and when this will become "officially" available? |
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.
|
thank you very much Zach!!
|
Quote:
|
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. |
I did a little experimenting with queries and came up with the following.
Running this should turn fulltext on: Code:
ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext); Code:
UPDATE `setting` SET `value` = '0' WHERE `varname` = 'fulltextsearch' LIMIT 1 ; 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. |
Moved to modifications hints and tips - cheers zach :)
|
I somewhat doubt that these queries are correct - they only index titles, but not the post itself (pagetext) ;)
|
All times are GMT. The time now is 06:25 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|