+ Reply to Thread
Results 1 to 5 of 5

Thread: Syntax Error

  1. #1
    lovemycrafts
    Guest

    Syntax Error

    I am having the same problem! (See below @ <snip>)

    UPDATE members_data SET descr='Empower your child\\'s mind with books & software that develop critical thinking across the curriculum! ' WHERE listname="lovemycrafts" AND id=110
    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 's mind with books & software that develop critical thinking acr

    How do I fix this?



    <Snip>

    I have a couple members who are trying to change there listings ... when I click approve I get this message back:

    UPDATE members_data SET name='Pamm's House' WHERE listname="earlychildhood" AND id=103
    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 's House' WHERE listname="earlychildhood" AND id=103' at line 1

    What does this mean?

  2. #2
    Scott
    Guest
    Hmmm... interesting. It looks like this is happening because of the ' in the description. I thought we had this problem fixed but I guess not. I will do my best to get ahold of the programmer to fix it this weekend but if not, monday for sure.

    In the meantime, I have taken the apostophe out of the word child's that is causing the problem and you can make changes now.

    I'll post here when the problem is solved more permanently.

  3. #3
    lovemycrafts
    Guest
    Thank you very much for your quick response and the temporary fix!!

    Carla

  4. #4
    Scott
    Guest
    All fixed now! Feel free to add as many apostrophe's as you'd like!

  5. #5
    lovemycrafts
    Guest
    Thank you very much! You're a peach!

+ Reply to Thread

Similar Threads

  1. Error message
    By nikkicandles in forum Questions and Answers
    Replies: 2
    Last Post: 04-05-2010, 06:53 PM
  2. Error on voting
    By Mummiesmutiny in forum Questions and Answers
    Replies: 2
    Last Post: 04-07-2007, 08:36 PM
  3. Keep getting error message when moving a site up
    By JJ in forum Questions and Answers
    Replies: 1
    Last Post: 04-21-2005, 01:51 PM
  4. Syntax Error?
    By slovett in forum Questions and Answers
    Replies: 3
    Last Post: 04-11-2005, 10:59 PM
  5. Linking Code Syntax
    By Larae in forum Questions and Answers
    Replies: 4
    Last Post: 04-03-2005, 07:45 AM

Posting Permissions

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