[500 Error] Uncaught PHP Exception mysqli_sql_exception: "COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8mb3'"

💬 General Discussion
12

well I’m not a developer but sysadmin, eventually I can set that up but it’ll take some time. debugging apps is not something I do in my day to day :slight_smile:
I use Sublime Text for what’s needed.

By the way, after some looking around I found this - well, re-found actually cause I had been over this somewhen.
I am starting to imagine the reboot didn’t actually affect the web server where SuiteCRM resides, but a setting that had already been changed long ago and now apparently reverted to the original value (from MariaDB 10.6 onwards).

It’s a variable called old_mode

mysql> show variables like 'old_mode';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| old_mode      | UTF8_IS_UTF8MB3 |
+---------------+-----------------+
1 row in set (0.03 sec)

mysql>

If I remember correctly this setting has to be empty (value) in order for it to go utf8mb4.

Also checking mariadb docs

UTF8_IS_UTF8MB3

From MariaDB 10.6.1, the main name of the previous 3 byte utf character set has been changed to utf8mb3. If set, the default, utf8 is an alias for utf8mb3. If not set, utf8 would be an alias for utf8mb4.

So anyway I’m going to enforce this on the nodes mariadb server settings - so I can powercycle the nodes and don’t get back to this again - and see if it solves (I’m pretty sure it will), I’ll get back with some feedback in a few moments.

2 Likes