Email problem in log

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tothewine
    Active Community Member
    • Jan 2018
    • 373
    #1

    Email problem in log

    This is on freshly installed 5.9.0. I got a very big log file full of this errors:

    Code:
    [2020-05-21 07:32:05] Espo.ERROR: InboundEmail 5ec62d64308ea00fd (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:32:05] Espo.ERROR: InboundEmail 5ec62d64308ea00fd (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:32:07] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:33:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:34:03] Espo.ERROR: InboundEmail 5ec62d64308ea00fd (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:34:07] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:35:01] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:36:07] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:37:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:38:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA92019 ...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:38:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Prim...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:38:04] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:39:01] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:40:01] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 1998...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:40:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 2019...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:40:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:41:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:42:03] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:42:03] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:42:03] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:43:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:44:01] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 2005...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:44:01] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 2005...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:44:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 2019...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:44:02] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:45:01] Espo.DEBUG: BPM: processPendingFlows [] []
[2020-05-21 07:46:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA92019 ...' for column 'body_plain' at row 1 [] []
[2020-05-21 07:46:03] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366
Incorrect string value: '\xA9 Moto...' for column 'body_plain' at row 1 [] []
    Tags: None
    • yuri
      Member
      • Mar 2014
      • 8440
      #2
      Was it installed over an existing old DB?
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • tothewine
          Active Community Member
          • Jan 2018
          • 373
          #3
          no, it was installed fresh on a empty db. I only copied some parts of custom folder but nothing related to emails.
          I did delete the log, done some rebuild and cache cleaning and now it has stopped. very hard to investigate with big log...
          maybe we could use rotation by file size too
          Last edited by tothewine; 05-21-2020, 11:51 PM.

            Comment

            • yuri
              Member
              • Mar 2014
              • 8440
              #4
              Could you check what collation is set for 'body_plain' column in 'email' table. It can be seen in phpmyadmin.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                Comment

                • tothewine
                  Active Community Member
                  • Jan 2018
                  • 373
                  #5
                  I see utf8mb4_unicode_ci everywhere... i took a screenshot to make as much info available

                  Click image for larger version Name: UNJqpZU.png Views: 0 Size: 792.8 KB ID: 58649

                    Comment

                    • yuri
                      Member
                      • Mar 2014
                      • 8440
                      #6
                      Is it possible that you provide an original of any of these emails?
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                        Comment

                        • yuri
                          Member
                          • Mar 2014
                          • 8440
                          #7
                          I could not reproduce it yet. The email you provided was imported well.
                          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                            Comment

                            • yuri
                              Member
                              • Mar 2014
                              • 8440
                              #8
                              Please check what charset set in data/config.php -> database.
                              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                                Comment

                                • tothewine
                                  Active Community Member
                                  • Jan 2018
                                  • 373
                                  #9
                                  The original text of these email had emojis in the subject line, maybe that was it but I remember having emails with emoji in espo previously.

                                  here is my config.php

                                  Click image for larger version Name: 8fSrkcy.png Views: 0 Size: 16.7 KB ID: 58794
                                  Last edited by tothewine; 05-27-2020, 06:35 PM. Reason: the problem presented itself again

                                    Comment

                                    • tothewine
                                      Active Community Member
                                      • Jan 2018
                                      • 373
                                      #10
                                      I spotted two instances of this again:

                                      [2020-05-27 15:30:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []
                                      [2020-05-27 16:22:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser): [HY000] SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xA9 Subi...' for column 'body_plain' at row 1 [] []

                                      I am trying to add some additional logging so I can print the email text

                                        Comment

                                        • yuri
                                          Member
                                          • Mar 2014
                                          • 8440
                                          #11
                                          This fix might help: https://github.com/espocrm/espocrm/issues/1723
                                          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                                            Comment

                                            • tothewine
                                              #11.1
                                              tothewine commented
                                              05-30-2020, 01:17 AM
                                              Editing a comment
                                              Thanks, I applied the pathc. I'm testing
                                            • tothewine
                                              Active Community Member
                                              • Jan 2018
                                              • 373
                                              #12
                                              For now I did find no new such errors in log so I say it is probbly fixed

                                                Comment

                                                Previous template Next
                                                Working...