Thread: DB error
View Single Post
  #1  
Old 11 Dec 2011, 19:47
gazza2008 gazza2008 is offline
 
Join Date: Aug 2009
DB error

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
Reply With Quote