Droped table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mholtum
    Senior Member
    • May 2004
    • 298
    • 3.5.x

    Droped table

    I was working in the db and accicently dropped the usergroup table. How can I recreate it?
    Home of the free, Because of the brave.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Which version of vB?
    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

    • mholtum
      Senior Member
      • May 2004
      • 298
      • 3.5.x

      #3
      duh sorry.. 3.5.3
      Home of the free, Because of the brave.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Run these two queries (hopefully they are formatted correctly):

        Code:
        CREATE TABLE usergroup (
                usergroupid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
                title CHAR(100) NOT NULL DEFAULT '',
                description VARCHAR(250) NOT NULL DEFAULT '',
                usertitle CHAR(100) NOT NULL DEFAULT '',
                passwordexpires SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                passwordhistory SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                pmquota SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                pmsendmax SMALLINT UNSIGNED NOT NULL DEFAULT '5',
                pmforwardmax SMALLINT UNSIGNED NOT NULL DEFAULT '5',
                opentag CHAR(100) NOT NULL DEFAULT '',
                closetag CHAR(100) NOT NULL DEFAULT '',
                canoverride SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                ispublicgroup SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                forumpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                pmpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                calendarpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                wolpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                adminpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                genericpermissions INT UNSIGNED NOT NULL DEFAULT '0',
                genericoptions INT UNSIGNED NOT NULL DEFAULT '0',
                attachlimit INT UNSIGNED NOT NULL DEFAULT '0',
                avatarmaxwidth SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                avatarmaxheight SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                avatarmaxsize INT UNSIGNED NOT NULL DEFAULT '0',
                profilepicmaxwidth SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                profilepicmaxheight SMALLINT UNSIGNED NOT NULL DEFAULT '0',
                profilepicmaxsize INT UNSIGNED NOT NULL DEFAULT '0',
                PRIMARY KEY (usergroupid)
        );
        
        INSERT INTO usergroup (usergroupid, title, description, usertitle, passwordexpires, passwordhistory, pmquota, pmsendmax, pmforwardmax, opentag, closetag, canoverride, ispublicgroup, forumpermissions, pmpermissions, calendarpermissions, wolpermissions, adminpermissions, genericpermissions, genericoptions, attachlimit, avatarmaxwidth, avatarmaxheight, avatarmaxsize, profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize) VALUES
        (1, '{$install_phrases['usergroup_guest_title']}', '', '{$install_phrases['usergroup_guest_usertitle']}', 0, 0, 50, 0, 0, '', '', 0, 0, {$groupinfo[1]['forumpermissions']}, {$groupinfo[1]['pmpermissions']}, {$groupinfo[1]['calendarpermissions']}, {$groupinfo[1]['wolpermissions']}, {$groupinfo[1]['adminpermissions']}, {$groupinfo[1]['genericpermissions']}, 8, 0, 80, 80, 20000, 100, 100, 65535),
        (2, '{$install_phrases['usergroup_registered_title']}', '', '', 0, 0, 50, 5, 5, '', '', 0, 0, {$groupinfo[2]['forumpermissions']}, {$groupinfo[2]['pmpermissions']}, {$groupinfo[2]['calendarpermissions']}, {$groupinfo[2]['wolpermissions']}, {$groupinfo[2]['adminpermissions']}, {$groupinfo[2]['genericpermissions']}, 30, 0, 80, 80, 20000, 100, 100, 65535),
        (3, '{$install_phrases['usergroup_activation_title']}', '', '', 0, 0, 50, 0, 0, '', '', 0, 0, {$groupinfo[3]['forumpermissions']}, {$groupinfo[3]['pmpermissions']}, {$groupinfo[3]['calendarpermissions']}, {$groupinfo[3]['wolpermissions']}, {$groupinfo[3]['adminpermissions']}, {$groupinfo[3]['genericpermissions']}, 24, 0, 80, 80, 20000, 100, 100, 65535),
        (4, '{$install_phrases['usergroup_coppa_title']}', '', '', 0, 0, 50, 0, 0, '', '', 0, 0, {$groupinfo[4]['forumpermissions']}, {$groupinfo[4]['pmpermissions']}, {$groupinfo[4]['calendarpermissions']}, {$groupinfo[4]['wolpermissions']}, {$groupinfo[4]['adminpermissions']}, {$groupinfo[4]['genericpermissions']}, 16, 0, 80, 80, 20000, 100, 100, 65535),
        (5, '{$install_phrases['usergroup_super_title']}', '', '{$install_phrases['usergroup_super_usertitle']}', 0, 0, 50, 0, 0, '', '', 0, 0, {$groupinfo[5]['forumpermissions']}, {$groupinfo[5]['pmpermissions']}, {$groupinfo[5]['calendarpermissions']}, {$groupinfo[5]['wolpermissions']}, {$groupinfo[5]['adminpermissions']}, {$groupinfo[5]['genericpermissions']}, 31, 0, 80, 80, 20000, 100, 100, 65535),
        (6, '{$install_phrases['usergroup_admin_title']}', '', '{$install_phrases['usergroup_admin_usertitle']}', 180, 360, 50, 5, 5, '', '', 0, 0, {$groupinfo[6]['forumpermissions']}, {$groupinfo[6]['pmpermissions']}, {$groupinfo[6]['calendarpermissions']}, {$groupinfo[6]['wolpermissions']}, {$groupinfo[6]['adminpermissions']}, {$groupinfo[6]['genericpermissions']}, 31, 0, 80, 80, 20000, 100, 100, 65535),
        (7, '{$install_phrases['usergroup_mod_title']}', '', '{$install_phrases['usergroup_mod_usertitle']}', 0, 0, 50, 5, 5, '', '', 0, 0, {$groupinfo[7]['forumpermissions']}, {$groupinfo[7]['pmpermissions']}, {$groupinfo[7]['calendarpermissions']}, {$groupinfo[7]['wolpermissions']}, {$groupinfo[7]['adminpermissions']}, {$groupinfo[7]['genericpermissions']}, 22, 0, 80, 80, 20000, 100, 100, 65535),
        (8, '{$install_phrases['usergroup_banned_title']}', '', '{$install_phrases['usergroup_banned_usertitle']}', 0, 0, 0, 0, 0, '', '', 0, 0, {$groupinfo[8]['forumpermissions']}, {$groupinfo[8]['pmpermissions']}, {$groupinfo[8]['calendarpermissions']}, {$groupinfo[8]['wolpermissions']}, {$groupinfo[8]['adminpermissions']}, {$groupinfo[8]['genericpermissions']}, 32, 0, 80, 80, 20000, 100, 100, 65535)
        ;
        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

        • mholtum
          Senior Member
          • May 2004
          • 298
          • 3.5.x

          #5
          It created usergroup and I use the table prefix vb350_
          Home of the free, Because of the brave.

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            Then modify those queries to use that table prefix.
            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

            • mholtum
              Senior Member
              • May 2004
              • 298
              • 3.5.x

              #7
              I would but I dont know how.
              Home of the free, Because of the brave.

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                Change this line:

                CREATE TABLE usergroup

                To this:

                CREATE TABLE vb350_usergroup

                And this:

                INSERT INTO usergroup

                To this:

                INSERT INTO vb350_usergroup
                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

                • mholtum
                  Senior Member
                  • May 2004
                  • 298
                  • 3.5.x

                  #9
                  Thank you
                  Home of the free, Because of the brave.

                  Comment

                  • mholtum
                    Senior Member
                    • May 2004
                    • 298
                    • 3.5.x

                    #10
                    Great that worked..

                    I can get back into my site and I see this when I go to usergroup manager:
                    Warning: Invalid argument supplied for foreach() in /admincp/usergroup.php on line 741
                    Home of the free, Because of the brave.

                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488

                      #11
                      Do this. Upload the tools.php script in the 'do_not_upload' folder of the vB zip file to your Admin CP directory. Then run the [Usergroup/Forum Cache] option. This should fix this problem.
                      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

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