How do I tell VB to reindex or repair searching?

  • Time
  • Show
Clear All
new posts
  • Zackw
    Senior Member
    • Aug 2010
    • 150
    • 4.0.x

    [Forum] How do I tell VB to reindex or repair searching?

    Hi guys, we upgraded from 3x to 4x and then moved the database to a fresh install of VB on another server.

    I know the search indexing system changed from 3x to 4x but what's happening is that VB is not able to search for anything from before the move. It's not indexing "backwards", as it were. It's only finding threads and posts that have been created since the move.

    If I'm not mistaken, VB uses the MySQL index right? So is there some query I can run in MySQL or VB maintenance script that will cause the index to be created for the entire database and not just the newly created threads/posts?

    Should I look in to a different search subsystem like Sphinx or something?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    You need to rebuild the search index:

    Admin CP -> Maintenance -> Update Counters -> Rebuild Search Index
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • Zackw
      Senior Member
      • Aug 2010
      • 150
      • 4.0.x

      Isn't the search index part of MySQL or does VB actually have to process that?

      We have about 400 users online regularly I'm wondering how much of a performance hit we'll have to run that. And how long it would take. Does VB do it or does MySQL do it in the background without VB's help?


      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24200
        • 5.7.X

        How many posts/threads do you have?
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)


        • Zackw
          Senior Member
          • Aug 2010
          • 150
          • 4.0.x

          68,000 Threads, 950,000 posts. 300-400 users on any given time, most users online over 2,400.

          What kind of hit can I expect?


          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.