Usergroup Change Database Error

[cheat-master30]

Okay, I am obviously running version 3.6.7 PL1 of vBulletin, and there is a major problem in that whenever usergroups are changed, a database error occurs which prevents anything working. It may possibly be because of a modification, but the modification that I think is responsible (Post Edit History) has supposedly been fully uninstalled and no products or plug ins related to it remain.

See attachment for screenshot.

This is the full error:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE VBusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '(COPPA) Users Awaiting Moderation',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`iprof_options` = '0',
`edithistorypermissions` = '0',
`forumpermissions` = '655375',
`genericpermissions` = '33554499',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericoptions` = '56',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=4;

MySQL Error : Unknown column 'edithistorypermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 1st 2007 @ 02:37:20 AM
Script : admincp/usergroup.php?do=update
Referrer : admincp/usergroup.php?do=edit&usergroupid=4
IP Address : **************
Username : **************
Classname : **************

Every other part of vBulletin works perfectly.

Does anyone have some kind of database query or action in PHPMyAdmin to remove what's causing the problem? Or a working uninstall script?

[Michael Biddle]

MySQL Error : Unknown column 'edithistorypermissions' in 'field list'

Run this query:

alter VBusergroup add edithistorypermissions int(11) not null;

[cheat-master30]

Thanks for the suggestion. Anyone else got any ways?

[Michael Biddle]

that didnt work?

[cheat-master30]

No, I have not tried it yet. Just very wary of database queries, and also need to know if there is a way to literally get rid of anything Post Edit History related, because I uninstalled and don't want/need anything to do with it any more.

[Dismounted]

You must remove all the files associated with it. In this case, it should be a bitfield_*.xml file in the /includes/xml/ directory.

[cheat-master30]

Thank you! That seems to have allowed me to save usergroups and the like!

Should I also remove this?

hooks_edihistory.xml

[Dismounted]

Yes.