Error when changing a nickname

[Soulsiick]

There is user in my forum when I want to change his nickname to Fidanzata d'Italia the forum shows me this 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 'Italia' OR memberName LIKE 'Fidanzata d'Italia')
LIMIT 1' at line 4

file : /home/talarju/public_html/Sources/Subs-Members.php
Line : 936

And the line in the file says :

LIMIT 1", __FILE__, __LINE__);


+ the forum version is 1.1.14

[Oldiesmann]

The apostrophe is messing it up, and SMF isn't escaping it for some reason. Try entering the name as Fidanzata d\'Italia instead and see if that works.

[Soulsiick]

Didn't work. Gives the same error. But tried Fidanzata dItalia just to make sure if its the apostrophe, and it worked fine without it.

what else can I do ?

[ziycon]

Try entering it as Fidanzata d''Italia.

[Soulsiick]

Well it worked, kind of ! Cause that's not really solved the problem.

But anyway, thanks.

[Oldiesmann]

SMF doesn't expect apostrophes in user/display names, but if they are supported (as it appears they are), then we need to escape them. I'll test it out on my 2.0 test board later, and if it's still a problem, I'll file a bug report about it.