Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2008, 01:55 PM
iNRoC iNRoC is offline
 
Join Date: Jul 2008
Location: Clifton, New Jersey
Posts: 151
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error affecting usergroup 2 permissions

I need some help with this error.

It happened after I uninstalled the MGC Chatbox.



Heres the error code..

Code:
Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Registered Users',
	`description` = '',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '3928575',
	`genericpermissions` = '1579685063',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`signaturepermissions` = '137215',
	`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` = '375',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=2;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, August 2nd 2008 @ 08:54:16 AM
Error Date    : Saturday, August 2nd 2008 @ 08:54:16 AM
Script        : http://www.uwhack.com/forum/admincp/usergroup.php?do=update
Referrer      : http://www.uwhack.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 
Username      : iNRoC
Classname     : vB_Database
MySQL Version : 5.0.45-community-log
Reply With Quote
  #2  
Old 08-02-2008, 02:04 PM
nexialys
Guest
 
Posts: n/a
Default

you have MGC Chatbox installed, it's clear if you read the error...

if you did not intalled OR uninstalled ALL THE FILES from this hack, the error will continue to occur...

read the documentation for that addon.

(it's actually the bitfield file from that addon that need to be removed)
Reply With Quote
  #3  
Old 08-02-2008, 02:15 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you use the search feature?

Here is what I found:
Adding New user group
Cant Edit UserGroups
Database Error in usergroup manager
Usergroup Addition issue
Modifing User Group Error
Weird problem
Error updating usergroups?
problem..
Reply With Quote
  #4  
Old 08-02-2008, 02:30 PM
iNRoC iNRoC is offline
 
Join Date: Jul 2008
Location: Clifton, New Jersey
Posts: 151
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok i fixed it. I removed the mgc bitfield
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:10 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.07684 seconds
  • Memory Usage 2,184KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (3)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete