[URGENT] Forum Down, Got MySql Databse Error, PLZ Help ASAP

[ahsan]

Today i installed this MGC EVO CHAT BOX

http://www.vbteam.info/vb-3-8-x-add...-chatbox-evo-mgc-created-version-2-3-2-a.html


But after installation it didnt show on my forum, so i deleted every uploaded file and removed the product, i reverted everything.

But now when i goto Usergroup Manager, I still find a Box There for MGC Evo Chatbox settings, and

When i edit any other setting and save, i get this error

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Unregistered / Not Logged In',
`description` = '',
`usertitle` = 'Guest',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '0',
`forumpermissions` = '131079',
`genericpermissions` = '33554496',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`genericpermissions2` = '0',
`genericoptions` = '104',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '192',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '32',
`visitormessagepermissions` = '16',
`socialgrouppermissions` = '64',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`adminpermissions` = '0'
WHERE usergroupid=1;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, July 3rd 2009 @ 04:04:59 PM
Error Date : Friday, July 3rd 2009 @ 04:04:59 PM
Script : http://********.com/admincp/usergroup.php?do=update
Referrer : http://********.com/admincp/usergroup.php?do=edit&usergroupid=1
IP Address : XXX.XXX.XXX.XXX
Username : *******
Classname : vB_Database
MySQL Version : **********

Plus this hack has also a Language File to upload in language manager, that Language file also contains commands like this (of mgsc_evo chatbox) but now when i remove that language file, the following error occurs

You may not delete or disable user access to the language you have set as the default language for your forum. If you want to delete or disable user access to this language, please set another language to be the default language first.

Plz tell me how to remove it ???

I have already Repaired and Optimized tables, a number of times...PLz HElp me

 

[PAKIS-RULEZ]

Use this code put it in ur /includes/config.php in the end of that file add the code blow

define('disable_hooks', true);

it will disable all the mods then u log in to ur acp and disable that chat box...

I suggest you installing the inferno chat box pro

 

[ahsan]

i have already removed that plugin, how to disable that plugin now ?
there is no option...

 

[PAKIS-RULEZ]

i have already removed that plugin, how to disable that plugin now ?
there is no option...

re-upload the old chatbox files then to acp - products - then scroll down and re-import the mod and over write the mod see if it helps


the error is because b/c it didn't install right or was not un-installed properly.

 

[dark_hunter]

Try deleting the tables in phpmyadmin.

 

[ahsan]

there is only one table named as

mgc_cb_evo_log

and @ PAKIS-RULEZ:

I reuploaded the product, and when i uploaded it, everything works well..all settings, everything.
But Same happens when i remove it, i have removed each an every product and file and changes, but still after uninstall, i have this setting box in my Usergroup Manager.

plz tell me how to get rid of this damn Mod.....

 

[bluescorpion]

You haven't deleted the installed files, they are still being called by vBulletin even though the script says its uninstalled.

In the forum root, delete two files, mgc_cb_evo_ajax.php and mgc_cb_evo.php

In /clientscript delete the mgc_cb_evo folder

In /includes delete class_dm_mgccbchat.php and functions_mgc_cb_evo.php

In /includes/cron delete mgc_cb_evo_ban.php and mgc_cb_evo_digest.php

In /includes/xml (THIS is the problem) delete bitfield_mgc_cb_evo.xml, cpnav_mgc_cb_evo.xml and hooks_mgc_cb_evo.xml

In /admincp delete mgc_cb_evo.php

If all else is right, the problem should go away now...

 

[ahsan]

i already had deleted each n every single file, now there is no file in directory, but the problem is still there...
i had already mentioned that i delted each n every file

 

[bluescorpion]

Run, In your admincp/maintenance/Suspect File Versions, see if that gives you any clue where the problem is...

I would reupload the files in admincp from your vbulletin distribution.

The stuff you are seeing in the usergroup manager is coming from the Phrase Manager. You should search for

MGC Chatbox Evo : Custom Parameters

and related stuff and remove them from the phrase manager. The uninstall should have done that but looks like you will need to do it manually.