-
Database Error
I tried to update the UserGroup permissions to Yes for most options in Wiki. When I clicked on the Update button I got the following error message. I am assuming it's a Wiki error due to the line that says
Code:
MySQL Error : Unknown column 'ms_wic_addon_permissions' in 'field list'
The full message:
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
UPDATE vb3_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color = \"black\"><u><b>',
`closetag` = '</b></u></font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '486539263',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '24575',
`vbblog_comment_permissions` = '990',
`vault_permissions` = '255',
`specialpage_permissions` = '255',
`awardpermissions` = '1',
`c_news_letter_perms` = '0',
`creditpermissions` = '54',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_paycheck` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reputation` = '10',
`credit_infraction` = '-10',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_ownthreadview` = '0.05',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '0.05',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`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',
`memberindex` = '0',
`vault_misc` = '0',
`sf_permissions` = '31',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '235519',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '62',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`ms_wic_addon_permissions` = '0'
WHERE usergroupid=6;
MySQL Error : Unknown column 'ms_wic_addon_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, April 4th 2010 @ 01:00:51 AM
Error Date : Sunday, April 4th 2010 @ 01:00:51 AM
Script : http://www.rwf-forum.co.uk/vBulletin/admincp/usergroup.php?do=update
Referrer : http://www.rwf-forum.co.uk/vBulletin/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 94.195.159.114
Username : xxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.89-community-log
-
That field is not from this product. I don't know what product it is. If you don't have its product installed, then you'll want to delete the bitfield file in includes/xml/ for it. I can't tell you the exact file name you want to delete either for the same reasons.