Log in

View Full Version : Mysql error, conflicting databses somehow


bret37
11-10-2006, 04:51 AM
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?

mySQL query error: UPDATE games_settings SET arcade_status='1',arcade_language='en',g_display_s ort='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',s how_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_choic es='5,10,15,20,25',allow_user_skin='0',def_cat='1' ,cats_per_tr='0',show_crowns='1',show_t_won='1',sc ore_sep='0',dec_amount='0',league_scores='10,9,8,7 ,6,5,4,3,2,1,0',use_announce='0',announcement='',a nnouncement_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