Database Error has me stumped.

[MyArcade]

I get this error when trying to modify usergroup manager permissions anyone have any tips or ideas on how to make this go away?

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`awardpermissions` = '1',
`fcpermissions` = '0',
`vbimghost` = '1',
`vbimghost_upslots` = '3',
`vbimghost_files` = '200',
`vbppermissions` = '21377',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '472389319',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '200000',
`signaturepermissions` = '235519',
`sigpicmaxwidth` = '300',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '200000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`rpgpermissions` = '1',
`arcadepermissions` = '15',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054
Date : Sunday, March 18th 2007 @ 05:10:25 PM
Script : http://www.myarcadeplanet.com/home/a....php?do=update
Referrer : http://www.myarcadeplanet.com/home/a...&usergroupid=2
IP Address : 67.35.83.236
Username : XFactorX
Classname : vb_database

[Chicago_VLNU_4s]

do you have the hide hack? I have to diasable the hide hack whenever I edit a usergroup. Not saying that it's the hide hack, but I bet it's one of your hacks that's causing this trial and error. Try disabling hack after hack until you've found the one effecting it.. then disable that hack everytime you want to edit a usergroup

[Marco van Herwaarden]

You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.

[MyArcade]

I did have some stranded XML files deleted but that did not seem to work, I am now proceeding to disable a hack one by one see if that works.

Problem Fixed. Flashchat Integration hack is doing this hence "Fcpermissions".

[dirtycrow]

Originally Posted by Marco van Herwaarden

You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.

i have a simliar issue. is there ahy way of telling by the error what the mod was?

[blueberry]

MYarcade thanks alot.. you saved me... i had this error for 3 days now and i was trying to solve it with no success... i disabled flash chat and it worked fine