Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009

    Unanswered: Problems with quotes after moving database

    Hi to all,

    I moved a db from a website to another but i have big trouble with single/double quotes. I've recreated the site and built a new database with the same name as the original database. When I try to update an old article on the website I get the following error..

    I'm givin' her all she's got, Captain, but we need more power!
    This error said :
    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 've seen and manage your video collection.', `DESCRIPTION` = 'Coollector is a gre' at line 1
    And this because the description of the article contains a single quote:

    Coollector Movie Database: track the movies you've seen and manage your video collection.
    The old website MySQL version: 5.0.81
    The new website MySQL version: 5.1.30

    Pls. help me with a simple soution, it's been two days since i try and i try and I'm going crazy.

    Thank you in advance.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    INSERT INTO your_table description
    VALUES ('Coollector Movie Database: track the movies you''ve seen and manage your video collection. ')
    Home | Blog

Posting Permissions

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