Matomo › Mise à jour

La base de données de Matomo sera mise à jour depuis la version 4.13.3 vers la version 5.2.1.

Les plugins suivants seront mis à jour : TagManager.

Les dimensions suivantes vont être mises à jour : log_conversion.pageviews_before.

Note importante pour les installations Matomo de taille importante

Si votre base de données Matomo est trop volumineuse, la mise à jour pourra être trop longue pour l'effectuer depuis le navigateur. Dans ce cas exécutez la mise à jour depuis la ligne de commande :

php /home/kafebnub/analytics.kafein-studio.fr/console core:update

Si vous gérez un serveur Matomo à haut traffic, nous recommandons de désactiver momentanément le suivi des visiteurs et de mettre l'interface utilisateur de Matomo en mode de maintenance.

PVI : ce sont les requêtes SQL et les commandes console qui seront exécutées pour mettre à jour votre base de données vers Matomo 5.2.1

› Cliquez ici pour afficher et copier la liste des requêtes SQL et des commandes de console qui seront exécutées

# Ces requêtes SQL seront exécutées : 
DELETE FROM `mt_archive_numeric_2022_01` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_02` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_03` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_04` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_05` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_06` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_07` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_08` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_09` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_10` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_11` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2022_12` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2022_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2022_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_01` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_02` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_02` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_03` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_04` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_05` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_06` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_07` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_08` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_09` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_10` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_11` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2024_12` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2024_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2024_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2025_01` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2025_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2025_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `mt_archive_numeric_2025_02` WHERE ts_archived is null;
ALTER TABLE `mt_archive_numeric_2025_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `mt_archive_numeric_2025_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `mt_user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `mt_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;

# Ces commandes de la console seront exécutées : 
./console core:calculate-conversion-pages --dates=yesterday,today

# Ces requêtes SQL seront exécutées : 
ALTER TABLE `mt_log_visit` RENAME INDEX `index_idsite_idvisitor` TO `index_idsite_idvisitor_time`;
ALTER TABLE `mt_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);
ALTER TABLE `mt_log_visit` DROP INDEX `index_idsite_idvisitor`;

# Ces commandes de la console seront exécutées : 
./console plugin:activate "JsTrackerInstallCheck"

# Ces requêtes SQL seront exécutées : 
ALTER TABLE `mt_user_token_auth` CHANGE `post_only` `secure_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `mt_user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;

# Ces commandes de la console seront exécutées : 
./console config:set --section="database" --key="collation" --value="utf8mb4_general_ci"
./console core:invalidate-report-data --dates=2025-05-01,today --plugin=Actions.Actions_hits

# Ces requêtes SQL seront exécutées : 
ALTER TABLE `mt_tagmanager_container` ADD COLUMN `ignoreGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `description`;
ALTER TABLE `mt_tagmanager_container` ADD COLUMN `isTagFireLimitAllowedInPreviewMode` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ignoreGtmDataLayer`;
ALTER TABLE `mt_tagmanager_container_version` CHANGE `name` `name` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `mt_tagmanager_container` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_tag` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_trigger` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_variable` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_container` ADD COLUMN `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ignoreGtmDataLayer`;
ALTER TABLE `mt_tagmanager_container` CHANGE `activelySyncGtmDataLayer` `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE `mt_tagmanager_container_version` CHANGE `name` `name` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `mt_tagmanager_container` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_tag` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_trigger` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_tagmanager_variable` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `mt_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;

Besoin d'aide pour mettre à jour Matomo ?

Si vous avez besoin de support pour mettre à jour Matomo, les créateurs de Matomo sont là pour vous aider à faire de votre mise à jour un succès et vous fournir toutes les instructions, bonnes pratiques et du support. Contacter les experts Matomo pour démarrer en effectuer une mise à jour de Matomo en toute sécurité.

Prêt à démarrer ?

Le procédé de mise à jour peut être long, veuillez patienter.

Le contrôle d'intégrité a échoué et a rapporté des erreurs. Vous devriez corriger ces problèmes puis rafraîchir cette page jusqu'à ce qu'il n'y ait plus d'erreur. Détails

Mise à niveau de la base de données requise

Note importante pour les installations Matomo de taille importante

Besoin d'aide pour mettre à jour Matomo ?

Prêt à démarrer ?