Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
  #16  
Old 02 Jul 2004, 21:02
ShiningArcanine ShiningArcanine is offline
 
Join Date: May 2003
Originally Posted by Zachery
You do need to update the datastore too Mr Shining Arcanine, silly pokemon
Doesn't that update itself?
Reply With Quote
  #17  
Old 02 Jul 2004, 21:06
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Originally Posted by ShiningArcanine
Doesn't that update itself?
Nope, someone must actualy force it to update, or run a query to update it.

The datastore will only be updated if you save that part of it

So after running that query you would need to go into the ACP and save your settings.
__________________
Looking for ImpEx?
Reply With Quote
  #18  
Old 02 Jul 2004, 21:43
ShiningArcanine ShiningArcanine is offline
 
Join Date: May 2003
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.
Reply With Quote
  #19  
Old 02 Jul 2004, 21:51
Tailfeathers's Avatar
Tailfeathers Tailfeathers is offline
 
Join Date: Sep 2002
Real name: Daniel
I just did the fulltext upgrade and then went to Update Counters and cleared the search index as it's no longer needed. Is that all I have to do or do I have to do something else to get rid of the old search index?
Reply With Quote
  #20  
Old 02 Jul 2004, 22:14
Freddie Bingham's Avatar
Freddie Bingham Freddie Bingham is offline
 
Join Date: Oct 2001
Originally Posted by Dan1113
I just did the fulltext upgrade and then went to Update Counters and cleared the search index as it's no longer needed. Is that all I have to do or do I have to do something else to get rid of the old search index?
There is also the word table.
Reply With Quote
  #21  
Old 02 Jul 2004, 22:18
Tailfeathers's Avatar
Tailfeathers Tailfeathers is offline
 
Join Date: Sep 2002
Real name: Daniel
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!
Reply With Quote
  #22  
Old 02 Jul 2004, 22:29
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
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
__________________
Looking for ImpEx?
Reply With Quote
  #23  
Old 02 Jul 2004, 22:55
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Real name: sabe
just for clarity, if i make the mod, will i still have to build my index's or will it be done automaticall?
__________________
UNDER CONSTRUCTION: Confessionary Hack

Make me a Hack of The Month author: GRPS: Groups Commune
make my hacks, they'll make you famous

unless it's a security concern, please do not pm/im me for support unless you're willing to pay.
Reply With Quote
  #24  
Old 02 Jul 2004, 23:09
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
When you execute the queries to add the indexes to thread and post table mySQL will built them automatically.
Reply With Quote
  #25  
Old 03 Jul 2004, 07:01
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by ShiningArcanine
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.
Do we run these in addition to turning this on? And how do we update the datastore?
Reply With Quote
  #26  
Old 03 Jul 2004, 08:06
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
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.
__________________
Looking for ImpEx?
Reply With Quote
  #27  
Old 03 Jul 2004, 12:01
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Real name: Ha Mai
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.
__________________
Selected Hacks:
[APM] Advanced Product Management [for vb4][for vb3.6] [for 3.7.x/3.8.x] -- [YAAS] Yet Another Awards System [for vB 3.5] [for vB 3.0] -- [YAPMS] Yet Another Private Message System 1.0.1

Last edited by mtha; 03 Jul 2004 at 12:21.
Reply With Quote
  #28  
Old 03 Jul 2004, 12:22
gorman gorman is offline
 
Join Date: Sep 2002
Activated it. So far not a single problem. Let's cross fingers. Should it improve performance, apart from saving some space?
Reply With Quote
  #29  
Old 03 Jul 2004, 19:15
adhari_com's Avatar
adhari_com adhari_com is offline
 
Join Date: May 2004
Real name: Hassan AlDoy
So shall we drop the 'word' table? as it's no longer needed?
Reply With Quote
  #30  
Old 03 Jul 2004, 20:48
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
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
__________________
My Site: EXTREME Overclocking

Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it.
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 15:58.

Layout Options | Width: Wide Color: