How can I fix the error: DBD::MariaDB::st execute failed: Incorrect string value?

When you check the mail log you see and error like this:

Mar 3 03:46:41 server amavis[1760673]: (1760673-07) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::MariaDB::st execute failed: Incorrect string value: '\\xF0\\x9F\\x98\\x8E\\xF0\\x9F...' for column `dana
mi_warden`.`msgs`.`subject` at row 1 at /usr/share/perl5/vendor_perl/Amavis/Out/SQL/Connection.pm line 175, <GEN124> line 1923.

This is because the mail subject contains an emojis or rare character not supported by the current danami_warden database character set.  Administrators can fix this error by following the instructions from the KB article below to convert their database from utf8mb3 to utf8mb4 which supports the full Unicode standard, including emojis and rare characters (If supported by your database version):

How can I convert the Warden database to use the character set utf8mb4 instead of utf8mb3?

https://www.danami.com/clients/knowledgebase/307/How-can-I-convert-the-Warden-database-to-use-the-character-set-utf8mb4-instead-of-utf8mb3.html

  • utf8mb4, utf8mb3, emojis, rare characters
  • 0 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

How can I fix the error: "milter-reject: END-OF-MESSAGE from..." in the log and found the AV in error (cannot read /etc/clam.d/scan.conf).

Cloudlinux / Imunify360 added their own version of ClamAV to their repo which accidentally...

How can I fix the error: Can't connect to TCP port 10024 on ::1 [Cannot assign requested address] when trying to start Amavis?

When trying to start Amavis you see this in the mail log: Oct 02 03:20:15 condor3648 systemd[1]:...

How can I fix the error: Error [Contentfilter_Settings_Contentfilter]. Message [[QUARANTINEDIR] must be a valid directory?

This error means that Amavis was not installed correctly. Try running the Warden from the command...

How can I fix the error: host 127.0.0.1[127.0.0.1] said: 552 5.3.4 Declared message size (1208029 B) exceeds size limit for recipient?

You can set the message size limit for Amavis under Settings -> Policy Settings -> Misc...

How can I fix the error: milter-reject: DATA 451 4.7.1 Service unavailable - try again later?

Reject log In the Warden reject log you see the message: Service unavailable - try again later....