Hello guys, good day.
im having the below issue on my logs in NC16 after updating the mysql to accept emojis.
Does anybody know how to get this fixed?
its creating a bunch of entries and the log is getting quite big with these same errors over and over.
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT * FROM
oc_comments WHERE (
message COLLATE utf8mb4_general_ci LIKE ?) AND (
object_type = ?) ORDER BY
id DESC LIMIT 100’ with params ["%%", “files”]: SQLSTATE: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’
Thanks for any advice!