No announcement yet.

Accidentally deleted db 'usergroups'

  • Filter
  • Time
  • Show
Clear All
new posts

  • Accidentally deleted db 'usergroups'

    I was trying to create a table, baby in arms screwed the works and now I have no usergroup table. It no longer exists. I need to recreate or restore the table. For all possible info I am running vb3.5.3 and here is the error I am getting:

    Database error in vBulletin 3.5.3:
    Invalid SQL:
    SELECT * FROM usergroup ORDER BY title;
    MySQL Error : Table 'xxxxxxxxxx.usergroup' doesn't exist
    Error Number : 1146
    Date : Monday, February 20th 2006 @ 08:15:02 PM
    Script : http://XXXXXXXXXXXXXXX/forums/adminc....php?do=modify
    Referrer : http://XXXXXXXXXXXXX/forums/admincp/index.php?do=nav
    IP Address : xxxxxxxxx
    Username : xxxxxxxxx
    Classname : vb_database
    any help would be much appreciated!! I basically need to syntax to recreate the table as I am idiot when it comes to phpmyadmin. Thanks to anyone who can help.

    Last edited by LadyJo; Mon 20 Feb '06, 5:15pm.

  • #2
    did you deleted the usergroup table from a live forum ? or was this one of the test/new forums ?
    if this was a live forum, with posts/users in same, then i am afraid you have lost your entire user + posts + etc. settings..

    probably you should request for a backup from your host.
    TechArena - TechArena Community - News - Download - Video - Guide - Review


    • #3
      it was from the live forum, but they have not beein affected, it is only admin cp side that I am getting these errors. People have still maintained their usergroups, post count, the whole shebang forums side.


      • #4
        It must be an epidemic. You are the second person in the last couple of days that deleted their 3.5.3 usergroup table.

        See posts #4 and #11 in this thread:
        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.


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