Error when updating usergroup

[theoperative]

I was trying to change the avatar size and I keep getting this error:

MySQL Error  : Unknown column 'postsforurls' in 'field list'
Error Number : 1054
Date         : Monday, January 1st 2007 @ 02:38:13 AM
Script       : http://www.republicanoperative.com/forums/admincp/usergroup.php?do=update
Referrer     : http://www.republicanoperative.com/forums/admincp/usergroup.php?do=edit&usergroupid=2

[Paul M]

You have only posted half the error, but that is not a standard column in any vb database table, so you have a modification installed that is causing that. Disable your plugins as a starting point.

[theoperative]

Here's the whole error

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Registered Users',
    `description` = '',
    `usertitle` = '',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `forumpermissions` = '782847',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '3',
    `pmsendmax` = '5',
    `calendarpermissions` = '51',
    `wolpermissions` = '1',
    `adminpermissions` = '0',
    `genericpermissions` = '271062727',
    `genericoptions` = '62',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '172031',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '20000',
    `sigmaxrawchars` = '1000',
    `sigmaxchars` = '500',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '8',
    `postsforurls` = ''
WHERE usergroupid=2;

MySQL Error  : Unknown column 'postsforurls' in 'field list'
Error Number : 1054
Date         : Monday, January 1st 2007 @ 07:21:30 AM
Script       : http://www.republicanoperative.com/forums/admincp/usergroup.php?do=update
Referrer     : http://www.republicanoperative.com/forums/admincp/usergroup.php?do=edit&usergroupid=2

[Marco van Herwaarden]

You have probably uninstalled a modifcation, but left the ./includes/xml/bitfield_XXXX.xml file. Remove that file.

[theoperative]

You have probably uninstalled a modifcation, but left the ./includes/xml/bitfield_XXXX.xml file. Remove that file.

That was exactly it thank you very much.

[KevinLe911]

You have probably uninstalled a modifcation, but left the ./includes/xml/bitfield_XXXX.xml file. Remove that file.

I have same problem like that but I still get the error after I delete that .xml file in ./includes/xml/ folder.

Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
 `title` = 'Administrators',
 `description` = '',
 `usertitle` = 'Administrator',
 `opentag` = '<img border=\"0\" src=\"cqadmin.gif\"><b><font color=\"#0070DF\">',
 `closetag` = '</font></b>',
 `passwordexpires` = '0',
 `passwordhistory` = '0',
 `arcadepermissions` = '255',
 `minpoststoplay` = '',
 `minreptoplay` = '',
 `minreglengthtoplay` = '',
 `hhroptions` = '0',
 `forumpermissions` = '1048575',
 `attachlimit` = '0',
 `pmquota` = '200',
 `pmpermissions` = '7',
 `pmsendmax` = '5',
 `calendarpermissions` = '63',
 `wolpermissions` = '31',
 `adminpermissions` = '3',
 `genericpermissions` = '1038901183',
 `genericoptions` = '55',
 `profilepicmaxwidth` = '75',
 `profilepicmaxheight` = '75',
 `profilepicmaxsize` = '300000',
 `avatarmaxwidth` = '150',
 `avatarmaxheight` = '150',
 `avatarmaxsize` = '300000',
 `signaturepermissions` = '237567',
 `sigpicmaxwidth` = '500',
 `sigpicmaxheight` = '100',
 `sigpicmaxsize` = '20000',
 `sigmaxrawchars` = '0',
 `sigmaxchars` = '0',
 `sigmaxlines` = '0',
 `sigmaxsizebbcode` = '7',
 `sigmaximages` = '0'
WHERE usergroupid=6;
MySQL Error  : Unknown column 'minpoststoplay' in 'field list'
Error Number : 1054
Date         : Monday, January 1st 2007 @ 07:25:57 PM
Script       : http://www..xxx.net/forum/admincp/usergroup.php?do=update
Referrer     : http://www.xxx.net/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address   : xx.xx.xx.xx
Username     : webmaster
Classname    : vb_database 

[Marco van Herwaarden]

That sounds like an error from an Arcade modification, please contact the author for a fix.

[Hemanth]

Hi i'm having the same problem. The issue is the bitfields from the hack Allow URLs in posts only after a minimum number of posts.

Remove "bitfield_restricturls.xml" from "includes/xml".