Problem with friends invitation

[netvideos]

When I invited somebody to became friend, I have this message:

ERROR: Unable to execute query

INSERT INTO pm SET
subject='Invitation from webmaster',
body='

Hello moi,


NETVIDEOS is a new site for sharing and hosting personal videos. I have been using NETVIDEOS to share videos with my friends and family. I would like to add you to the list of people I may share videos with.


Personal message from webmaster:


----------------------------


As tu entendu parler de NETVIDEOS? J'adore ce site.


----------------------------


To accept my friend request, click here:


http://www.netvideos.fr/friend_accept.p ... 8121227632


To visit NETVIDEOS, click here.


Thanks,


herve
',
sender='webmaster',
receiver='videoswiper',
date='2008-08-24 18:16:21'


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 'adore ce site.

----------------------------

To accept my friend r' at line 3

How can I correct it ?

[netvideos]

Noboby can help me ?

[grynmoors]

It's probably the apostrophe causing the problem.

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 'adore ce site.

[CliftonH]

It's probably the apostrophe causing the problem.

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 'adore ce site.

Yeah it is the apostrophe in J'adore causing the problem. It needs to be escaped or removed.

[grynmoors]

Or you could try using another phrase that doesn't have an apostrophe in it, or just remove the phrase entirely.

[CliftonH]

Or you could try using another phrase that doesn't have an apostrophe in it, or just remove the phrase entirely.

Touche'