[Forum] having database error creating new usergroup. what can be done?

[jskoh]

Database error in vBulletin 4.1.12:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `sigmaxvideos`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `ms_imageshack_upload_permissions`)
VALUES
('registered user1', '', '', '', '', '', '', '0', '0', '651271', '2626563', '1000000', '0', '0', '5', '', '0', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '', '', '0', '', '', '', '', '0', '0', '0', '', '', '0');

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, November 17th 2012 @ 01:00:49 PM
Error Date : Saturday, November 17th 2012 @ 01:00:49 PM
Script : http://domain.com/forum/admincp/usergroup.php?do=update
Referrer : http://domain.com/forum/admincp/usergroup.php?do=add
IP Address : 27.104.189.236
Username : admin
Classname : vB_Database
MySQL Version : 5.5.23-55

[BirdOPrey5]

Database error in vBulletin 4.1.12:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `sigmaxvideos`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`, `ms_imageshack_upload_permissions`)
VALUES
('registered user1', '', '', '', '', '', '', '0', '0', '651271', '2626563', '1000000', '0', '0', '5', '', '0', '1', '0', '0', '41', '100', '100', '25000', '50', '50', '20000', '0', '', '', '', '', '', '', '7', '', '', '0', '', '', '', '', '0', '0', '0', '', '', '0');

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, November 17th 2012 @ 01:00:49 PM
Error Date : Saturday, November 17th 2012 @ 01:00:49 PM
Script : http://domain.com/forum/admincp/usergroup.php?do=update
Referrer : http://domain.com/forum/admincp/usergroup.php?do=add
IP Address : 27.104.189.236
Username : admin
Classname : vB_Database
MySQL Version : 5.5.23-55

You probably have left over xml files in your /includes/xml/ folder from a mod you have uninstalled. Something related to Image Shack I'd imagine.

You need to delete these stray XML files.

You can go to Admin CP -> Diagnostics -> Suspect File Check and get a list of all files that are not part of vBulletin in your /includes/xml/ folder. Hopefully you can tell from the file name the problem file because other mods installed may have files you still need.

[jskoh]

You probably have left over xml files in your /includes/xml/ folder from a mod you have uninstalled. Something related to Image Shack I'd imagine.

You need to delete these stray XML files.

You can go to Admin CP -> Diagnostics -> Suspect File Check and get a list of all files that are not part of vBulletin in your /includes/xml/ folder. Hopefully you can tell from the file name the problem file because other mods installed may have files you still need.

thank.... that solve my problem.. it works..