Matomo database will be upgraded from version 4.1.0 to the new version 5.0.1.
The following dimensions will be updated: log_conversion.pageviews_before.
Important notes for large Matomo installations
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:
php /www/htdocs/w018c3ff/gshop.ws/matomo/console core:update
If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 5.0.1
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These console commands will be run:
# These SQL queries will be executed:
UPDATE `matomo_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2022_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2023_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2024_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `matomo_archive_numeric_2024_02` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `matomo_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
ALTER TABLE `matomo_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;
# These console commands will be run:
./console config:set --section="General" --key="login_allow_logme" --value="1"
# These SQL queries will be executed:
ALTER TABLE `matomo_session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run:
./console plugin:activate "CoreVue"
# These SQL queries will be executed:
ALTER TABLE `matomo_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `matomo_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `matomo_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `matomo_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `matomo_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
ALTER TABLE `matomo_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `matomo_user` DROP COLUMN `invite_status`;
ALTER TABLE `matomo_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `matomo_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `matomo_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `matomo_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `matomo_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`;
ALTER TABLE `matomo_user` ADD UNIQUE KEY uniq_email (`email`);
ALTER TABLE `matomo_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT null;
DELETE FROM `matomo_archive_numeric_2018_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2018_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2018_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2018_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_03` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2019_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2019_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2019_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_03` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2020_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2020_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2020_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_03` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2021_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2021_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2021_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_03` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2022_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2022_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2022_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `matomo_archive_numeric_2024_02` WHERE ts_archived is null;
ALTER TABLE `matomo_archive_numeric_2024_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `matomo_archive_numeric_2024_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `matomo_user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `matomo_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
# These console commands will be run:
./console core:calculate-conversion-pages --dates=yesterday,today
# These SQL queries will be executed:
ALTER TABLE `matomo_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);
ALTER TABLE `matomo_log_visit` DROP INDEX `index_idsite_idvisitor`;
# These console commands will be run:
./console plugin:activate "JsTrackerInstallCheck"
# These SQL queries will be executed:
ALTER TABLE `matomo_user_token_auth` CHANGE `post_only` `secure_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `matomo_user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;
ALTER TABLE `matomo_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
Need help upgrading Matomo?
If you need support to upgrade your Matomo, the creators of Matomo are here to help you make the Matomo upgrade a success and provide all instructions, best practises and ongoing support. Contact the Matomo experts to get started upgrading your Matomo safely.
Ready to go?
The database upgrade process may take a while, so please be patient.
File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error. |
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <-- Directory to delete: libs/bower_components Directory to delete: node_modules/angular Directory to delete: node_modules/jquery.browser Directory to delete: node_modules/jquery/external Directory to delete: node_modules/materialize-css Directory to delete: node_modules/ng-dialog To delete all these directories at once, you can run this command: rm -Rf /www/htdocs/w018c3ff/gshop.ws/matomo/libs/bower_components /www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/angular /www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery.browser /www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery/external /www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/materialize-css /www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/ng-dialog |
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: index.htm File to delete: js/piwik-min.js File to delete: js/piwik.js.orig File to delete: misc/composer/build-xhprof.sh File to delete: misc/composer/clean-xhprof.sh File to delete: misc/gpl-3.0.txt File to delete: misc/internal-docs/content-tracking.md File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/api_internal_call.php File to delete: misc/others/api_rest_call.php File to delete: misc/others/download-count.txt File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/stress.sh File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: misc/others/widget_example_lastvisits.html File to delete: node_modules/jquery.dotdotdot/src/jquery.dotdotdot.min.js File to delete: node_modules/mousetrap/mousetrap.sublime-project File to delete: package-lock.json File to delete: node_modules/chroma-js/.npmignore File to delete: node_modules/iframe-resizer/.eslintrc File to delete: node_modules/iframe-resizer/.ncurc.json File to delete: node_modules/iframe-resizer/.prettierrc File to delete: node_modules/jquery.dotdotdot/.npmignore File to delete: node_modules/jquery.scrollto/.jscsrc File to delete: node_modules/jquery.scrollto/.npmignore File to delete: node_modules/qrcodejs2/.npmignore File to delete: vendor/davaxi/sparkline/.codeclimate.yml File to delete: vendor/matomo/device-detector/.yamllint File to delete: vendor/php-di/php-di/.gitstats.yml File to delete: vendor/php-di/php-di/.phpstorm.meta.php File to delete: vendor/twig/twig/.php_cs.dist To delete all these files at once, you can run this command: rm "/www/htdocs/w018c3ff/gshop.ws/matomo/bower.json" "/www/htdocs/w018c3ff/gshop.ws/matomo/composer.json" "/www/htdocs/w018c3ff/gshop.ws/matomo/composer.lock" "/www/htdocs/w018c3ff/gshop.ws/matomo/config/environment/test.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/config/environment/ui-test.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/index.htm" "/www/htdocs/w018c3ff/gshop.ws/matomo/js/piwik-min.js" "/www/htdocs/w018c3ff/gshop.ws/matomo/js/piwik.js.orig" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/composer/build-xhprof.sh" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/composer/clean-xhprof.sh" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/gpl-3.0.txt" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/internal-docs/content-tracking.md" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/ExamplePiwikTracker.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/api_internal_call.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/api_rest_call.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/download-count.txt" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/iframeWidget_localhost.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/stress.sh" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/uninstall-delete-piwik-directory.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/misc/others/widget_example_lastvisits.html" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery.dotdotdot/src/jquery.dotdotdot.min.js" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/mousetrap/mousetrap.sublime-project" "/www/htdocs/w018c3ff/gshop.ws/matomo/package-lock.json" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/chroma-js/.npmignore" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/iframe-resizer/.eslintrc" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/iframe-resizer/.ncurc.json" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/iframe-resizer/.prettierrc" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery.dotdotdot/.npmignore" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery.scrollto/.jscsrc" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/jquery.scrollto/.npmignore" "/www/htdocs/w018c3ff/gshop.ws/matomo/node_modules/qrcodejs2/.npmignore" "/www/htdocs/w018c3ff/gshop.ws/matomo/vendor/davaxi/sparkline/.codeclimate.yml" "/www/htdocs/w018c3ff/gshop.ws/matomo/vendor/matomo/device-detector/.yamllint" "/www/htdocs/w018c3ff/gshop.ws/matomo/vendor/php-di/php-di/.gitstats.yml" "/www/htdocs/w018c3ff/gshop.ws/matomo/vendor/php-di/php-di/.phpstorm.meta.php" "/www/htdocs/w018c3ff/gshop.ws/matomo/vendor/twig/twig/.php_cs.dist" |