PDA

View Full Version : Database Error! Help Please!


Downsx
10-23-2009, 02:26 AM
I recently uninstalled the Evo Chatbox

Every time i try to edit user permissions now I get a database error!

Please Help!


Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<b><font color=\"red\">',
`closetag` = '</font></b>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '0',
`mgc_cb_evo_max_chats_perday` = '0',
`arcadepermissions` = '0',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`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` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, October 22nd 2009 @ 10:24:23 PM
Error Date : Thursday, October 22nd 2009 @ 10:24:23 PM
Script : http://runefusion.net/admincp/usergroup.php?do=update
Referrer : http://runefusion.net/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 127.0.0.1
Username : Tony
Classname : vB_Database
MySQL Version : 5.1.30-community

Lynne
10-23-2009, 02:32 AM
Downsx,

You are currently showing up as unlicensed.

To be able to download modifications and/or receive support here at vBulletin.org, we ask you to please click here (http://members.vbulletin.com/membersupport_priority.php) (vB-Germany users click here (http://members.vbulletin-germany.com/membersupport_priority.php), vB-Chinese users click here (http://members.vbulletin-china.cn/membersupport_priority.php)) and enter your email address. You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

To protect our customers privacy you will also need to Opt-In to license validation for all Support Sites. You must authorise vBulletin.org in order to validate your license status here. You can do this at the page linked above for your distributor. Make sure to set the permission to allow vBulletin.org to validate your status.

The update of your account can take up to one hour.

Thank you.