PDA

View Full Version : (Bug) Usernames with apostrophies (sp?)


toonysnn
27 Nov 2006, 03:34
A user on a website I go to has a error just because they have a apostrophy (sp?) in their username.
mySQL query error: UPDATE games_champs SET champ_gid='123',champ_gtitle='Togy Ball',champ_mid='28949',champ_name='Good Ol\\' Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_gid=123

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 'Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_g' at line 1
mySQL error code:
Date: Sunday 26th 2006f November 2006 06: 30 :39 PM

I can't really explain what it is and why I keep getting this messege when I try to submit a score.

Neo_obs
27 Nov 2006, 05:43
I am getting the same problem is it me or should the \\ be // I am not very good at MySQL but I think thats whats wrong. I guess I will wait for zero to get back from vacation

toonysnn
27 Nov 2006, 21:06
Actually, it's supposed to be like so:
UPDATE games_champs SET champ_gid='123',champ_gtitle='Togy Ball',champ_mid='28949',champ_name='Good Ol\' Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_gid=123Instead of...UPDATE games_champs SET champ_gid='123',champ_gtitle='Togy Ball',champ_mid='28949',champ_name='Good Ol\\' Skippy Sniffleflipper',champ_date='1164587438',champ_scor e='16241' WHERE champ_gid=123

MrZeropage
28 Nov 2006, 11:03
all problems with those "special characters" are fixed in v2.5.8+ which is about to come in the next days