DB error

[gazza2008]

I am getting a DB error whsn I try and update a usergroup permissions

here is the DB error

Database error in vBulletin 4.1.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Junior Admin',
`description` = '',
`usertitle` = '<span style=\"color: dark red ;\">Distinguished members</span>',
`opentag` = '<span style=\"color: dark red; text-shadow: Purple 1px 1px 10px;\"><strong>',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '1',
`canoverride` = '1',
`dbtech_statuspermissions` = '54',
`dbtech_vbshoutpermissions` = '2',
`akvbghsfs_akismet_permissions` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147221467',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '31',
`wolpermissions` = '31',
`adminpermissions` = '2',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '30000',
`signaturepermissions` = '245755',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '1',
`albumpermissions` = '255',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '15',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '0',
`groupiconmaxsize` = '0',
`usmlsaperms` = '15',
`staffappminpostreq` = '10',
`staffappminrepreq` = '0',
`staffappminregreq` = '0',
`arcadepermissions` = '255',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`arcadetourperms` = '15'
WHERE usergroupid=11;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, December 11th 2011 @ 06:50:49 PM
Error Date : Sunday, December 11th 2011 @ 06:50:49 PM
Script : http://www.cardsharing-chat.info/adm....php?do=update
Referrer : http://www.cardsharing-chat.info/adm...usergroupid=11



Anyone got any ideas

Cheers

gaz

[Lynne]

That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.

[gazza2008]

Originally Posted by Lynne

That is from a modification you installed. Either reinstall it correctly, or uninstall it correctly, in order to get rid of the error.

I dont know which mod it is

When I try and disable all mods in config.php I still get same error

[HMBeaty]

Originally Posted by gazza2008

I dont know which mod it is

When I try and disable all mods in config.php I still get same error

It's the GlowHost Spam-O-Matic mod

--------------- Added [DATE]1323641851[/DATE] at [TIME]1323641851[/TIME] ---------------

More than likely, you installed it before, then uninstalled it, but left the files in place. More specifically, the file in the includes/xml/ directory

[Lynne]

Uninstalling a modification means going through the complete install instructions backwards, not just uninstalling the product.

[Fready]

Do what the above said,
The error is here, easy to see;

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

Which shows it's to do with this file

akvbghsfs_akismet_permissions'

which is a modification, search for the file in your cPanel and delete it.,

[gazza2008]

cheers

found it and done it