error in sql

Quee

New Member
hey alle

when i tru to give usergroup promission in acp i get this sql error.
i get it every time i try to change somthing in Usergroup Manager plz help

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'DPS Uploader',
`description` = 'xxxxxxx,
`usertitle` = 'xxxxxxx',
`opentag` = '<font color=\"#FF6347 \">',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '1700854',
`genericpermissions` = '203953795',
`attachlimit` = '1000000',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '5',
`pmthrottlequantity` = '',
`calendarpermissions` = '0',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '47',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '7',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albumpicmaxsize` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '0',
`socialgrouppermissions` = '0',
`maximumsocialgroups` = '',
`groupiconmaxsize` = ''
WHERE usergroupid=9;

MySQL Error : Unknown column 'pmthrottlequantity' in 'field list'
Error Number : 1054
Request Date : Saturday, March 7th 2009 @ 01:40:04 AM
Error Date : Saturday, March 7th 2009 @ 01:40:04 AM
Script : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
Referrer : vBTEAM Underground - Free vBulletin Hacks, Skins and Support
IP Address : xx.xxx.xxx.xxx
Username : Quee
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4-log
 

bluescorpion

New Member
What every the PM hack was that you removed, it still has a file on your system that is being loaded. By having the file in there, you are causing the problem. The reason why the query is looking for the field is because it detected the bitfield file. Its an xml file that you haven't removed. Check the hack to see what files it installed and remove them from your live site.
 
Top