Die Matomo-Datenbank wird von Version 4.16.0 auf die neue Version 5.1.2 aktualisiert.
Die folgenden Dimensionen werden aktualisiert: log_conversion.pageviews_before.
Wichtiger Hinweis für große Matomo-Installationen
Wenn Sie eine große Matomo-Datenbank haben, können Aktualisierungen zu lange dauern, um erfolgreich im Browser durchgeführt zu werden. In diesem Fall können Sie die Aktualisierung auch von der Kommandozeile aus starten:
php /var/www/vhosts/gbkenn.de/subdomains/piwik/httpdocs/console core:update
Wenn Sie eine Webseite mit hohem Verkehrsaufkommen verwalten, empfehlen wir, das Besuchertracking vorübergehend zu deaktivieren und die Benutzeroberfläche in den Wartungsmodus zu versetzen.
Zu Ihrer Information: Dies sind die SQL Abfragen und Konsolenkommandos, welche ausgeführt werden, um die Datenbank für Matomo 5.1.2 zu aktualisieren
# Diese SQL Abfragen werden ausgeführt:
DELETE FROM `piwik_archive_numeric_2010_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2010_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2010_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2010_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2010_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2010_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2010_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2010_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2011_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2011_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2011_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_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2012_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2012_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2012_03` 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_2023_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_02` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_03` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_04` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_05` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_06` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_07` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_08` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwik_archive_numeric_2024_09` WHERE ts_archived is null;
ALTER TABLE `piwik_archive_numeric_2024_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwik_archive_numeric_2024_09` 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;
# Diese Konsolenkommandos werden ausgeführt:
./console core:calculate-conversion-pages --dates=yesterday,today
# Diese SQL Abfragen werden ausgeführt:
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`;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "JsTrackerInstallCheck"
# Diese SQL Abfragen werden ausgeführt:
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;
# Diese Konsolenkommandos werden ausgeführt:
./console config:set --section="database" --key="collation" --value="utf8mb4_general_ci"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
Brauchen Sie Hilfe beim Upgrade von Matomo?
Wenn Sie Hilfe beim Upgrade von Matomo brauchen, sind die Ersteller von Matomo hier, um Ihnen zu einem erfolgreichen Upgrade zu helfen. Für Anleitungen, best practises und weiterführenden Support, kontaktiere die Matomo-Experten um das Upgrade sicher durchzuführen.
Sind Sie bereit?
Die Aktualisierung kann eine Weile dauern. Bitte haben Sie etwas Geduld.
Der Datei-Integritätscheck ist fehlgeschlagen und hat ein paar Fehler gemeldet. Du solltest die Probleme beheben und diese Seite neu laden, bis sie keine Fehler mehr anzeigt. |
Es wurden unerwartete Dateien in Ihrer Matomo-Installation gefunden. --> Bitte löschen Sie diese Dateien, um Fehler zu vermeiden. <-- Zu löschende Datei: piwik.min.js Um alle diese Dateien auf einmal zu löschen, kannst du folgenden Befehl ausführen: rm "/var/www/vhosts/gbkenn.de/subdomains/piwik/httpdocs/piwik.min.js" |