The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
HELP!!! SQL Error after Uninstalling MGC Chatbox!!!
I tried to install MGC Chatbox Evo with no luck so uninstalled and moved to MGA which worked perfectly.
I just went into Usergroups to edit standard permissions and saw that all of the options and permissions for the now deleted MGC Chatbox were still there. I never thought much of it until I tried to alter a permission and was told that I could not because there were sql errors, the errors specifically relating to bad sql commands and the original chatbox permissions that were not deleted with the program. I am now...locked out if you will as I cannot change permissions. Thoughts? I also cannot hit the reset button as nothing happens. Les Here it is... Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Registered Users', `description` = '', `usertitle` = '', `opentag` = '<span style=\"color: Orange;\">', `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_nbthreads_perday_show` = '0', `mgc_cb_evo_max_chats_perday` = '0', `forumpermissions` = '12317183', `genericpermissions` = '1579685575', `attachlimit` = '0', `pmquota` = '50', `pmpermissions` = '3', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '63', `wolpermissions` = '1', `adminpermissions` = '0', `genericpermissions2` = '1', `genericoptions` = '62', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '80', `avatarmaxheight` = '80', `avatarmaxsize` = '20000', `signaturepermissions` = '169983', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '10000', `sigmaxrawchars` = '1000', `sigmaxchars` = '500', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '4', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albummaxpics` = '100', `albummaxsize` = '0', `usercsspermissions` = '191', `visitormessagepermissions` = '63', `socialgrouppermissions` = '251767', `maximumsocialgroups` = '5', `groupiconmaxsize` = '65535' --------------- Added [DATE]1297182859[/DATE] at [TIME]1297182859[/TIME] --------------- I have seen alot of threads with no straightforward answer for this and figured one out: 1. Go into your Forum directory and delete all of the pertinent files for this program; 2. Rebuild and repair the Database in the options by SQL Query. Fixed. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|