WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Post by email SQL error (5 posts)

  1. tomhanna
    Member
    Posted 9 years ago #

    The post by email feature deletes the emails properly and shows the contents of the email (when I run wp-mail.php), but that's all it does. It doesn't post anything. It returns these two 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 'AND category_id = 1' at line 1]
    SELECT * FROM opp_post2cat WHERE post_id = AND category_id = 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 ' 1)' at line 4]
    INSERT INTO opp_post2cat (post_id, category_id) VALUES (, 1)

    In wp-mail.php line 1 is - "require(dirname(__FILE__) . '/wp-config.php');"
    and Line 4 is either a blank line or "$time_difference = get_settings('gmt_offset') * 3600;" which don't really appear relevant. Obviously it's a 'line' from some other file or I'm missing something. I admittedly know just enough to be dangerous, but I can't find where the file sets a value for "post_id" and it appears to be trying to post a blank entry to the database for post_id.

    Possibly relevant info:
    January 1 nightly build and January 16th build
    Operating system Linux
    Kernel version 2.4.21-27.0.1.ELsmp
    Apache version 1.3.33 (Unix)
    PHP version 4.3.10
    MySQL version 4.0.22-standard-log
    cPanel Build 9.9.9-CURRENT 120
    cPanel Pro 1.0 (RC2)

  2. blueorder
    Member
    Posted 9 years ago #

    I'm getting the same error. Looks like post_ID doesn't have a value...

  3. jaya
    Member
    Posted 9 years ago #

  4. tomhanna
    Member
    Posted 9 years ago #

    Thanks, jaya.

    It doesn't look like the same problem (time zone is same for my server and my email) and it's not getting them to the point where I can edit them.

  5. blueorder
    Member
    Posted 9 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.