Matomo database will be upgraded from version 4.8.0 to the new version 5.0.2.
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 /kunden/340940_23730/stadtneustadt_de/piwik/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.2
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These SQL queries will be executed:
ALTER TABLE `piwik_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `piwik_user` DROP COLUMN `invite_status`;
ALTER TABLE `piwik_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
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_2008_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2008_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2008_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2013_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2013_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2013_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2014_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2014_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2014_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2015_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2015_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2015_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
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_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;
# These console commands will be run:
./console core:calculate-conversion-pages --dates=yesterday,today
# These SQL queries will be executed:
ALTER TABLE `piwik_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time`);
ALTER TABLE `piwik_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 `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;
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.
Details
| 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: themes Directory to delete: vendor/doctrine To delete all these directories at once, you can run this command: rm -Rf /kunden/340940_23730/stadtneustadt_de/piwik/themes /kunden/340940_23730/stadtneustadt_de/piwik/vendor/doctrine |
| Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: PULL_REQUEST_TEMPLATE File to delete: README File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/config.ini.sample.php File to delete: config/environment/cli.php File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: config/global.ini.auto-backup-before-update.php File to delete: js/README File to delete: lang/am.php File to delete: lang/ar.php File to delete: lang/be.php File to delete: lang/bg.php File to delete: lang/ca.php File to delete: lang/cs.php File to delete: lang/cy.php File to delete: lang/da.php File to delete: lang/de.php File to delete: lang/el.php File to delete: lang/en.php File to delete: lang/es.php File to delete: lang/et.php File to delete: lang/eu.php File to delete: lang/fa.php File to delete: lang/fi.php File to delete: lang/fr.php File to delete: lang/gl.php File to delete: lang/he.php File to delete: lang/hr.php File to delete: lang/hu.php File to delete: lang/id.php File to delete: lang/is.php File to delete: lang/it.php File to delete: lang/ja.php File to delete: lang/ka.php File to delete: lang/ko.php File to delete: lang/lt.php File to delete: lang/lv.php File to delete: lang/nb.php File to delete: lang/nl.php File to delete: lang/nn.php File to delete: lang/pl.php File to delete: lang/pt-br.php File to delete: lang/pt.php File to delete: lang/ro.php File to delete: lang/ru.php File to delete: lang/sk.php File to delete: lang/sl.php File to delete: lang/sq.php File to delete: lang/sr.php File to delete: lang/sv.php File to delete: lang/te.php File to delete: lang/th.php File to delete: lang/tr.php File to delete: lang/uk.php File to delete: lang/zh-cn.php File to delete: lang/zh-tw.php File to delete: misc/ExamplePiwikTracker.php File to delete: misc/How to install Piwik.html File to delete: misc/api_internal_call.php File to delete: misc/api_rest_call.php File to delete: misc/cron/archive.windows.ps1 File to delete: misc/crossdomain.xml File to delete: misc/download-count.txt File to delete: misc/generateDoc.bat File to delete: misc/generateDoc.sh File to delete: misc/gpl-3.0.txt File to delete: misc/iframeWidget.htm File to delete: misc/iframeWidget_localhost.php File to delete: misc/internal-docs/content-tracking.md File to delete: misc/log-analytics/README 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/cli-script-bootstrap.php File to delete: misc/others/crossdomain.xml File to delete: misc/others/db-schema-README File to delete: misc/others/db-schema.png File to delete: misc/others/db-schema.xml File to delete: misc/others/diagram_general_request.jpg File to delete: misc/others/diagram_general_request.vsd File to delete: misc/others/download-count.txt File to delete: misc/others/generateDoc.bat File to delete: misc/others/generateDoc.sh File to delete: misc/others/iframeWidget.htm File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/phpdoc-config.ini File to delete: misc/others/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/others/phpstorm-codestyles/README.md File to delete: misc/others/stress.sh File to delete: misc/others/svn-props-to-set-new-files.svnprops File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: misc/others/widget_example_lastvisits.html File to delete: misc/phpdoc-config.ini File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: misc/proxy-hide-piwik-url/piwik.php File to delete: misc/stress.sh File to delete: misc/svn-props-to-set-new-files.svnprops File to delete: misc/test_cookies_GenerateHundredsWebsitesAndVisits.php File to delete: misc/test_generateLotsVisitsWebsites.php File to delete: misc/tracker_simpleImageTracker.php File to delete: misc/translationTool.sh File to delete: misc/uninstall-delete-piwik-directory.php File to delete: misc/widget_example_lastvisits.html File to delete: piwik-autoarchive.sh File to delete: piwik.min.js File to delete: tests/README.txt File to delete: misc/log-analytics/.git To delete all these files at once, you can run this command: rm "/kunden/340940_23730/stadtneustadt_de/piwik/PULL_REQUEST_TEMPLATE" "/kunden/340940_23730/stadtneustadt_de/piwik/README" "/kunden/340940_23730/stadtneustadt_de/piwik/bower.json" "/kunden/340940_23730/stadtneustadt_de/piwik/composer.json" "/kunden/340940_23730/stadtneustadt_de/piwik/composer.lock" "/kunden/340940_23730/stadtneustadt_de/piwik/config/config.ini.sample.php" "/kunden/340940_23730/stadtneustadt_de/piwik/config/environment/cli.php" "/kunden/340940_23730/stadtneustadt_de/piwik/config/environment/test.php" "/kunden/340940_23730/stadtneustadt_de/piwik/config/environment/ui-test.php" "/kunden/340940_23730/stadtneustadt_de/piwik/config/global.ini.auto-backup-before-update.php" "/kunden/340940_23730/stadtneustadt_de/piwik/js/README" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/am.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ar.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/be.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/bg.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ca.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/cs.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/cy.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/da.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/de.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/el.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/en.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/es.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/et.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/eu.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/fa.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/fi.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/fr.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/gl.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/he.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/hr.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/hu.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/id.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/is.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/it.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ja.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ka.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ko.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/lt.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/lv.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/nb.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/nl.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/nn.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/pl.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/pt-br.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/pt.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ro.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/ru.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/sk.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/sl.php" rm "/kunden/340940_23730/stadtneustadt_de/piwik/lang/sq.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/sr.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/sv.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/te.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/th.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/tr.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/uk.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/zh-cn.php" "/kunden/340940_23730/stadtneustadt_de/piwik/lang/zh-tw.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/ExamplePiwikTracker.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/How to install Piwik.html" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/api_internal_call.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/api_rest_call.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/cron/archive.windows.ps1" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/crossdomain.xml" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/download-count.txt" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/generateDoc.bat" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/generateDoc.sh" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/gpl-3.0.txt" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/iframeWidget.htm" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/iframeWidget_localhost.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/internal-docs/content-tracking.md" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/log-analytics/README" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/ExamplePiwikTracker.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/api_internal_call.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/api_rest_call.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/cli-script-bootstrap.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/crossdomain.xml" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/db-schema-README" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/db-schema.png" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/db-schema.xml" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/diagram_general_request.jpg" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/diagram_general_request.vsd" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/download-count.txt" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/generateDoc.bat" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/generateDoc.sh" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/iframeWidget.htm" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/iframeWidget_localhost.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/phpdoc-config.ini" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/phpstorm-codestyles/Piwik_codestyle.xml" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/phpstorm-codestyles/README.md" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/stress.sh" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/svn-props-to-set-new-files.svnprops" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/uninstall-delete-piwik-directory.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/others/widget_example_lastvisits.html" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/phpdoc-config.ini" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/phpstorm-codestyles/README.md" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/proxy-hide-piwik-url/piwik.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/stress.sh" rm "/kunden/340940_23730/stadtneustadt_de/piwik/misc/svn-props-to-set-new-files.svnprops" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/test_cookies_GenerateHundredsWebsitesAndVisits.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/test_generateLotsVisitsWebsites.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/tracker_simpleImageTracker.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/translationTool.sh" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/uninstall-delete-piwik-directory.php" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/widget_example_lastvisits.html" "/kunden/340940_23730/stadtneustadt_de/piwik/piwik-autoarchive.sh" "/kunden/340940_23730/stadtneustadt_de/piwik/piwik.min.js" "/kunden/340940_23730/stadtneustadt_de/piwik/tests/README.txt" "/kunden/340940_23730/stadtneustadt_de/piwik/misc/log-analytics/.git" |