WordPress.org

Support

Support » How-To and Troubleshooting » Post Via Email

Post Via Email

  • djahughes
    Member

    @djahughes

    I’ve setup post via email using cron and cron-mail plugins but it doesn’t seem to work.

    Running wp-mail.php shows:

    Content-type: text/plain, boundary:

    Raw content:

    One of the reasons I finally decided to use Word Press for my blog is
    that it has mobile blogging via email built in. It took a small
    amount of fiddling but it would now seem to be working fine.

    I'm sending this from my Nokia 6680.
    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 'm sending this from my Nokia 6680.', 'Mobile Posting', '', '1',]
    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-08-02 18:32:59', '2005-08-02 17:32:59', '2005-08-02 18:32:59', '2005-08-02 17:32:59', 'One of the reasons I finally decided to use Word Press for my blog is that it has mobile blogging via email built in. It took a small amount of fiddling but it would now seem to be working fine. I'm sending this from my Nokia 6680.', 'Mobile Posting', '', '1', 'publish', 'mobile-posting', '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 ' 1)' at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

    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 =

    What is wrong?

    Thanks

    David

Viewing 5 replies - 1 through 5 (of 5 total)
  • hostbuzz
    Member

    @hostbuzz

    yeah, i get this error on one of my emails; particularly one that coming from wordpress:

    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 ‘re on the wordpress-announce list now!’, ”, ‘1’, ‘publish’, ‘o]
    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-09-14 21:28:42’, ‘2005-09-14 15:58:42’, ‘2005-09-14 21:28:42’, ‘2005-09-14 15:58:42’, ‘Hello! Just a note to confirm that you have succesfully confirmed your membership on the wordpress-announce notify list, which is run through NotifyList.com If you ever want to unsubscribe to this list, you can go to http://members.notifylist.com/edit/quitlist?list_name=wordpress-announce (you should keep this email so you have that address handy!) Thanks for using NotifyList.com, Andrew help@notifylist.com http://notifylist.com‘, ‘Okay, you’re on the wordpress-announce list now!’, ”, ‘1’, ‘publish’, ‘okay-youre-on-the-wordpress-announce-list-now’, ‘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 ‘ 1)’ at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

    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 =
    Author = newsletter@forbesdigital.com

    Content-type: text/html, boundary:

    Raw content:

    can anybody help?

    regards, ed.

    Greetings – I too am getting the same type of error anytime a post is sent via e-mail that contains apostrophes. Other punctuation seems to be accepted okay. Post the same msg from dashboard and it’s not a problem. Anyone have a clue what needs to be tweaked to fix this???
    Thanks so much
    -wawa

    check my post on SQL insertion methods. This is fixed by sanatizing the string input to the data base by filtering it through the mysql_real_escape_string(). Both the subject and the content must be filtered.

    It turns out that the place where you need to put addslashes() or mysql_real_escape_string() is in functions-post.php near line 49. Specifically, you’ll want to address both the title and contents variables. If you don’t, you will not be able to use SINGLE quotes in either the title or the contents. Double quotes and backslashes are fine, however. I’m not sure why that would be the case.

    Here’s my question… Is anyone able to email their posts with photos inline (or attached)? My photos show up in my posts as binary code. The codex claims that images should, in fact, show up in our posts just fine. I’m so close to getting this email posting down, but doh! Thanks to anyone who can shed some light.

    By the way, here is another thread which specifically addresses the single quotes problem in email posts:

    http://wordpress.org/support/topic/31498

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Post Via Email’ is closed to new replies.