Latest Announcemnent
New thread
Status
Not open for further replies.
SᴩiDᴇЯ

SᴩiDᴇЯ

Banned
Banned
425
2009
3
0
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

PHP: 
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
 
10 comments
SᴩiDᴇЯ said:
But i dont know all the mods related to Akismet?
Click to expand...
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.
 
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.
 
Status
Not open for further replies.
Back
Top