COLLATION 'utf8mb3_general_ci' is not valid for CHARACTER SET 'utf8mb4' (MySQL)

PHPMaker General Discussion (PHPMaker)
1

Hi
In 2024 i have a dropdown which displays the data fine, but then i try and search i get the following error

/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php(117): An exception occurred while executing a query: COLLATION ‘utf8mb3_general_ci’ is not valid for CHARACTER SET 'utf8mb4’any ideas
ok

2

If your MySQL supports utf8mb4, you should update your database schema to use utf8mb4. If your MySQL does not support utf8mb4, you should upgrade your database. Otherwise, you need to set your MySQL Charset (for SET NAMES) setting to ‘utf8’ (alias of ‘utf8mb3’) for the old MySQL server.