mysql error in amavis

[Matus UHLAR - fantomas]

On 16.04.19 11:31, Dino Edwards wrote:
>Anyone have any insight on this?

I can only guess it's utf-8 which needs to be enabled.

>From: amavis-users [mailto:amavis-users-bounces+dino.edwards=mydirectmail.net at amavis.org] On Behalf Of Dino Edwards
>Sent: Tuesday, April 9, 2019 2:44 PM
>To: amavis-users at amavis.org
>Subject: mysql error in amavis
>
>I've noticed the following errors on certain messages in mail.log:
>
>amavis[4270]: (04270-02) (!)WARN save_info_final: sql exec: err=1366, HY000, DBD::mysql::st execute failed: Incorrect string value: '\\xF0\\x9F\\x8E\\x89' for column 'subject' at row 1 at (eval 100) line 172
>
>After looking in the msgs table, I found a bunch of messages that have an empty subject as well as other empty fields. These are obviously the messages that amavis was not able to store in the MySQL database because of the above error.
>
>As far as I can tell, these are most likely messages with special characters in the subject line (emojis etc) that amavis is not able to store in the database.
>
>After some research, I have gathered that I most likely need to enable  4-Byte support in MySQL.
>
>I have a couple of questions:
>
>
>1.       Has anyone ran into a similar problem and what have they done to solve it
>
>2.       Would enabling 4-Byte support in MySQL affect amavis in any way?

-- 
Matus UHLAR - fantomas, uhlar at fantomas.sk ; http://www.fantomas.sk/
Warning: I wish NOT to receive e-mail advertising to this address.
Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
The only substitute for good manners is fast reflexes.