Greetings;
I did install the product vbShout , then tried to fix user groups permissions > then update
I got database error as following:
=================================
Database error in vBulletin 4.1.11:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'أرافيلى جديد',
`description` = 'مباشرة بعد التسجيل',
`usertitle` = 'أرافيلى جديد',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`idealchatpermissions` = '0',
`forumpermissions` = '1782015',
`genericpermissions` = '1378628291',
`attachlimit` = '0',
`pmquota` = '20',
`pmpermissions` = '1',
`pmsendmax` = '2',
`pmthrottlequantity` = '0',
`calendarpermissions` = '1',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`mgc_cb_evo_nbthreads_perday_show` = '0',
`mgc_cb_evo_max_chats_perday` = '0',
`ms_vopt_permissions` = '0'
WHERE usergroupid=2;
MySQL Error : Unknown column 'mgc_cb_evo_nbmsg_show' in 'field list'
Error Number : 1054
Request Date : Monday, April 2nd 2012 @ 09:14:52 AM
Error Date : Monday, April 2nd 2012 @ 09:14:52 AM
Script : Log in - ARAPHIL - vBulletin Admin Control Panel
Referrer : Log in - ARAPHIL - vBulletin Admin Control Panel
IP Address : 180.190.31.192
Username : dr.helal
Classname : vB_Database
MySQL Version : 5.5.19-55
========================
I uninstalled the product , still getting the same message when trying to update any user group
after being uninstalled, I found this section displayed in user groups page (MGC Chatbox Evo : Custom permissions) , not removed
This may be the reason that I got the same database error
How can I solve this and remove that section from user groups page?
Downloading the original vbullettin script did not resolve the issue
Thanks in advance
|