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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-30-2009, 08:26 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Usergroup DB error..!?

New problem..

I'm guessing it has nothing to do with the Arcade mod. BUT...

When i try to give usergroups access to arcade, it gives me this error.
Code:
Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Registered Users',
	`description` = '',
	`usertitle` = '',
	`opentag` = '<span style=\"color: grey;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',

	`forumpermissions` = '12317183',
	`genericpermissions` = '1579685575',
	`awardpermissions` = '1',
	`arcadepermissions` = 'Array',
	`minpoststoplay` = '0',
	`minreptoplay` = '-1000',
	`minreglengthtoplay` = '0',
	`mgc_cb_evo_permissions` = '0'
WHERE usergroupid=2;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, June 30th 2009 @ 02:12:20 PM
Error Date    : Tuesday, June 30th 2009 @ 02:12:21 PM
Script        : http://www.example.com/***/forums/admincp/usergroup.php?do=update
Referrer      : http://www.example.com/***/forums/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : **.***.**.***
Username      : *********
Classname     : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log
Now the interesting part is that the error relates to a "mgc_cb_evo" chatbox, but that chatbox is not the one that is installed on this board.!!

So im guessing in my dealings earlier today when i had DB issues on another board that is using that mgc chatbox it got screwed up, so i guess im wondering how do i remove this from THIS boards DB.?

On a side note i had issues earlier that may have caused this, but i dont know how, or why.
I was upgrading another board (seperate DB) and in that process somehow got this DB confused, & had the wrong board on the wrong url. But all is fixed now except for this.


Thanks

--------------- Added [DATE]1246397481[/DATE] at [TIME]1246397481[/TIME] ---------------

Also.. FYI. If i disable the Cyb chatbox it works.!

--------------- Added [DATE]1246397684[/DATE] at [TIME]1246397684[/TIME] ---------------

Got it. Sorry to post without trying more.

I just installed the mgc_chatbox then uninstalled it.
Reply With Quote
 


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 03:00 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.03831 seconds
  • Memory Usage 2,375KB
  • 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)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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