La base de données de Matomo sera mise à jour depuis la version 4.11.0 vers la version 5.0.2.
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/nosenzorps/www/piwik/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.0.2
# Ces requêtes SQL seront exécutées :
ALTER TABLE `piwik_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`;
ALTER TABLE `piwik_user` ADD UNIQUE KEY uniq_email (`email`);
ALTER TABLE `piwik_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT null;
DELETE FROM `piwik_archive_numeric_2016_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2016_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2016_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2016_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2017_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2017_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2017_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2018_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2018_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2018_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2019_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2019_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2019_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2020_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2020_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2020_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2021_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2021_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2021_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2022_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2022_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2022_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `piwik_user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `piwik_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 `piwik_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);
ALTER TABLE `piwik_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 `piwik_user_token_auth` CHANGE `post_only` `secure_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `piwik_user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;
ALTER TABLE `piwik_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
| 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. |
| Des fichiers inattendus ont été trouvés dans votre installation de Matomo. --> Veuillez supprimer ces fichiers pour éviter d'avoir des erreurs. <-- Fichier à supprimer : config/environment/test.php Fichier à supprimer : config/environment/ui-test.php Fichier à supprimer : misc/others/ExamplePiwikTracker.php Fichier à supprimer : misc/others/uninstall-delete-piwik-directory.php Fichier à supprimer : package-lock.json Fichier à supprimer : phpcs.xml Pour supprimer tous ces fichiers d'un coup, vous pouvez exécuter cette commande : rm "/home/nosenzorps/www/piwik/config/environment/test.php" "/home/nosenzorps/www/piwik/config/environment/ui-test.php" "/home/nosenzorps/www/piwik/misc/others/ExamplePiwikTracker.php" "/home/nosenzorps/www/piwik/misc/others/uninstall-delete-piwik-directory.php" "/home/nosenzorps/www/piwik/package-lock.json" "/home/nosenzorps/www/piwik/phpcs.xml" |