Here is the error I am getting. Can you please tell me how to solve this problem?
PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x8C\x9F B...' for column 'from_address' at row 1: INSERT INTO {basic_webmail_messages} (user_id, message_number, message_subject, from_address, message_date, message_unread, message_answered, attachment_exists) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 34 [:db_insert_placeholder_2] => Govt Job @ Dept of Food & Public... [:db_insert_placeholder_3] => 🌟 BioTecNika Times 🌟 [:db_insert_placeholder_4] => 1543549794 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 ) in _basic_webmail_update_stored_message_list() (line 435 of /var/www/vhosts/sandipchoudhury.com/httpdocs/other-website/teststaff2/sites/all/modules/basic_webmail/basic_webmail.list.inc).
Comments
Comment #2
oadaeh commentedThe problem is that your database does not support MySQL/MariaDB's UTF8 implementation (UTF8MB4) and the text contains multi-byte characters (i.e., emojis). Your database needs to be converted so it supports UTF8MB4.
Make a backup of your database(s) before doing anything.
Here is some documentation on how to update your database: Multi-byte UTF-8 support in Drupal 7
As an alternative, you could try a module like Strip 4-byte UTF8 to remove those multi-byte characters before saving the text.
Comment #3
sandip choudhury commentedThank you. I will try the same and update you.