Usergroup Update Error

محروم.كوم · #1 08-15-2009, 03:50 AM

Upgraded to 3.8.3, and went to update Usergroup permissions and got this error which prevents me from going forward ...

PHP Code:

Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Admin',
`description` = '',
`usertitle` = 'Somebody',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '360',

`credit_ibp_passcost` = '50',
`credit_ibp_accesscost` = '50',
`credit_ibp_discount` = '10',
`credit_thanks_gain` = '5',
`credit_thanks_lose` = '-5',
`credit_thanks_give` = '0.1',
`credit_thanks_take` = '-0.1',
`creditpermissions` = '68',
`credit_induction` = '0',
`credit_referral` = '200',
`credit_refbonus` = '10',
`credit_paycheck` = '1000',
`credit_active` = '10',
`credit_birthday` = '1000',
`credit_repgive` = '2',
`credit_reputation` = '2',
`credit_infraction` = '0',
`credit_thread` = '10',
`credit_threadrate` = '2',
`credit_post` = '2',
`credit_ownthreadpost` = '2',
`credit_postsize` = '0',
`credit_ownthreadview` = '1',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '1',
`credit_ownprofileview` = '1',
`credit_pollmake` = '1',
`credit_pollvote` = '1',
`credit_attachment` = '0',
`credit_sendpm` = '0',
`credit_addevent` = '0',
`credit_addprofpic` = '2',
`credit_profile` = '5',
`credit_donmaxuser` = '0',
`credit_pastotpost` = '0',
`credit_pastotuser` = '0',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0',
`credit_maxsave` = '0',
`credit_loanint` = '0',
`credit_maxloan` = '0',
`credit_totloan` = '0',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '0',
`credit_lotdiscount` = '0',
`youtubintpermissions` = '1',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '0',
`mp3playergrouppermissions` = '3',
`Xtvpermissions` = '2047',
`awardpermissions` = '1',
`sudokupermissions` = '0',
`trgpermissions` = '15',
`radiotvpermissions` = '2047',
`forumpermissions` = '16777215',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`pmquota` = '600',
`pmpermissions` = '7',
`pmsendmax` = '50',
`pmthrottlequantity` = '0',
`calendarpermissions` = '31',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '120',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '800',
`sigpicmaxheight` = '600',
`sigpicmaxsize` = '80000',
`sigmaxrawchars` = '65535',
`sigmaxchars` = '65535',
`sigmaxlines` = '65535',
`sigmaxsizebbcode` = '400',
`sigmaximages` = '20',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',

`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`profileviewpermissions` = '15',
`vbtrends_permissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Request Date : Friday, August 14th 2009 @ 06:26:35 PM
Error Date : Friday, August 14th 2009 @ 06:26:35 PM
Script : http://www.xxtrentals.co.uk/forum/admincp/usergroup.php?do=update
Referrer : http://www.xxtrentals.co.uk/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 86.146.166.9
Username : daPLAYBOY
Classname : vB_Database
MySQL Version : 5.0.81-community

hope you can assist!

Thanks! __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
How to update usergroup based on user profile field value?	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	03-07-2010 11:10 PM
Forum cant update usergroup show database error	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-15-2010 10:10 AM
weird usergroup error	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-06-2009 02:10 PM
error when i want update to 3.8.3	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-15-2009 10:30 PM
error when i want update to 3.8.3	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-15-2009 10:22 PM