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.


All times are GMT. The time now is 10:42 AM.

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.01153 seconds
  • Memory Usage 1,738KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete