Results 1 to 6 of 6

Thread: Problem with friends invitation

  1. #1
    Join Date
    Aug 2008
    Posts
    7

    Default 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 ?

  2. #2
    Join Date
    Aug 2008
    Posts
    7

    Default Re: Problem with friends invitation

    Noboby can help me ?

  3. #3
    Join Date
    May 2007
    Location
    Planet Earth
    Posts
    1,389

    Default 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.
    If it's not fun, stop doing it!

  4. #4
    Join Date
    Mar 2008
    Location
    Dayton, Ohio
    Posts
    52

    Default 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.

  5. #5
    Join Date
    May 2007
    Location
    Planet Earth
    Posts
    1,389

    Default 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.
    If it's not fun, stop doing it!

  6. #6
    Join Date
    Mar 2008
    Location
    Dayton, Ohio
    Posts
    52

    Default 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'

Similar Threads

  1. Greetings vShare friends
    By grynmoors in forum General Discussions
    Replies: 4
    Last Post: 04-15-2009, 09:45 PM
  2. friends.tpl
    By pat33 in forum Template Modifications
    Replies: 3
    Last Post: 02-15-2008, 11:42 PM
  3. friends type
    By surfmore in forum Template Modifications
    Replies: 2
    Last Post: 12-10-2007, 01:13 PM
  4. adding friends
    By devarioj in forum Feature Requests
    Replies: 1
    Last Post: 09-17-2007, 10:31 AM
  5. Friends Bug?
    By zeffer in forum Fixed Bugs
    Replies: 1
    Last Post: 05-22-2007, 01:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •