MAJOR problem please check this and help if possible

[Injektilo]

when trying to change settings for any of my usergroups i get this error msg


Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Banned',
`description` = '',
`usertitle` = 'Banned',
`opentag` = '<strike><font color=\"#000000\">',
`closetag` = '</font></strike>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`buddiequota` = '0',
`buddiepermissions` = '0',
`awardpermissions` = '1',
`forumpermissions` = '0',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '1024',
`genericoptions` = '40',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`vbspacecomments` = '0',
`custompermissions` = '0',
`maxsiglines` = '',
`maxsigfontsize` = '',
`maxsigimgsize` = '',
`maxsigimgwidth` = '',
`maxsigimgheight` = '',
`maxsigimages` = '',
`sigforbiddencodes` = ''
WHERE usergroupid=18;

MySQL Error : Unknown column 'custompermissions' in 'field list'
Error Number : 1054
Date : Tuesday, February 14th 2006 @ 06:48:02 AM
Script : http://www.xxx.com/forum/xxx/usergroup.php
Referrer : http://www.xxx.com/forum/xxx/usergroup.php?do=edit&usergroupid=18
IP Address : xxxxxxxx
Username : xxxxxxxx
Classname : vb_database


what do i need to do to fix this?

[Rich]

You need to add the column 'custompermissions' in field list. You can add the column via phpmyadmin.

[Injektilo]

You need to add the column 'custompermissions' in field list. You can add the column via phpmyadmin.


what would be the command?

[Marco van Herwaarden]

This is probably caused by a hack you hae uninstalled, but have left the includes/xml/bitfield_<hackname>.xml file. Remove the file of the uninstalled ahck, and the problem will be gone.

[Injektilo]

This is probably caused by a hack you hae uninstalled, but have left the includes/xml/bitfield_<hackname>.xml file. Remove the file of the uninstalled ahck, and the problem will be gone.


not sure which one is that :) any other solutions maybe?

[Marco van Herwaarden]

Which bitfield_XXXX.xml you have in your includes/xml directory?

[Injektilo]

Which bitfield_XXXX.xml you have in your includes/xml directory?

these

[Marco van Herwaarden]

This is probably caused by one of the following hacks which you have probably uninstalled:
- Awards
- Buddies
- Comments
- Siglimits

Check if you have still installed the above hacks, if not remove the bitfield xml-file for that hack.