Log in

View Full Version : New MYSQl ERROR in 2.57+


Gn_Snake
11-02-2006, 05:52 AM
Hi,
Always in 2.5.7+ if I insert a game description using an apostrophe (Es: l' ) it give me this kind of mistake:

mySQL query error: UPDATE HG_games_list SET gwords='Aiuta Ercole a raggiungere nel suo Epico Viaggio l\\' antica Grecia',gcount='1',gtitle=' Herculympics',bgcolor='000000',gwidth='416',gheigh t='312',active='1',object='Aiuta Ercole a raggiungere nel suo Epico Viaggio l antica Grecia',gkeys='B, N and spacebar.',gcat='3',gname='HerculympicsSte',highsc ore_type='high',cost='0',jackpot_type='0',jackpot= '0',license='',decpoints='0',tourney_use='1',game_ type='0' WHERE gid=504



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 'antica Grecia',gcount='1',gtitle=' Herculympics',bgcolor='000000',gwidth='416',g' at line 1

mySQL error code:

Date: Thursday 02nd of November 2006 08:37:24 AM


HELP ME !!!!! :(

Gn_Snake
11-03-2006, 06:53 AM
Help!! :confused:

Ziki
11-03-2006, 07:02 AM
You really should use addslashes Mr.Zeropage.

Gn_Snake
11-03-2006, 11:58 AM
Sometimes when I write a description where it needs the apostrophe. It is range because with 2.56 version it didn't happen

MrZeropage, we really need a quick fix for this problem....:surprised: