1

Topic: save_info_final execute failed: Incorrect string value

Hey,
After 24 hours working with my spam domain i saw i got amazing many warnings like this:

Apr  6 20:39:29 poczta amavis[44500]: (44500-04) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x8E\\xAC K...' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.
Apr  6 21:58:58 poczta amavis[44501]: (44501-05) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x9B\\x92' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.
Apr  6 21:59:00 poczta amavis[44501]: (44501-05) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x9B\\x92' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.
Apr  6 21:59:01 poczta amavis[44501]: (44501-05) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x9B\\x92' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.
Apr  6 21:59:03 poczta amavis[44501]: (44501-05) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x9B\\x92' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.
Apr  6 21:59:06 poczta amavis[44501]: (44501-05) (!)WARN save_info_final: sql exec: err=1366, 22007, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x9B\\x92' for column `amavisd`.`msgs`.`subject` at row 1 at (eval 108) line 173.


Any idea what is wrong? i saw someone few years ago report problem like this:
https://forum.iredmail.org/topic11857-i … final.html

but that was long time ago - that`s mean in version 1.1 problem back?

Best Regards
TaKeN

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: save_info_final execute failed: Incorrect string value

hmm, a known issue and will be fixed in next iRedMail release. Here's the DRAFT upgrade tutorial which mentions this fix:
https://docs.iredmail.org/upgrade.iredm … database_1