Getting this Error

Discussion in 'Databases' started by SᴩiDᴇЯ, Oct 25, 2010.

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

    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
    PHP:

     
    Last edited: Oct 25, 2010
    SᴩiDᴇЯ, Oct 25, 2010 IP
  2. Bigcats82

    Bigcats82 Greenhorn

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #2
    It looks as though your admin panel is trying to update a column named "akvbghsfs_akismet_permissions" which doesn't exist on the usergroup table.
     
    Bigcats82, Oct 26, 2010 IP
  3. SᴩiDᴇЯ

    SᴩiDᴇЯ Well-Known Member

    Messages:
    540
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Thank you Bigcats82 you were right we created the column and now all is fixed, thank you for your input.
     
    SᴩiDᴇЯ, Oct 28, 2010 IP