database error when I try to edit or add new usergroup

[Christon]

Friends, when I try to add or edit a usergroup, I get database error, and that is why I can not edit usergroups.

[MysCha]

please copy ur error message
i cant define what ur error

[Christon]

please copy ur error message
i cant define what ur error

The FTASatelliteKeys - FTA Caribbean Forums database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.ftasatellitekeys.com home page, then try to open another page.
* Click the Back button to try another link.

The www.ftasatellitekeys.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`forumpermissions` = '3928575',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511'
WHERE usergroupid=7;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, October 9th 2008 @ 02:35:08 PM
Error Date : Thursday, October 9th 2008 @ 02:35:08 PM
Script :
Referrer :
IP Address : ***********
Username : Christon
Classname : vB_Database
MySQL Version : 5.0.67-log

[veenuisthebest]

Error is caused by MGC Chat hack.

Uninstall it and do not forget to remove all files that you uploaded with the hack.

[MysCha]

do u install mods with called mgc_cb_evo or something like that ?

ur error on usergroup bitfields

u need delet all mgc_cb_evo file on ur forum directory
find it and delet.

[Christon]

No friends, I have installed this Chat:

Cyb - ChatBox

[MysCha]

No friends, I have installed this Chat:

Cyb - ChatBox

but ur error message say mgc_evo
check again

[veenuisthebest]

Simply means... you already have MGC uninstalled BUT the .XML files that came with it are still there.

Remve them from includes/xml/

[Christon]

is that I not have installed a chat box friends, I tried, but I find nothing.

[veenuisthebest]

Do you have these files in /yoursite/forum/includes/xml/

bitfield_mgc_cb_evo.xml
cpnav_mgc_cb_evo.xml

If yes, delete them !

[MysCha]

u never install MGC Plugin ?

i can define what ur plugin with mgc
but, i think u have install a MGC MODS in ur forum
please remember again. Because ur error message tell about it.

nb : ur error message cant lie

[Christon]

Do you have these files in /yoursite/forum/includes/xml/

bitfield_mgc_cb_evo.xml
cpnav_mgc_cb_evo.xml

If yes, delete them !

Where I find these veenuisthebest?, I search,but no find nothing.

--------------- Added 1223590827 at 1223590827 ---------------

u never install MGC Plugin ?

i can define what ur plugin with mgc
but, i think u have install a MGC MODS in ur forum
please remember again. Because ur error message tell about it.

nb : ur error message cant lie

No MysCha, i never install MGC plugin.

[MysCha]

or u can manualy drop a field on sql

open ur phpmyadmin
and search sql where u install ur forum

and search this prefix vb_usergroup
open the structure
then u can find anything field called " MGC "
check list and drop them

`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`forumpermissions` = '3928575',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511'
WHERE usergroupid=7;

* drop the red bold

[Christon]

or u can manualy drop a field on sql

open ur phpmyadmin
and search sql where u install ur forum

and search this prefix vb_usergroup
open the structure
then u can find anything field called " MGC "
check list and drop them

MysCha, forgives much trouble, but if you could teach me look like this, I would appreciate.

[MysCha]

u must try my guide
if not, ur forum cant run normaly coz u cant edit permission for ur usergroup

[Christon]

u must try my guide
if not, ur forum cant run normaly coz u cant edit permission for ur usergroup

you can send me your guide MysCha.

[MysCha]

^^
read this https://vborg.vbsupport.ru/showpost.php?p=1641437&postcount=13

[veenuisthebest]

well.. the problem isn't that complicated :D

Error is Unknown column 'mgc_cb_evo_permissions' in 'field list'

clearly means that the columns are ALREADY dropped, but the SQL query is still looking for that column.

This is happening due to the existence of those two .XML files in /xml/ folder on your server.
Remove them, and you're done.

[Christon]

well.. the problem isn't that complicated :D

Error is Unknown column 'mgc_cb_evo_permissions' in 'field list'

clearly means that the columns are ALREADY dropped, but the SQL query is still looking for that column.

This is happening due to the existence of those two .XML files in /xml/ folder on your server.
Remove them, and you're done.

I made the procedure, but the problem is still friends.

--------------- Added 1224106352 at 1224106352 ---------------

help please friends.