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 creation_timestamp DESC, 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’
i tried updating to 16.0.2 and now im getting the following and cant finisth the update:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_addressbooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’: SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes