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.