SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Inbound Emails Causing Errors

Inbound Emails Causing Errors 5 months 1 week ago #76198

  • sugarsuitedev
  • sugarsuitedev's Avatar
  • Offline
  • New Member
  • Posts: 11
  • Karma: 0
I've recently began using the inbound emails to automatically create cases. It was running smoothly in the beginning but I've been noticing issues when it comes to it reading emails and saving it.

Some errors I've gotten are
"Error inserting into table: emails_text: Query Failed:"
MySQL error 1366: Incorrect string value: '\xE9 ...' for column 'description_html' at row 1

It seems to be stopping the rest of the mail from being processed. Sometimes these emails contain attachments but not always.

Looking at the job queue table I've also starting to get errors like:
Warning [2]: stat(): stat failed for upload/3650013d-4e34-25a7-de61-5c1e22bb5a45 in /srv/www/htdocs/pathtosuite/include/upload_file.php on line 821

Any help would be appreciated. I am running SuiteCRM v. 7.8.0. We do plan on upgrading to 7.10 in a few weeks.
The administrator has disabled public write access.

Inbound Emails Causing Errors 5 months 1 week ago #76300

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10190
  • Thank you received: 1530
  • Karma: 351
Would those emails happen to be the ones including Emoji characters?

See this thread:

There's a fix for it, it involves changing Database collation.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.036 seconds
Powered by Kunena Forum