blog by mail help

  • i could not get blogging by email to work. by executing wp-mail.php, the mails just get deleted but no posts are posted. after turning debuggin on in wp-mail, i got errors like these and i don’t know them.. any ideas on how you could help me? thanks a lot.
    SQL/DB 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]
    INSERT INTO wp_posts (post_author, post_date, post_content, post_title, post_category) VALUES (1, ‘2004-04-18 01:13:42’, ‘xxx’, ‘xx’, )
    xxx
    SQL/DB 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 * FROM wp_post2cat WHERE post_id = 0 AND category_id =
    Mission complete, message 1 deleted.

Viewing 3 replies - 1 through 3 (of 3 total)

  • I get a similar error. I’ve looked at the wp-mail.php code, and it looks as though the first line of the email message needs to contain the username and password for the user you want to be able to post the email to the blog. I played around with that with the debug turned on, so I could see what was going on. the format of the first line of the email message needs to be –
    username:password
    But, even with wp-mail.php properly getting this, it still is not working correctly. Obvious: some vars are not being passed/set correctly.
    If I knew a little more about WP I might be able to help track the problem down, but I’m quite new to this software.
    Suggestion: could an option by included in admin that would allow us to choose a user, rather than including that info in the email message? For many of us, the user will be the admin account, and it’s probably a security risk to pass the admin password through POP3.
    <rb>

    Modified files and instructions to script the mail import for blog-by-mail can be found in the download section of my website. https://www.corelogik.com

    My solution is not elegant or pretty but you don’t need cron and it works.

    See also Blog by Email in the Codex.

    corelogik: feel free to contribute to the documentation there.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘blog by mail help’ is closed to new replies.