PostToDB Error: Could not update post in the database.

  • Resolved toarun4u1

    (@toarun4u1)


    2 years, 4 months ago

    recently created new site and trying postie to send post by email but getting below error in postie

    PS – added support plugin to site.

    Query: SELECT post_name FROM wp_gt29t6_posts WHERE post_name = 'aaaaaaaeaaaaaaaaa10-aau-aeaaaaaayaaaaauaaaoeaaaaa-aaaa-aaaaacaaa-aaaaeaa-aaaaaa-aaaaaaayacaoe' AND post_type = 'post' AND ID != 87 LIMIT 1
pre_post_update
PostToDB Error: Could not update post in the database.
Array
(
    [0] => Could not update post in the database.
)
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_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_name FROM wp_gt29t6_posts WHERE post_name = 'aaaaaaaeaaaaaaaaa10-aau-aeaaaaaayaaaaauaaaoeaaaaa-aaaa-aaaaacaaa-aaaaeaa-aaaaaa-aaaaaaayacaoe' AND post_type = 'post' AND ID != 87 LIMIT 1
Arra

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter toarun4u1

    (@toarun4u1)

    i tried multiple hosting on dreamhosting but no luck so i canceled hosting.

    Thread Starter toarun4u1

    (@toarun4u1)

    hi,

    brought another hosting and domain but still same error:
    website – https://thaiposts.net/

    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_name FROM 0b1_posts WHERE post_name = ‘aaaz-aeaaaaaaaaaa-ft-aayayaa-aaa-a-ac-a-a-aaaaaa-4-72-a-aaaaac’ AND post_type = ‘post’ AND ID != 7 LIMIT 1

    debug –

    Postie Configuration Test

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: utf8mb4
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/postie.php => 1.9.62
     quick-adsense/quick-adsense.php => 2.8.7
     wordpress-seo/wp-seo.php => 19.9
     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 06:06:32
Current time (gmt): 2022-11-06 23:06:32
Postie time correction: 0
Post time: 2022-11-07 06:06:32
Encoding
default_charset: UTF-8
DB_CHARSET: utf8
DB_COLLATE: database default
WordPress encoding: UTF-8
    • This reply was modified 2 years, 3 months ago by toarun4u1.
    Thread Starter toarun4u1

    (@toarun4u1)

    able to resolve it by converting db then tables then columns one by one to UTF8

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