Database Error in usergroup manager

[Mag1c]

I recently installed 2 modifications, for my vBulletin 3.6.8 forum.

- User group color bar.

- CYB Chat box

I set them up, everything worked great. However, when I went to go change a color for a usergroup, in the usergroup manager, once I clicked update I was brought to a Database Error screen.

There's a yellow box with the follow inside....

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '(COPPA) Users Awaiting Moderation',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '655375',
`genericpermissions` = '33554499',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericoptions` = '56',
`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',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_daily` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reppos` = '10',
`credit_repneg` = '-15',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_unthread` = '-20',
`credit_unpost` = '-5',
`creditpermissions` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=4;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Date : Monday, March 3rd 2008 @ 01:02:57 AM
Script : REMOVED FOR PRIVACY PURPOSES
Referrer : REMOVED FOR PRIVACY PURPOSES
IP Address : REMOVED FOR PRIVACY PURPOSES
Username : REMOVED FOR PRIVACY PURPOSES
Classname : REMOVED FOR PRIVACY PURPOSES

[Dismounted]

You uninstalled a modification and forgot to remove its *.xml files.

[G0F0RBR0KE]

I assume a hack that goes by vBCredits?

[Mag1c]

You uninstalled a modification and forgot to remove its *.xml files.

I didn't, maybe one of my other Administrators did, as far as I know none of them have. Could you be a little bit more broad on what your explanation was? All I did was install these 2 mods, then after User Group Manager, doesn't work when I try to UPDATE a user groups settings?


And yes I have vBCredits, should I uninstall that?

I would really appreciate an immediate answer.

[G0F0RBR0KE]

Please remove the vBcredits

[Mag1c]

I removed the vBCredits, as well as everything from the FTP involving vBCredits. And I still get the error...

[Boofo]

Did you uninstall it or just remove the files?

[Mag1c]

Both, I cna't figure out what's wrong.

[Boofo]

The error tells you. The mgc_cb_evo_permissions column is causing the problem.

[G0F0RBR0KE]

Do this, reinstall the vBCredits, and remove it properly. This way, it will rebuilt anything that is going wrong. Once it's rebuilt, go to the ACP and remove them from there. Disable it first, then remove it, and finally, remove it from FTP.

[Mag1c]

I've done literally everything you've said about the vBCredits, even the template edits. But, I still get the error. HOWEVER! Through this process there's this box, that I've come across numerous times when trying to update my member settings. It's sitting here empty with no text, no nothing...

Cause of my problem?

http://img412.imageshack.us/img412/5792/box222sh8.jpg

If so, how do I remove this?

[G0F0RBR0KE]

Depends what kind of hack that was before.

[snakes1100]

I've done literally everything you've said about the vBCredits, even the template edits. But, I still get the error. HOWEVER! Through this process there's this box, that I've come across numerous times when trying to update my member settings. It's sitting here empty with no text, no nothing...

Cause of my problem?

http://img412.imageshack.us/img412/5792/box222sh8.jpg

If so, how do I remove this?

That is most likely the xml file that you didnt remove thats part of mgc's chatbox and is why those blank options are still in the usergroup options.

[Dismounted]

I don't believe mgc_cb_evo_permissions is a vBCredits column.

Could you please post the hacks you have installed and the contents of your includes/xml folder?

[snakes1100]

I don't believe mgc_cb_evo_permissions is a vBCredits column.


I was wondering when someone would say that, i just didnt want to be the first... :D

[Mag1c]

I installed the following hacks, RIGHT after the installation of them, I received those errors.

- Cyb Chat box

- Members who have Visited

- User group Color Legend, but I've removed it from my Plugins & Products.

[Boofo]

I would suspect: Cyb Chat box

[Mag1c]

I un installed it and that damn box is still there, and I still get the error, I'm really get angry now.

[snakes1100]

Its because you didnt uninstall it correctly and you havent removed all the files from the hack.

[Mag1c]

Its because you didnt uninstall it correctly and you havent removed all the files from the hack.

What do you mean I didn't uninstall it correctly? I just clicked uninstall... Unless you have to disable it first.

So, what..

Do I have to RE INSTALL it and make everything work, disable it, then uninstall it?

[Opserty]

Follow instructions people give you...

Could you please post the hacks you have installed and the contents of your includes/xml folder?

[Mag1c]

Follow instructions people give you...

I've followed the instructions everyone in this thread has given me.. And I keep saying, it's not working.

I think it would be best to just submit a ticket to vBulletin's support.


Since I've tried everything, everyone has said.

[Opserty]

Read what I quoteed and do what I said in the bold... I quoted it for a reason!

vBulletin.com most likely won't help you as you have installed modifications, i.e. changed the code and so invalidated the support.

[G0F0RBR0KE]

I can try to help you. Do you have MSN?

I had an issue like this before.

[Dismounted]

This is caused by a stray bitfield_*.xml file located in /includes/xml. Please post all the hacks you have ever installed and the contents of that folder.

[jarosciak]

I've fixed the same problem by going to my forum's \includes\xml and removing two of this files related to chatbox evo:

bitfield_mgc_cb_evo.xml
&
cpnav_mgc_cb_evo.xml

Even that I've uninstalled the chatbox, these files weren't automatically removed.
This fixed the problem once I've logged in to my administration panel again.
I hope this helped.

[ssslippy]

Files can not be automatically removed. You have to delete them manually.

[hhcc]

Delete this files and work again :)

[hotfilepro]

I've fixed the same problem by going to my forum's \includes\xml and removing two of this files related to chatbox evo:

bitfield_mgc_cb_evo.xml
&
cpnav_mgc_cb_evo.xml

Even that I've uninstalled the chatbox, these files weren't automatically removed.
This fixed the problem once I've logged in to my administration panel again.
I hope this helped.

THank you, it works for me :)

[Prorockz]

i was have same problem but finally figured out,
just re install it and then uninstall........
i am really happy on my talent;)

[epsilon80]

Thankyou, it's work now!:)

[ForceHSS]

Thank you, it's working now! :)
You are replying to a 6 year old topic