Announcement

Collapse
No announcement yet.

Search type - how to change it manually?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grendel
    replied
    Great! Thank you very much.

    Leave a comment:


  • Freddie Bingham
    replied
    If you've manually executed the queries to add the fulltext indexes, edit includes/config.php to include this line:

    $config['Misc']['debug'] = true;

    Then go into vBulletin->Options and you will see a new section called 'Version Info and Other Untouchables'. Change the 'Fulltext Search' setting to Yes. Now edit includes/config.php again and remove $config['Misc']['debug'] = true;

    Leave a comment:


  • Grendel
    replied
    No help?
    I really would like to use the mysql-search but vBulletin won't let me...

    Leave a comment:


  • Grendel
    replied
    Hm, could you explain this for dumb ones like me?
    Is it like this: UPDATE `setting` SET `value` = '1' WHERE `varname` = 'fulltextsearch' LIMIT 1 ;
    Last edited by Grendel; Wed 14 Dec '05, 1:30am.

    Leave a comment:


  • Zachery
    replied
    Yes, the settings table is only one place that vairble is refrenced.

    You need to rebuild its cache.

    Leave a comment:


  • RyanD789
    replied
    Oh, do you mean edit any option so VB will reload the setting table? It seems to be working now. I changed it back to value=1.

    Ryan

    Leave a comment:


  • RyanD789
    replied
    Hmm... I manually changed this setting to value = 1 and it didn't seem to work. I then changed it to -1 and it worked, but that doesn't seem right. What am I missing?

    Edit any options? Not sure what you mean.

    Ryan

    Leave a comment:


  • Freddie Bingham
    replied
    That's all, just make sure to edit any option and save it to get your change activated.

    Leave a comment:


  • RyanD789
    replied
    I think I found it. Change the value to 1 where the varname = fulltextsearch in the setting table. (After manually running the Alter queries to add fulltext to the tables.)

    Anyplace else that needs to be changed?

    Ryan

    Leave a comment:


  • RyanD789
    replied
    Yes, how do we manually change the Search Type flag? Not how do we run the Alter queries, but change the Search Type to Fulltext without going through VB control panel?

    Thanks!
    Ryan DeLuca
    Bodybuilding.com

    Leave a comment:


  • Spinball
    replied
    MySQL 4.1.15-Max and the queries didn't complete so we did it manually as per the instructions on the page.
    I wasn't surprised that it timed out. The database repair function always times out on the post table.
    I had to get my host to run the SQL statements directly using telepathy.
    Last edited by Spinball; Tue 13 Dec '05, 10:44am.

    Leave a comment:


  • Kevlar
    replied
    I'm curious about this too ... especially since we have over 5.2 million posts, I know the control panel option will probably die a horrible death.

    Leave a comment:


  • Steve Machol
    replied
    Which version of MySQL are you running? Did you check the database to make sure those queries completed?

    Leave a comment:


  • Spinball
    started a topic Search type - how to change it manually?

    Search type - how to change it manually?

    Hi folks,
    because we have 1.8 million posts, the control panel search type change timed out.
    I have manually run the two SQL statements ok (or rather my host did with ssh), but the control panel setting still reports that we're using the old vBulletin search. How do I change this? Does it matter?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X