WordPress database error in WP2.01 when post has apostrophe and an image (5 posts)

  1. asanocki
    Posted 10 years ago #

    I get a 'WordPress database error' at times when I post. I've tried it enough times to see that it is only happening under one repeatable case:

    1. the post has a single quote (apostrophe) in it somewhere
    * AND *
    2. I've added an image to the post via the new WP2.01 upload tool and chosen to link it to another page NOT to either the original image or to nothing.

    Here is such a post: http://blog.designpublic.com/2006/02/14/san-francisco-pillow-fight-club/

    Note the apostrophe ("San Francisco's") and the use of the image of the woman linked to another page.

    And here is the error I get every time:

    WordPress database error: [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
    UPDATE IGNORE wp_posts SET
    post_author = '1',
    post_date = '2006-02-14 22:16:26',
    post_date_gmt = '2006-02-15 06:16:26',
    post_content = '
    <img align="right" id="image356" alt="San Francisco Pillow Fight Club" src="http://blog.designpublic.com/wp-content/uploads/2006/02/99942493_2eaad5724a.jpg" />And now for something completely different.

    So today around 5:00 PM our bookkeeper Suzie gets up to leave with a pillow in one arm, bike helmet in the other. Someone asked where she was headed, and she mentioned that she was doing battle in an hour at San Francisco's Pillow Fight Club.

    We discussed it as a team and decided to send a small Design Public army along with her. Matt (creative) and Noel (resident DJ) tagged along with Suzie, armed to the teeth with an array of decorative contemporary design pillows that we had laying around the office . . . you know, returns.

    How's 100% down taste, huh? No, this ain't the tooth fairy, just a 20" by 20" block of cold-hard modern designed pain comin' at you. You want some more? There's more where that came from.

    Check out photos from the event in our newest Flickr set.',
    post_content_filtered = '',
    post_title = 'San Francisco Pillow Fight Club!',
    post_excerpt = '',
    post_status = 'publish',
    comment_status = 'open',
    ping_status = 'open',
    post_password = '',
    post_name = 'san-francisco-pillow-fight-club',
    to_ping = '',
    pinged = '
    post_modified = '2006-02-16 11:14:35',
    post_modified_gmt = '2006-02-16 19:14:35',
    post_parent = '0',
    menu_order = '0'
    WHERE ID = 353

    Note that I've included the source because there's an image in there.

    More QA notes:
    - the post saves fine if I insert the image via the WP tool as "not linked" and then add the link afterwards.
    - it seems to be getting hung up on the apostrophe but only when the image is added to the post with a link via the AP upload tool.
    - I'm running MySQL 4.1.14, Firefox on Mac OS X

    Any thoughts?

  2. asanocki
    Posted 10 years ago #

    Anyone? Bueller?

  3. iand
    Posted 10 years ago #

    Looks like this problem though it says it should have been fixed in 2.0.1

  4. khimichcom
    Posted 10 years ago #

    You can try to turn on magic_quotes in your PHP config. That will solve your problem without reinstalling WP

  5. asanocki
    Posted 10 years ago #

    Hey, thanks -- but so far, unlike this case, it happens irrespective of whether there are quotes in the name of the image.

    And I do have magic quotes on.

    You think I need to reinstall then?

Topic Closed

This topic has been closed to new replies.

About this Topic