PDA

View Full Version : HELP!!! SQL Error after Uninstalling MGC Chatbox!!!


TheSSDReview
02-08-2011, 11:43 AM
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 1297182859 at 1297182859 ---------------

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.