PDA

View Full Version : Database Error has me stumped.


MyArcade
03-18-2007, 09:13 PM
I get this error when trying to modify usergroup manager permissions anyone have any tips or ideas on how to make this go away?

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`awardpermissions` = '1',
`fcpermissions` = '0',
`vbimghost` = '1',
`vbimghost_upslots` = '3',
`vbimghost_files` = '200',
`vbppermissions` = '21377',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '472389319',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '200000',
`signaturepermissions` = '235519',
`sigpicmaxwidth` = '300',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '200000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`rpgpermissions` = '1',
`arcadepermissions` = '15',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054
Date : Sunday, March 18th 2007 @ 05:10:25 PM
Script : http://www.myarcadeplanet.com/home/admincp/usergroup.php?do=update
Referrer : http://www.myarcadeplanet.com/home/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 67.35.83.236
Username : XFactorX
Classname : vb_database

Chicago_VLNU_4s
03-19-2007, 02:19 AM
do you have the hide hack? I have to diasable the hide hack whenever I edit a usergroup. Not saying that it's the hide hack, but I bet it's one of your hacks that's causing this trial and error. Try disabling hack after hack until you've found the one effecting it.. then disable that hack everytime you want to edit a usergroup

Marco van Herwaarden
03-19-2007, 12:28 PM
You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.

MyArcade
03-25-2007, 02:40 PM
I did have some stranded XML files deleted but that did not seem to work, I am now proceeding to disable a hack one by one see if that works.

Problem Fixed. Flashchat Integration hack is doing this hence "Fcpermissions".

dirtycrow
03-27-2007, 03:12 AM
You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.
i have a simliar issue. is there ahy way of telling by the error what the mod was?

blueberry
05-10-2007, 11:52 AM
MYarcade thanks alot.. you saved me... i had this error for 3 days now and i was trying to solve it with no success... i disabled flash chat and it worked fine :)