Announcement

Collapse
No announcement yet.

Email Not Received When Body Contains Specific Emoji

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Email Not Received When Body Contains Specific Emoji

    We are unable to receive emails when the body of the message contains the 'hands pressed together' emoji 🙏

    We have tested with other emojis in the subject and in the email body and these ARE received. Specifically the 'sparkles' emoji ✨ this emoji has no problem.

    What could be causing emails with specific emojis in the body to not be received? Thank you.

    Docker Compose:
    EspoCRM version: 7.4.5
    MYSQL 8
    PHP 8.1.19 (cli) (built: May 13 2023 00:41:40) (NTS)


    [2023-06-15 15:54:06] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1
    [2023-06-15 15:57:14] ERROR: InboundEmail 64737ee2b1ed3d3b2, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x99\x8F\xF0\x9F...' for column 'body_plain' at row 1
    [2023-06-15 16:06:11] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1
    [2023-06-15 16:13:06] ERROR: InboundEmail 646526b1966ac628d, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x99\x8F\x0D\x0A' for column 'body_plain' at row 1
    [2023-06-15 16:15:06] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1​

    Email Table Screenshot attached.



  • #2
    Interest, possible bug here.

    Have you manage to reproduce it on the demo?

    Comment


    • #3
      Solution here: https://forum.espocrm.com/forum/gene...smilie-in-text

      Comment


      • #4
        Looking at timeframe, you might want to update:

        If an encoding is not specified in the config, a wrong encoding is applied. As of v7.4. Emojis may not save. Newly installed versions affected.

        Comment

        Working...
        X