mySQL query error: INSERT INTO pmtext

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 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 [DATE]1213810397[/DATE] at [TIME]1213810397[/TIME] ---------------

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

--------------- Added [DATE]1213821345[/DATE] at [TIME]1213821345[/TIME] ---------------

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 [DATE]1213864533[/DATE] at [TIME]1213864533[/TIME] ---------------

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