Error: Could not update post in the database

  • Resolved bobbyscorpian

    (@bobbyscorpian)


    4 years, 11 months ago

    Postie was working fine for many months but it is been few weeks since it stopped creating posts, I often receive an email with the title “Failed to create post” and the message body contains
    Error: Could not update post in the database.

    Thanks,

    OS: Linux cloud258.hostgator.com 4.19.150-76.ELK.el6.x86_64 #1 SMP Wed Oct 7 01:34:10 CDT 2020 x86_64
    PHP version: 7.1.14
    PHP error_log: error_log
    PHP log_errors: On
    PHP get_temp_dir: /tmp/
    PHP disable_functions: dl
    PHP cURL version: 7.19.7
    PHP Multibyte String support: yes
    MySQL Version: 5.6.41
    MySQL client: mysqli
    Query: SHOW FULL COLUMNS FROM wp_posts
    wp_posts charset: utf8mb4
    WordPress Version: 5.7.2
    WordPress Singlesite
    WP_TEMP_DIR: (none)
    WP_HOME: (none)
    home_url(): https://****removed
    WP_SITEURL: (none)
    site_url(): https://****removed
    WP_DEBUG: Off
    WP_DEBUG_DISPLAY: On
    WP_DEBUG_LOG: Off
    WP_MAX_MEMORY_LIMIT: 256M (default)
    WP_MEMORY_LIMIT: 40M
    imagick version:
    gd version: 7.1.14
    image editor not supported: WP_Image_Editor_Imagick
    image editor supported: WP_Image_Editor_GD
    WP_Image_Editor_GD supports: image/jpeg
    WP_Image_Editor_GD supports: image/png
    WP_Image_Editor_GD supports: image/gif`

    • This topic was modified 4 years, 11 months ago by bobbyscorpian.
    • This topic was modified 4 years, 11 months ago by bobbyscorpian.
Viewing 1 replies (of 1 total)
  • Plugin Author Wayne Allen

    (@wayneallen-1)

    4 years, 11 months ago

    This has come up twice before, one time it was resolved by ensuring the database was utf8, see https://codex.ww.wp.xz.cn/Converting_Database_Character_Sets
    Not likely to be your issue unless you (or your host) recently changed things. Worth verifying. CLick the Test Config button and look for the Encoding sections. Everything should be utf-8 or default.

    The second time we never got a satisfactory answer, but it might have been due to invalid character coming from the email. You might try sending from a different email client to see it that makes a difference.

    In any case this error happens when WordPress detects that the data in the post is not valid for the configured character encoding. Postie does what it can to convert the character set it receives in the email to the expected one, so it is unclear to me why this happens on rare occasions.

    If you want you can install the support addon and send me some logs to investigate. https://postieplugin.com/downloads/support-addon/

Viewing 1 replies (of 1 total)

The topic ‘Error: Could not update post in the database’ is closed to new replies.