mySQL query error: INSERT INTO pmtext

[chet]

Searched through the 10 pages here but could not find any answers to my problem, can any of you see the fault and suggest how I fix it please, I;m guessing its a Tournament issue

Thanks all

mySQL query error: INSERT INTO pmtext (fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie) VALUES ('30', 'O'Kane', 'Tournament Information', 'Hello O\'Kane,

please remember to make your game in the Jewel Quest-Tournament

Click here (\'http://forums.cliftonfc.co.uk/arcade.php?do=viewtourney&tid=2\') to view this tournament.', 'a:1:{i:0;s:2:\"30\";}', 0, 1213806540, 0, 0)

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 'Kane', 'Tournament Information', 'Hello O\'Kane,

please remember to make your g' at line 1
mySQL error code:
Date: Wednesday 18th 2008f June 2008 05:29:00 PM

--------------- Added 1213810397 at 1213810397 ---------------

forgot to mention, this is stopping users getting to the arcade now, it just dispalys the above

--------------- Added 1213821345 at 1213821345 ---------------

Ok looks like there is a bug, this is from my host

This is a problem with the PHP script, it is not properly escaping the apostrophes in the SQL query before sending it to MySQL; you will need to contact the developer of the PHP script involved for a bug fix.

--------------- Added 1213864533 at 1213864533 ---------------

can anybody help please, at the moment my arcade is down

thanks

[towermatt]

Any way to find an answer to this one, it's happening to me now as well.

[chet]

The problem is that I have a user called O'Kane and its the ' in the name that is causing the issue