Dtatbase Error in ACP

[SᴩiDᴇЯ]

Getting this Error

When i am in my admin control panel, and i make changes to the usersgroup and then when i save them, i get this Error below, can anyone tell me why this is happening?

And how i can get this fixed please.

At http://spiderswc.com

Database error in vBulletin 3.8.6:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Juniors',
    `description` = '',
    `usertitle` = '<b><font color=\"#00b4ff\">Probationr</b></font>',
    `opentag` = '<span style=\"color:#00b4ff;\">',
    `closetag` = '</span>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '0',
    `forumpermissions` = '655363',
    `genericpermissions` = '0',
    `attachlimit` = '1000000',
    `pmquota` = '0',
    `pmpermissions` = '0',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '0',
    `wolpermissions` = '0',
    `adminpermissions` = '0',
    `genericpermissions2` = '0',
    `genericoptions` = '32',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '25000',
    `avatarmaxwidth` = '50',
    `avatarmaxheight` = '50',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '0',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '0',
    `albumpicmaxwidth` = '0',
    `albumpicmaxheight` = '0',
    `albumpicmaxsize` = '0',
    `albummaxpics` = '0',
    `albummaxsize` = '0',
    `usercsspermissions` = '0',
    `visitormessagepermissions` = '16',
    `socialgrouppermissions` = '0',
    `maximumsocialgroups` = '0',
    `groupiconmaxsize` = '0',
    `dbtech_vbshoutpermissions` = '0',
    `akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=12;

MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Monday, October 25th 2010 @ 11:48:15 AM
Error Date    : Monday, October 25th 2010 @ 11:48:15 AM
Script        : http://spiderswc.com/admincp/usergroup.php?do=update
Referrer      : http://spiderswc.com/admincp/usergroup.php?do=edit&usergroupid=12
IP Address    : 120.18.53.19
Username      : SᴩiDᴇЯ
Classname     : vB_Database
MySQL Version : 5.0.91-community-log

 

[desiboy]

if you have a mod related to Akismet, Disable it..try again.

 

[SuicidalMedia]

I believe it happened because of Aksimet anti spam plugin. Reinstall the plugin, or uninstall it. It should be working after reinstall/uninstall.

 

[SᴩiDᴇЯ]

I have disabled all spaming programs and it is still doing the same thing.

 

[SuicidalMedia]

I have disabled all spaming programs and it is still doing the same thing.

You've disabled everything related to Aksimet from Plugins/Products?

It can't be showing that same error if you reinstalled, or uninstalled/disabled the mod.

 

[SᴩiDᴇЯ]

But i dont know all the mods related to Akismet?

 

[FlickW]

pm me ur email id i can help u..

 

[SuicidalMedia]

But i dont know all the mods related to Akismet?

It should have something 'Aksimet' in their title I guess. It's anti spam plugin/product, that's for sure. Because it has something to do with user permissions, and you didn't installed it right, e.g. You didn't run the query which would create field "aksimet_permissions" (or whatever is called) in user table.

 

[desiboy]

[SLIDE]http://cdnpic.com/upload/2cbf74f1.png[/SLIDE]

[SLIDE] http://cdnpic.com/upload/beedb58f.png[/SLIDE]

 

[GoPantheoN]

The problem is while installing the mod you have uploaded some xml file that has included some field in the form, though you have uninstalled the product, you have to remove it manually. Just check the installation file and see what xml files you have uploaded, most probably in the includes/xml/bitfiles... something like that.

Edit : The problem wont solve if you just disable or uninstall the product, as the problem would have evolved only after you have either uninstalled or disabled it.

Also I think you have installed the Spam-O-Matic product.

 

[Rohit]

Try repairing the database from cPanel...It should work.