"pymysql.err.InternalError: (1366, “Incorrect string value: ‘\xE1tico,…’ for column _1bd3e0294da19198 . tabUnhandled Email . raw at row 1”)
An email you received is 4-byte encoded while your database is possibly set to accept a maximum 3-byte encoding? So you need to set your database to accept utf8mb4.
Check these:
https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html
This other thread should help too
Hello!
I have a weird email error, could you help me out?
Should I open a github issue?
I have this email problem:
pull_from_email_account
Error
{'e': InternalError(1366, "Incorrect string value: '\\xE9b \\xDCl\\xF5...' for column `_1bd3e0294da19198`.`tabUnhandled Email`.`raw` at row 1"), 'method_name': 'pull_from_email_account', 'log': <function log at 0x7f1ba1523e18>, 'retry': 0, 'is_async': True, 'user': 'Administrator', 'kwargs': {'email_account': 'Replies'}, 'job_name': 'pull_from_ema…
Thank you , make my today happy.
Finally updated my system to UBUNTU 18.04,
tough it helps.
Nothing changed.
Dig it to charset in mysql database.
I had to allow in mariadb.cnf the # out lines and let set the charset to
[mysqld]
charser-set-server=utf8mb4 (it was utf8)
collation-server=utf8mb4_unicode_ci (it was general_ci)
Now it works!
No more error in list.
Please close this subject.
1 Like