Announcement

Collapse
No announcement yet.

Forum.Stats table was deleted: how do I recover?

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

  • Forum.Stats table was deleted: how do I recover?

    Just like the topic says. How do I go about recovering the lost table without re-installing the vbulletin software? There is no back-up, so what's an efficient way to enter a new table.

  • #2
    Assuming you are not using a table prefix, here is the query to recreate the stats table in 3.0.7:

    CREATE stats (
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    nuser mediumint UNSIGNED NOT NULL DEFAULT '0',
    nthread mediumint UNSIGNED NOT NULL DEFAULT '0',
    npost mediumint UNSIGNED NOT NULL DEFAULT '0',
    ausers mediumint UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (dateline)
    );


    You'll need to update at least the forum and thread counters after recreating this table.
    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.


    Comment


    • #3
      Update the thread and forum counters? How is this accomplished? And what exactly will be affected if I do this?

      Comment


      • #4
        Admin CP -> Import & Maintenance -> Update Counters ->

        Rebuild Thread Information
        and
        Rebuild Forum Information

        And the purpose of doing this is to rebuild the stat info that was deleted when you deleted this taable.
        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.


        Comment

        Loading...
        Working...
        X