PostToDB Error: Could not update post in the database

To update when we are using following header :

$headers = $headers.”MIME-Version: 1.0″ . “\r\n”;
$headers = $headers.”Content-type:text/html;charset=UTF-8″. “\r\n”;

we get this error: PostToDB Error: Could not update post in the database

If we do not use the header above then post gets created but all the UTF-8 characters are messed up. Whole post is gibberish.

Please click the Test Config button and post the results here.

Here it is :

Postie Configuration Test
OS: Linux cloud111.hostgator.com 3.10.0-693.17.1.2.ELK.el6.x86_64 #1 SMP Thu Feb 8 23:35:45 MST 2018 x86_64
PHP Version: 7.1.4
PHP error_log: error_log
PHP log_errors: On
PHP get_temp_dir: /tmp/
PHP cURL version: 7.19.7
MySQL Version: 5.6.32
WordPress Version: 4.9.7
WordPress Singlesite
WP_TEMP_DIR: (none)
WP_HOME: (none)
home_url(): https://www.buyrudraksha.com/rashifal
WP_SITEURL: (none)
site_url(): https://www.buyrudraksha.com/rashifal
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.4
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
Registered image sizes
image memory limit: 756M
DISABLE_WP_CRON: Off
ALTERNATE_WP_CRON: Off
WP_CRON_LOCK_TIMEOUT: 60
iconv: present
Active plugins
Postie is in /home4/a0j6b7q5/buyrudraksha/new-2/rashifal/wp-content/plugins/postie/
Postie Version: 1.9.24
POSTIE_DEBUG: Off
Clock

This shows what time it would be if you posted right now

Wordpress timezone: (5.5)
Current time: 2018-08-01 20:44:10
Current time (gmt): 2018-08-01 15:14:10
Postie time correction: 5.5
Post time: 2018-08-01 20:44:10
Encoding

default_charset: UTF-8
DB_CHARSET: utf8mb4
DB_COLLATE: database default
WordPress encoding: UTF-8
Connect to Mail Host

Postie connection: sockets
Postie protocol: imap-ssl
Postie server: imap.gmail.com
Postie port: 993
Successful IMAP-SSL connection on port 993
# of waiting messages: 0

Can you check your database to see what charset the tables are defined with? Your WordPress is set to send utf8mb4 encoded characters to the database. If the the database isn’t defined this way that can cause the errors you are seeing.

WordPress recommends the utf8 charset. See https://codex.www.ads-software.com/Converting_Database_Character_Sets

• This reply was modified 6 years, 3 months ago by Wayne Allen.

Hi,

Thank you for quick response.

Earlier it was not UTF-8. However I had converted it to utf8mb4 and tested. Still getting UTF-8 issue.

All text appears properly in database and the email that is generated. Issue happens only when postie is importing and creating the post in wordpress.

Any chance you could convert your DB back to utf8? Might be the simplest solution.

Hi,

Sorry I was away.

Should i convert it UTF8_GENERAL_CI and test?

I would suggest following the steps documented here: https://codex.www.ads-software.com/Converting_Database_Character_Sets