Database error when saving Usergroup

محروم.كوم · #1 05-18-2009, 07:10 AM

After making changes to a usergroup and hitting the save button I am getting the following database error:

HTML Code:
Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE efsusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',

`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`creditpermissions` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_paycheck` = '0',
`credit_active` = '20',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reputation` = '2',
`credit_infraction` = '-10',
`credit_thread` = '10',
`credit_threadrate` = '1',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.05',
`credit_ownthreadview` = '0.05',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '0.05',
`credit_pollmake` = '5',
`credit_pollvote` = '1',
`credit_attachment` = '3',
`credit_sendpm` = '-2',
`credit_addevent` = '3',
`credit_addprofpic` = '3',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '0',
`credit_pastotuser` = '0',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0.035',
`credit_maxsave` = '10000',
`credit_loanint` = '0.195',
`credit_maxloan` = '1000',
`credit_totloan` = '5',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '10',
`credit_lotdiscount` = '0',
`forumpermissions` = '770559',
`genericpermissions` = '304617027',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '10',
`pmthrottlequantity` = '0',
`calendarpermissions` = '49',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '254',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '32',
`visitormessagepermissions` = '6',
`socialgrouppermissions` = '0',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`vbarticles` = '0',
`vbblog_general_permissions` = '64',
`vbblog_customblocks` = '0',
`vbblog_custompages` = '0',
`vbblog_entry_permissions` = '0',
`vbblog_comment_permissions` = '0',
`ms_vopt_permissions` = '0',
`ms_force_style_permissions` = '0',
`force_style_id` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'ms_vopt_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, May 17th 2009 @ 09:47:20 PM
Error Date : Sunday, May 17th 2009 @ 09:47:20 PM
Script : http://www.sitename.com/forums/admin....php?do=update

Referrer : http://www.sitename.com/forums/admin...&usergroupid=2
IP Address : 97.96.1.103
Username : FBJunkie
Classname : vb_database
MySQL Version : 4.1.22 __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Forum Database error when making changes in Usergroup	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	12-23-2009 04:20 PM
Forum Database error when making changes in Usergroup	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	12-23-2009 04:10 PM
database error while editting usergroup	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-11-2009 09:50 PM
database error while editting usergroup	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-11-2009 09:40 PM
database error when saving style	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-11-2009 11:00 AM