• Resolved toarun4u1

    (@toarun4u1)


    hi,

    recently brought new hosting and domain but Postie works only few times (2 out of 10 trigger).
    support plugin enabled and sent mail as well.

    database collation – utf8_unicode_ci

    tried altering all table, column to utf8mb4_unicode_ci, utf8_general_ci but no luck

    getting below error:

    PostToDB Error: Could not update post in the database.
    PostToDB last_error: WordPress database error: Processing the value for the following field failed: post_title. The supplied value may be too long or contains invalid data.
    PostToDB last_query: SELECT post_id, meta_key, meta_value FROM 0b1_postmeta WHERE post_id IN (195) ORDER BY meta_id ASC

    config –

    PHP version: 8.0.25
    PHP error_log: error_log
    PHP log_errors: On
    PHP get_temp_dir: /tmp/
    PHP disable_functions: 
    PHP cURL version: 7.86.0
    PHP Multibyte String support: yes
    MySQL Version: 5.7.23
    MySQL client: mysqli
    0b1_posts charset: utf8
    WordPress Version: 6.1
    WordPress Singlesite
    WP_TEMP_DIR: (none)
    WP_HOME: (none)
    home_url(): https://thaiposts.net
    WP_SITEURL: (none)
    site_url(): https://thaiposts.net
    WP_DEBUG: Off
    WP_DEBUG_DISPLAY: On
    WP_DEBUG_LOG: Off
    WP_MAX_MEMORY_LIMIT: 256M (default)
    WP_MEMORY_LIMIT: 40M
    imagick version: 3.5.0
    gd version: 8.0.25
    image editor supported: WP_Image_Editor_Imagick
    WP_Image_Editor_Imagick supports: image/jpeg
    WP_Image_Editor_Imagick supports: image/png
    WP_Image_Editor_Imagick supports: image/gif
    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
    Registered image sizes
    image memory limit: 512M
    DISABLE_WP_CRON: Off
    ALTERNATE_WP_CRON: Off
    WP_CRON_LOCK_TIMEOUT: 120
    iconv: present
    Active plugins
         bluehost-wordpress-plugin/bluehost-wordpress-plugin.php => 2.12.10
         google-site-kit/google-site-kit.php => 1.86.0
         jetpack/jetpack.php => 11.5.1
         my-database-admin/database-my-admin.php => 1.1.24
         postie-addon-support/postie-addon-support.php => 1.0.14
         postie/postie.php => 1.9.62
         qqworld-auto-save-images/qqworld-auto-save-images.php => 1.9.8
         quick-adsense/quick-adsense.php => 2.8.7
         schema-and-structured-data-for-wp/structured-data-for-wp.php => 1.9.103
         top-10/top-10.php => 3.2.2
         wp-file-manager/file_folder_manager.php => 7.1.6
    Postie is in /home4/thaipos1/public_html/wp-content/plugins/postie/
    Postie Version: 1.9.62
    POSTIE_DEBUG: Off
    Clock
    This shows what time it would be if you posted right now
    
    Wordpress timezone:  (7)
    Current time: 2022-11-07 20:33:35
    Current time (gmt): 2022-11-07 13:33:35
    Postie time correction: 0
    Post time: 2022-11-07 20:33:35
    Encoding
    default_charset: UTF-8
    DB_CHARSET: utf8
    DB_COLLATE: database default
    WordPress encoding: UTF-8

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Wayne Allen

    (@wayneallen-1)

    This happens very rarely, so much so that it is hard to diagnose.

    What I do know is that somehow WordPress/PHP is deciding that the text encoding is somehow incorrect.

    Have you verified that the individual fields in the posts table have a UTF encoding? My working copy is using utf8mb4_unicode_ci.

Viewing 1 replies (of 1 total)
  • The topic ‘PostToDB Error: Could not update post in the database.’ is closed to new replies.