Database errors due to a mod
 

Hi guys... I'm trying to edit the usergroup settings in the Admin CP for my forum. But I seem to have a problem.

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '708863',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '1',
`pmsendmax` = '10',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '268441091',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '95',
`avatarmaxheight` = '95',
`avatarmaxsize` = '200000',
`signaturepermissions` = '176127',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '334',
`sigmaxchars` = '167',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '15',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Saturday, June 23rd 2007 @ 04:45:04 PM
Script : http://www.domain.co.uk/communities/....php?do=update
Referrer : http://www.domain.co.uk/communities/...&usergroupid=2
IP Address : IP
Username : Jono
Classname : my_forum

It's also causing empty fields at the end of the profile, which no doubt is causing the errors.

The plug in is removed... so not sure how to get around this!

delete the files from the server should get rid of it. then re-install and see if ti works, if not just get rid of it again and give up on it.

Youmust remove the files associated with the modification. In this case, it is a bitfield file located in includes/xml.