Log in

View Full Version : SQL error in ACP


Queball_Beast
11-06-2006, 01:35 AM
One of my Admins got this error few days ago, Can can anyone tell me how to fix it. The error seems to only occur when in the arcade main settings and save settings is clicked.
Thanks

The error is quoted below.

mySQL query error: UPDATE gpgames_settings SET arcade_status='1',arcade_language='en',g_display_s ort='position',g_display_order ='ASC',scores_amount='10',score_type='top',log='1' ,skin='0',use_cats='1',crown_t ype='2',notification='pm',show_new='14',show_new_f rame='86400',show_active='a:7: {s:5:"glist";s:1:"1";s:4:"play";s:1:"1";s:8:"newscore";s:1:"1";s:5:"stats";s:1:" 1";s:15:"viewtournaments";s:1:"1";s:11:"playtourney";s:1:"1";s:11:"viewtourney"; s:1:"1";}',auto_prune='1',auto_prune_time='0',auto_prune_ time2='86400',games_pr= '4',games_pp='40',user_choices='5,10,15,20,25',all ow_user_skin='1',def_cat='6',c ats_per_tr='3',show_crowns='1',show_t_won='1',scor e_sep=',',dec_amount='0',leagu e_scores='10,9,8,7,6,5,4,3,2,1,0',use_announce='1' ,announcement='Game of the Week -- None

hey all if u having any problem\\'s with
the arcade be sure to let me know
thxs gob ^^ thanks to amphibianbeast',announcement_parsed='Game of the Week -- None<br />
<br />
hey all if u having any problem\\'s with <br />
the arcade be sure to let me know <br />
thxs gob ^^ thanks to amphibianbeast',games_new='15',games_popular='15'

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 's with
the arcade be sure to let me know
thxs gob ^^ thanks
mySQL error code:
Date: Sunday 29th of October 2006 07:59:51 PM

MrZeropage
11-06-2006, 08:16 AM
again a problem with the special character '

sorry for that, I soon will release v2.5.8+ with a fix for all this concerning special characters ect

Queball_Beast
11-06-2006, 08:33 PM
Thankyou "MrZeropage" I look forward to it.:)

Queball_Beast
11-27-2006, 06:44 PM
again a problem with the special character '

sorry for that, I soon will release v2.5.8+ with a fix for all this concerning special characters ect
Is there a tempory fix for this, or it cant be fix at the moment until the release of the update?
mySQL query error: UPDATE gpgames_settings SET arcade_status='1',arcade_language='en',g_display_s ort='position',g_display_order ='ASC',scores_amount='10',score_type='top',log='1' ,skin='0',use_cats='1',crown_t ype='2',notification='pm',show_new='14',show_new_f rame='86400',show_active='a:7: {s:5:"glist";s:1:"1";s:4:"play";s:1:"1";s:8:"newscore";s:1:"1";s:5:"stats";s:1:" 1";s:15:"viewtournaments";s:1:"1";s:11:"playtourney";s:1:"1";s:11:"viewtourne y"; s:1:"1";}',auto_prune='1',auto_prune_time='0',auto_prune_ time2='86400',games_pr= '4',games_pp='40',user_choices='5,10,15,20,25',all ow_user_skin='1',def_cat='6',c ats_per_tr='3',show_crowns='1',show_t_won='1',scor e_sep=',',dec_amount='0',leagu e_scores='10,9,8,7,6,5,4,3,2,1,0',use_announce='1' ,announcement='Game of the Week -- None

hey all if u having any problem\\'s with
the arcade be sure to let me know
thxs gob ^^ thanks to amphibianbeast',announcement_parsed='Game of the Week -- None<br />
<br />
hey all if u having any problem\\'s with <br />
the arcade be sure to let me know <br />
thxs gob ^^ thanks to amphibianbeast',games_new='15',games_popular='15'

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 's with
the arcade be sure to let me know
thxs gob ^^ thanks
mySQL error code:
Date: Sunday 29th of October 2006 07:59:51 PM Thanks:)