Hello Matomo Support Team,
I’m encountering an issue with my WordPress site, which uses latin1 as its charset. I’m unable to create the archive table needed for November 2024, which results in failing cron jobs and an inaccessible dashboard for this month. The archive table isn’t being created, preventing the archiving process from completing.
Unfortunately, changing my charset to utf8mb4 isn’t an option, as it would break serialized data for my theme and Elementor elements. Here is the exact error message I am seeing:
WP DB Error: [1253] COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1' SQL: CREATE TABLE wp_matomo_archive_numeric_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 DOUBLE NULL, PRIMARY KEY(idarchive, name), INDEX index_idsite_dates_period(idsite, date1, date2, period, name(6)), INDEX index_period_archived(period, ts_archived) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=utf8mb4_general_ci => WordPress.php:407; WordPress.php:286; Model.php:338; ArchiveTableCreator.php:40; ArchiveTableCreator.php:31; ArchiveTableCreator.php:20; Model.php:614; Loader.php:383; CronArchive.php:687; CronArchive.php:661; CronArchive.php:624; Cache.php:253; CronArchive.php:623; QueueConsumer.php:149; CronArchive.php:308; CronArchive.php:224; Access.php:567; CronArchive.php:221; ScheduledTasks.php:378; class-wp-hook.php:322; class-wp-hook.php:348; plugin.php:565; wp-cron.php:191;