vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   Mysql error, conflicting databses somehow (https://vborg.vbsupport.ru/showthread.php?t=131187)

bret37 11-10-2006 04:51 AM
Mysql error, conflicting databses somehow
 
I am getting a weird error when trying to update some settings in my adminCP as well as errors after game completion. It seems to want to connect to my item cache database (where I store itemstats for World of Warcraft), is there anyway to hard code or change something so it will connect to my forum database where the tables are?

Code:
mySQL query error: UPDATE games_settings SET arcade_status='1',arcade_language='en',g_display_sort='gtitle',g_display_order='ASC',scores_amount='10',score_type='top',log='0',skin='0',use_cats='0',crown_type='1',notification='none',show_new='0',show_new_frame='60',show_active='a:7:{s:5:"glist";s:1:"0";s:4:"play";s:1:"0";s:8:"newscore";s:1:"0";s:5:"stats";s:1:"0";s:15:"viewtournaments";s:1:"0";s:11:"playtourney";s:1:"0";s:11:"viewtourney";s:1:"0";}',auto_prune='0',auto_prune_time='0',auto_prune_time2='3600',games_pr='4',games_pp='40',user_choices='5,10,15,20,25',allow_user_skin='0',def_cat='1',cats_per_tr='0',show_crowns='1',show_t_won='1',score_sep='0',dec_amount='0',league_scores='10,9,8,7,6,5,4,3,2,1,0',use_announce='0',announcement='',announcement_parsed='',games_new='15',games_popular='15'

mySQL error: Table 'bominati_items.games_settings' doesn't exist
mySQL error code:
Date: Thursday 09th 2006f November 2006 11:47:32 PM

MrZeropage 11-11-2006 05:29 AM
did you import the product correctly ? The arcade itself loads ?

bret37 11-14-2006 06:53 PM
Yeah I imported it correctly, I can play games, see all the settings, etc etc

My footer calls another database to retrieve these item links to display with javascript. Must be the way the arcade hooks into the vbulletin database.

I pretty much fixed my problem by just merging my item database into my vbulletin one


All times are GMT. The time now is 02:02 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.00930 seconds
  • Memory Usage 1,711KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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