Collation and charset set suddenly don't match

Using Concrete / Help
1

I’m using Concrete 8.5.4 and everything has worked beautifully for a very long time. Yesterday while trying to add a form to a new page, It failed with this error. I have no idea how to fix this. Please help:

An exception occurred while executing ‘CREATE TABLE TestExpressSearchIndexAttributes (exEntryID INT NOT NULL, PRIMARY KEY(exEntryID)) DEFAULT CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB’:

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_unicode_ci’ is not valid for CHARACTER SET ‘utf8’

database.php has the character set as utf8mb4

2

Ok, I fixed it. it was the database.php file and for some reason it was in 2 places. But here is the weird thing. It’s been like that for 2 years. Never been a problem before. MariaDB must have done something to make it strict.

2 Likes
3

@baxterdmutt strange, glad you got it sorted though!