WordPress.org

Forums

DB error for some posts by email (2 posts)

  1. transweb
    Member
    Posted 9 years ago #

    Hello:

    I noticed that there are some posts that somehow cause the wp-mail.php script to give weird database errors (using WP v1.5.3, I am posting through email). And for these articles, WordPress just leaves them in the email account without deleting them. The kind of error I get is as follows:

    Author = webmaster@english

    Content-type: text/html, boundary:

    Raw content:

    Made-up language makes for tough translation (The Buffalo News)
    - Elvish for "one ring to rule them all." The men and women of the Buffalo Philharmonic Chorus are used to singing in every language imaginable. After all, they've performed in German, French, Russian and even a dead language or two.

    http://english-to-french-translation.com
    Originally Posted on 11/07/2005 6:48:52 PM
    Content source: http://us.rd.yahoo.com/dailynews/rss/search/French+Translation/SIG=11tifoo6f/*http%3A//www.buffalonews.com/editorial/20050710/1063634.asp

    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 've performed in German, French, Russian and even a dead languag]
    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 ('1', '2005-07-11 18:49:03', '2005-07-11 22:49:03', '2005-07-11 18:49:03', '2005-07-11 22:49:03', 'Made-up language makes for tough translation (The Buffalo News)
    - Elvish for "one ring to rule them all." The men and women of the Buffalo Philharmonic Chorus are used to singing in every language imaginable. After all, they've performed in German, French, Russian and even a dead language or two.

    http://english-to-french-translation.com
    Originally Posted on 11/07/2005 6:48:52 PM
    Content source: http://us.rd.yahoo.com/dailynews/rss/search/French+Translation/SIG=11tifoo6f/*http%3A//www.buffalonews.com/editorial/20050710/1063634.asp ', 'Made-up language makes for tough translation (The Buffalo News)', '', '2', 'publish', 'made-up-language-makes-for-tough-translation-the-buffalo-news', '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 ' 2)' at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 2)

    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 =

    The thing is that it only does that for certain posts, not all of them, but I haven't figured out what's causing this. Thoughts?

    Any help is much appreciated. Thanks in advance.

  2. diane7
    Member
    Posted 9 years ago #

    It seems to be a problem with apostrophes. There's a fix for it that worked for me here: http://wordpress.org/support/topic/38599#post-218146

Topic Closed

This topic has been closed to new replies.

About this Topic