We’re getting the above error in the history of a ticket, in place of where an incoming email ought to be shown. This is a significant problem because RT accepts the email from the MTA, but fails to insert it, and the content is lost.
The message in the logs looks like:
[88469] [Tue Apr 14 23:57:00 2020] [warning]: DBD::mysql::st execute failed: Incorrect string value: '\xF0\x9F\x9B\xAB\xF0\x9F...' for column `rtdb`.`Attachments`.`Headers` at row 1 at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[88469] [Tue Apr 14 23:57:00 2020] [warning]: RT::Handle=HASH(0x55886fbd5fc0) couldn't execute the query 'INSERT INTO Attachments (Created, Creator, Parent, TransactionId, MessageId, Subject, ContentType, Headers) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
Email that triggers this simply has emojis in the CC header (e.g. “🛫😎🛬 <b....@gmail.com>
”)