No announcement yet.

Fetching/Saving mail doesn't work in specific case

  • Filter
  • Time
  • Show
Clear All
new posts

  • Fetching/Saving mail doesn't work in specific case

    I have an issue with fetching mail that has trademark symbol in its body. Import fails at MySQL part with error:
    [2019-12-31 08:58:05] Espo.ERROR: EmailAccount 5bac913bca7e325f8 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xAE Corp...' for column 'body_plain' at row 1 [] []
    Firstly I thought it may be charset for column body_plain but it isn't.
    Also, if I forward that same mail from i.e. web mail client, ESPO is able to save it without errors and trademark symbol doesn't make troubles.

    Any suggestions on how to resolve this?
    I have a solution that may work by using beforeSave hook and get rid of trademark symbol but that's just awkward solution...