PDA

View Full Version : error updating usergroup


PureDesi
07-14-2007, 05:19 AM
hi

i am getting a following error , when i am making some changes in moderators usergroup



Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`forumpermissions` = '655359',
`genericpermissions` = '267329231',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '5',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=7;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Friday, July 13th 2007 @ 11:16:53 PM
Script : http://www.maxdesi.com/admincp/usergroup.php?do=update
Referrer : http://www.maxdesi.com/admincp/usergroup.php?do=edit&usergroupid=7
IP Address : 125.62.98.23
Username : Lust
Classname : vb_database

plz resolve

Dismounted
07-14-2007, 05:21 AM
It seems that you have recently uninstalled a hack. You must remove all the files associated with it. The problem file should be a bitfield*.xml file located in 'includes/xml'.

PureDesi
07-14-2007, 05:30 AM
yeah i have uninstalled a hack , coz it was not working properly then i reinstalled and working fine now, and the updating problem is coming since then ..

can i get in detail how to resolve that ..

regards
puredesi

for the reference i have installed these hacks , last week

force users to read a thread version 1.0
inferno vbshout 1.0.1 lite

Dismounted
07-14-2007, 06:12 AM
You still have a stray bitfield_*.xml file.