vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Error in usergroup manager (https://vborg.vbsupport.ru/showthread.php?t=171950)

Mag1c 03-03-2008 04:07 AM

Database Error in usergroup manager
 
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....

Quote:

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 03-03-2008 04:36 AM

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

G0F0RBR0KE 03-03-2008 04:38 AM

I assume a hack that goes by vBCredits?

Mag1c 03-03-2008 04:44 AM

Quote:

Originally Posted by Dismounted (Post 1455670)
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 03-03-2008 05:27 AM

Please remove the vBcredits

Mag1c 03-03-2008 05:46 AM

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

Boofo 03-03-2008 05:56 AM

Did you uninstall it or just remove the files?

Mag1c 03-03-2008 05:57 AM

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

Boofo 03-03-2008 06:02 AM

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

G0F0RBR0KE 03-03-2008 06:02 AM

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 03-03-2008 06:18 AM

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 03-03-2008 07:53 AM

Depends what kind of hack that was before.

snakes1100 03-03-2008 10:07 AM

Quote:

Originally Posted by Mag1c (Post 1455710)
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 03-03-2008 10:07 AM

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 03-03-2008 10:13 AM

Quote:

Originally Posted by Dismounted (Post 1455804)
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 03-03-2008 05:28 PM

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 03-03-2008 05:47 PM

I would suspect: Cyb Chat box

Mag1c 03-03-2008 06:55 PM

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

snakes1100 03-03-2008 07:00 PM

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

Mag1c 03-03-2008 07:13 PM

Quote:

Originally Posted by snakes1100 (Post 1456167)
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 03-03-2008 07:16 PM

Follow instructions people give you...

Quote:

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


Mag1c 03-03-2008 07:22 PM

Quote:

Originally Posted by Opserty (Post 1456178)
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 03-03-2008 07:30 PM

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 03-03-2008 11:34 PM

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

I had an issue like this before.

Dismounted 03-04-2008 04:29 AM

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 04-11-2008 11:35 AM

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 04-11-2008 01:05 PM

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

hhcc 05-16-2008 02:25 PM

Delete this files and work again :)

hotfilepro 06-21-2010 10:31 PM

Quote:

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 01-04-2012 11:20 PM

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

epsilon80 07-07-2014 03:33 PM

Thankyou, it's work now!:)

ForceHSS 07-07-2014 04:10 PM

Quote:

Originally Posted by epsilon80 (Post 2505714)
Thank you, it's working now! :)

You are replying to a 6 year old topic


All times are GMT. The time now is 04:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01270 seconds
  • Memory Usage 1,799KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (32)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete