Event Logger Plugin Sometimes generate error log. How to I solve it? Incorrect string value: '\xE0\xA6...\x09...'?

Question

Event Logger Plugin Sometimes generate  error log. How to I solve it

PHP Question2Answer MySQL query error 1366: Incorrect string value: '\xE0\xA6...\x09...' for column 'params' at row 1 - Query: INSERT INTO 

Answer 1

To support all character types the qa_eventlog table (params column) must be of character type utf8mb4. You can see more here: https://www.question2answer.org/qa/28769/why-isnt-emoji-supported-in-q2a

Even after doing this change, if this issue is there you might be having some plugin which is not handling utf8mb4 - onsitenotification plugin has this issue which updates the qa_eventlog table.