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

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

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

thanks

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

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