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

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 06-30-2009, 08:35 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Gamelobby View Post
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.!!

....

Also.. FYI. If i disable the Cyb chatbox it works.!
That doesn't make sense. If the chatbox isn't installed on this board, how can you disable it on this board and have it work?

Make sure you have no leftover files from the chatbox uploaded to your server regarding the chatbox modification.
Reply With Quote
  #3  
Old 07-01-2009, 11:24 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No i disabled the Cyb chatbox which is the one that is installed, it is the MGC chatbox that was not installed on the board, but i must have installed it in the past and it didn't all get deleted when i uninstalled it.
Reply With Quote
  #4  
Old 07-01-2009, 11:31 PM
MAORBARI MAORBARI is offline
 
Join Date: Sep 2008
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

in includes dir delete all files with the word MGC after enter XML DIR and delete all files with the word MGC in the name.
Reply With Quote
  #5  
Old 07-02-2009, 05:00 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If the above poster was not clear enough - you need to remove the modification's files when you uninstall it. Especially the ones in /includes/xml (which is causing the errors).
Reply With Quote
  #6  
Old 07-02-2009, 07:52 AM
MAORBARI MAORBARI is offline
 
Join Date: Sep 2008
Posts: 110
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
If the above poster was not clear enough - you need to remove the modification's files when you uninstall it. Especially the ones in /includes/xml (which is causing the errors).
i sorry for my bad english..
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 09:40 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.07482 seconds
  • Memory Usage 2,213KB
  • 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
  • (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)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_postinfo_query
  • fetch_postinfo
  • 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