Matomo database will be upgraded from version 4.16.0 to the new version 5.0.0.
The following dimensions will be updated: log_conversion.pageviews_before.
If you have a large Matomo database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 5.0.0
# These SQL queries will be executed:
DELETE FROM `bsg_mtm_archive_numeric_2021_01` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_02` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_03` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_04` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_05` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_06` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_07` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_08` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_09` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_10` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_11` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2021_12` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2021_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2021_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_01` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_02` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_03` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_04` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_05` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_06` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_07` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_08` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_09` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_10` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_11` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2022_12` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2022_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2022_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_01` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_02` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `bsg_mtm_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `bsg_mtm_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `bsg_mtm_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `bsg_mtm_user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `bsg_mtm_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
The database upgrade process may take a while, so please be patient.