PDA

View Full Version : Very seirous database error


pooffck1
07-11-2008, 03:54 PM
Ok so i unstalled the evo chatbox

Every time i save something on usergroup it gives me this message

AND BANNED MEMBERS ARE UNBANNED :(( i cant do anything please help!!!!

Database error in vBulletin 3.7.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '<!-- Order=\"1\" -->Owner',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<img src=\"http://icons.primail.ch/stars/bstar07.gif\"/><b><font color=\"#0000FF\">',
`closetag` = '</font></b>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '8388607',
`genericpermissions` = '2147483647',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '200000',
`signaturepermissions` = '245759',
`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` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`creditpermissions` = '4094',
`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',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`vbblog_general_permissions` = '126',
`vbblog_entry_permissions` = '24188',
`vbblog_comment_permissions` = '990',
`split_useronline_permissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, July 11th 2008 @ 09:52:11 AM
Error Date : Friday, July 11th 2008 @ 09:52:11 AM
Script : http://blah-blah.com/forum/admincp/usergroup.php?do=update
Referrer : http://blah-blah.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ........................................ (REMOVED)
Username : Allmighty
Classname : vB_Database
MySQL Version : 5.0.24a-standard-log

Internetcafe
07-11-2008, 04:09 PM
Disable the MGC Chatbox (https://vborg.vbsupport.ru/showthread.php?t=168992&highlight=chatbox) hack you have installed and see if that solves the problem. If it does, then you have done something wrong during installation.

--------------- Added 1215796256 at 1215796256 ---------------

You obviously didn't uninstall the chatbox correctly ..

Opserty
07-11-2008, 04:13 PM
Go to this page (this forum): https://vborg.vbsupport.ru/forumdisplay.php?f=15
Click the "Search this Forums" button (top right of threads areas)
Enter "mgc_cb_evo_permissions" (the column causing your database error)
Hit search.
See the results.May the search be with you :D

pooffck1
07-11-2008, 04:20 PM
Go to this page (this forum): https://vborg.vbsupport.ru/forumdisplay.php?f=15
Click the "Search this Forums" button (top right of threads areas)
Enter "mgc_cb_evo_permissions" (the column causing your database error)
Hit search.
See the results.May the search be with you :D

Thanks :D it told me to delete some bitfield file from includes >> xml and it solved it.

Thanks alot