Log in

View Full Version : ibProArcade SQL Database Error


Chris583
05-22-2008, 08:28 PM
mySQL query error: UPDATE tournaments SET champion='Good Ol' Ramos' WHERE tid='1' LIMIT 1

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ramos' WHERE tid='1' LIMIT 1' at line 1
mySQL error code:
Date: Thursday 22nd 2008f May 2008 04:22:51 PM

was working fine on my vb 3.7 boards. Many people using it, many highscores, etc. Today no one can use it anymore and there i that SQL error.

Any idea what caused this and how to fix it?

nhlnut
06-15-2008, 03:50 PM
I'm getting this SQL error when trying to update an Arcade setting in the ACP.

mySQL query error: UPDATE games_settings SET arcade_status='1',arcade_language='en',g_display_s ort='position',g_display_order='ASC',scores_amount ='10',score_type='top',log='0',skin='0',use_cats=' 1',crown_type='2',notification='pm',show_new='1',s how_new_frame='86400',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='4',show_crowns='1',show_t_won='1',sc ore_sep=',',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',scoretimeout='1'

mySQL error: Unknown column 'scoretimeout' in 'field list'
mySQL error code:
Date: Saturday 14th 2008f June 2008 04:24:30 PM

Recently upgraded to the latest version of the Arcade. No problems prior to the upgrade. Any suggestions?