Problem with friends invitation
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 ?
Re: Problem with friends invitation
Re: Problem with friends invitation
It's probably the apostrophe causing the problem.
Code:
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.
Re: Problem with friends invitation
Quote:
Originally Posted by grynmoors
It's probably the apostrophe causing the problem.
Code:
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.
Re: Problem with friends invitation
Or you could try using another phrase that doesn't have an apostrophe in it, or just remove the phrase entirely.
Re: Problem with friends invitation
Quote:
Originally Posted by grynmoors
Or you could try using another phrase that doesn't have an apostrophe in it, or just remove the phrase entirely.
Touche'