I was working in the db and accicently dropped the usergroup table. How can I recreate it?
Droped table
Collapse
X
-
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.
-
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
-
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
-
Change this line:
CREATE TABLE usergroup
To this:
CREATE TABLE vb350_usergroup
And this:
INSERT INTO usergroup
To this:
INSERT INTO vb350_usergroupSteve 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
-
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.
Comment