Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
Howto : Enable FullText Searching in vBulletin 3.0.2/3
Zachery
Join Date: Jul 2002
Posts: 11,440

Ontario, Canada
by Zachery Zachery is offline 02 Jul 2004

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

Last edited by Zachery; 05 Jul 2004 at 22:36..
Views: 22045
Reply With Quote
Comments
  #2  
Old 02 Jul 2004, 18:34
Daniel P Daniel P is offline
 
Join Date: Feb 2002
Real name: Dan
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.
Reply With Quote
  #3  
Old 02 Jul 2004, 18:38
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
This is really GREAT news!

Any idea how stable/reliable the code is already and when this will become "officially" available?
Reply With Quote
  #4  
Old 02 Jul 2004, 18:40
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
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.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 02 Jul 2004, 18:46
muse.mu muse.mu is offline
 
Join Date: Jan 2004
thank you very much Zach!!
Reply With Quote
  #6  
Old 02 Jul 2004, 18:52
ShiningArcanine ShiningArcanine is offline
 
Join Date: May 2003
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.
Reply With Quote
  #7  
Old 02 Jul 2004, 19:00
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: 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.
Reply With Quote
  #8  
Old 02 Jul 2004, 19:09
ShiningArcanine ShiningArcanine is offline
 
Join Date: May 2003
I did a little experimenting with queries and came up with the following.

Running this should turn fulltext on:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Running this should turn fulltext off:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.

Last edited by ShiningArcanine; 02 Jul 2004 at 21:49.
Reply With Quote
  #9  
Old 02 Jul 2004, 19:22
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Moved to modifications hints and tips - cheers zach
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #10  
Old 02 Jul 2004, 19:22
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
I somewhat doubt that these queries are correct - they only index titles, but not the post itself (pagetext)
Reply With Quote
  #11  
Old 02 Jul 2004, 19:24
ShiningArcanine ShiningArcanine is offline
 
Join Date: May 2003
Originally Posted by KirbyDE
I somewhat doubt that these queries are correct - they only index titles, but not the post itself (pagetext)
Oops. ^_^;; I'll fix that in a moment.

Edit: Fixed.

Last edited by ShiningArcanine; 02 Jul 2004 at 19:30.
Reply With Quote
  #12  
Old 02 Jul 2004, 20:17
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Originally Posted by ShiningArcanine
Oops. ^_^;; I'll fix that in a moment.

Edit: Fixed.
You do need to update the datastore too Mr Shining Arcanine, silly pokemon
__________________
Looking for ImpEx?
Reply With Quote
  #13  
Old 02 Jul 2004, 20:39
Tailfeathers's Avatar
Tailfeathers Tailfeathers is offline
 
Join Date: Sep 2002
Real name: Daniel
Sorry to be stupid but where do you enter debug mode?
Reply With Quote
  #14  
Old 02 Jul 2004, 20:48
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
http://www.vbulletin.com/forum/showt...182#post594182
number 7
__________________
Looking for ImpEx?
Reply With Quote
  #15  
Old 02 Jul 2004, 20:51
Tailfeathers's Avatar
Tailfeathers Tailfeathers is offline
 
Join Date: Sep 2002
Real name: Daniel
Thank you, Zachery
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 09:21.

Layout Options | Width: Wide Color: