Utf8mb4_general_ci is not valid for CHARACTER SET utf8mb3

Support & Bugs
1

Good morning everyone.
I have a Wordpress installation where I use the Matomo plugin to track visits.
I got this error:
WP DB Error: [1253] COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8mb3’ SQL: CREATE TABLE firing_matomo_archive_blob_2024_11 ( idarchive INTEGER UNSIGNED NOT NULL, name VARCHAR(190) NOT NULL, idsite INTEGER UNSIGNED NULL, date1 DATE NULL, date2 DATE NULL, period TINYINT UNSIGNED NULL, ts_archived DATETIME NULL, value MEDIUMBLOB NULL, PRIMARY KEY(idarchive, name), INDEX index_period_archived(period, ts_archived) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb4_general_ci

What does this mean and what can I do?
Thanks in advance to anyone who can help me out
Alessandro

2

immagine
immagine668×558 5.19 KB

3

Could it be because in the wp-config the database charset value ‘utf8mb3’ is indicated?

4

I wonder maybe your WP install is older or DB charset utf8mb3 is not the default one,

If you check Wordpress official documentation, the charset is utf8mb4:

The default setting for DB_CHARSET is utf8mb4

Proceed with caution from here on changing it, I’d 100% make a backup, setup a staging environment, test it there then implement it live: