• artchick

    (@artchick)


    Apologies if this has been posted before – I searched, but did not find my specific issue. I have set up the basic brower-activated post by email, and it is working. My only problem is that if my posts have an apostrophe in them, I get the following errors:

    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 time for the apostrophe, don’t you?’, ‘Next thing to check’]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_modified, post_modified_gmt, post_content, post_title, post_excerpt, post_category, post_status, post_name, comment_status, ping_status, post_parent) VALUES (‘2’, ‘2006-04-07 14:11:33’, ‘2006-04-07 19:11:33’, ‘2006-04-07 14:11:33’, ‘2006-04-07 19:11:33’, ‘Commas, check. Question mark, check. “Quotes are good”. Now I think it’s time for the apostrophe, don’t you?’, ‘Next thing to check’, ”, ‘9’, ‘publish’, ‘next-thing-to-check’, ‘open’, ‘open’, ‘0’)

    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 ” at line 3]
    SELECT category_id FROM wp_post2cat WHERE post_id =

    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 ‘ 9)’ at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 9)

    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 ” at line 1]
    SELECT pinged FROM wp_posts WHERE ID =

    I am not sure what this means, or how to fix it, as I am very unfamiliar with MySQL, and certainly haven’t had this problem with my regular blog posts. Can anyone suggest a solution? Apostrophes are sort of necessary from time to time!

    Thanks for help in advance!

  • The topic ‘WP 1.5.2 Post By Email problem’ is closed to new replies.