Matomo database will be upgraded from version 3.13.5 to the new version 5.1.0.
The following dimensions will be updated: log_conversion.pageviews_before, log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.product_price, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_link_visit_action.time_dom_completion, log_link_visit_action.time_dom_processing, log_link_visit_action.time_network, log_link_visit_action.time_on_load, log_link_visit_action.time_server, log_link_visit_action.time_transfer, log_visit.config_browser_name, log_visit.config_client_type, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.
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 /usr/local/www/apache24/noexec/piwik.goThree.CO/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.1.0
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These console commands will be run:
./console core:matomo4-migrate-token-auths
# These SQL queries will be executed:
CREATE TABLE `piwik_archive_invalidations` (`idinvalidation` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idarchive` INTEGER UNSIGNED NULL, `name` VARCHAR(255) NOT NULL, `idsite` INTEGER NOT NULL, `date1` DATE NOT NULL, `date2` DATE NOT NULL, `period` TINYINT UNSIGNED NOT NULL, `ts_invalidated` DATETIME NOT NULL, `status` TINYINT(1) UNSIGNED DEFAULT 0, `report` VARCHAR(255) NULL, PRIMARY KEY ( `idinvalidation` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);
ALTER TABLE `piwik_user` DROP COLUMN `alias`;
DELETE FROM `piwik_session` WHERE length(id) > 190;
ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR(191);
ALTER TABLE `piwik_site_url` CHANGE `url` `url` VARCHAR(190);
ALTER TABLE `piwik_option` CHANGE `option_name` `option_name` VARCHAR(191);
ALTER TABLE `piwik_log_action` CHANGE `name` `name` VARCHAR(4096);
ALTER TABLE `piwik_log_conversion` CHANGE `url` `url` VARCHAR(4096);
ALTER TABLE `piwik_log_link_visit_action` CHANGE `interaction_position` `pageview_position` MEDIUMINT UNSIGNED DEFAULT NULL;
# These console commands will be run:
./console plugin:activate "BulkTracking"
./console plugin:deactivate "CustomPiwikJs"
./console plugin:uninstall "CustomPiwikJs"
# These SQL queries will be executed:
ALTER TABLE `piwik_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2023_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2024_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2023_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2024_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');
ALTER TABLE `piwik_log_visit` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, ADD COLUMN `profilable` TINYINT(1) NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');
ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');
UPDATE piwik_log_link_visit_action SET search_cat = if(custom_var_k4 = '_pk_scat', custom_var_v4, search_cat), search_count = if(custom_var_k5 = '_pk_scount', custom_var_v5, search_count) WHERE custom_var_k4 = '_pk_scat' or custom_var_k5 = '_pk_scount';
DELETE FROM `piwik_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");
UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, visitor_seconds_since_order = visitor_days_since_order * 86400, visitor_seconds_since_last = visitor_days_since_last * 86400;
UPDATE piwik_log_conversion SET visitor_seconds_since_first = visitor_days_since_first * 86400, visitor_seconds_since_order = visitor_days_since_order * 86400;
ALTER TABLE `piwik_log_visit` DROP COLUMN `config_gears`, DROP COLUMN `config_director`, DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`, DROP COLUMN `visitor_days_since_last`;
ALTER TABLE `piwik_log_conversion` DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`;
# These console commands will be run:
./console config:set --section="Tracker" --key="ignore_visits_cookie_name" --value="piwik_ignore"
./console plugin:activate "PagePerformance"
./console config:set --section="General" --key="login_allowlist_apply_to_reporting_api_requests" --value="0"
# These SQL queries will be executed:
ALTER TABLE `piwik_archive_invalidations` ADD COLUMN `ts_started` DATETIME NULL;
# These console commands will be run:
./console plugin:deactivate "ExampleTheme"
# These SQL queries will be executed:
UPDATE piwik_user_token_auth SET hash_algo = "sha512" where hash_algo is null or hash_algo = "" ;
# These console commands will be run:
./console plugin:uninstall "ExampleTheme"
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"
# These SQL queries will be executed:
UPDATE `piwik_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2023_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2024_06` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
ALTER TABLE `piwik_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;
# These console commands will be run:
./console config:set --section="General" --key="login_allow_logme" --value="1"
# These SQL queries will be executed:
ALTER TABLE `piwik_session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run:
./console plugin:activate "CoreVue"
# These SQL queries will be executed:
ALTER TABLE `piwik_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `piwik_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `piwik_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `piwik_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
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_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_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));
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` DESC);
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';
DELETE FROM `piwik_option` WHERE option_name = 'viewDataTableParameters_TMWeb_Referrers.getEvolutionGraph';
ALTER TABLE `piwik_user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;
ALTER TABLE `piwik_log_visit` ADD COLUMN `profilable` TINYINT(1) NULL, ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL;
ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED 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: vendor/leafo To delete all these directories at once, you can run this command: rm -Rf /usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/leafo |
| 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: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: core/Composer/ScriptHandler.php File to delete: core/CronArchive/SegmentArchivingRequestUrlProvider.php File to delete: core/CronArchive/SitesToReprocessDistributedList.php File to delete: core/DataFiles/cacert.pem File to delete: core/DataTable/Renderer/Php.php File to delete: core/DeviceDetectorFactory.php File to delete: core/MetricsFormatter.php File to delete: core/Registry.php File to delete: core/ScheduledTask.php File to delete: core/TaskScheduler.php File to delete: core/Tracker/TableLogAction/Cache.php File to delete: core/Translate.php File to delete: core/Updates/2.2.0-b15.php File to delete: libs/MaxMindGeoIP/geoip.inc File to delete: libs/MaxMindGeoIP/geoipcity.inc File to delete: libs/Zend/Mail.php File to delete: libs/Zend/Mime.php File to delete: libs/Zend/Mime/Decode.php File to delete: libs/Zend/Mime/Exception.php File to delete: libs/Zend/Mime/Message.php File to delete: libs/Zend/Mime/Part.php File to delete: libs/Zend/Validate.php File to delete: misc/How to install Piwik.html File to delete: misc/composer/build-xhprof.sh File to delete: misc/composer/clean-xhprof.sh File to delete: misc/gpl-3.0.txt File to delete: misc/internal-docs/content-tracking.md File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/api_internal_call.php File to delete: misc/others/iframeWidget.htm File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: plugins/API/Renderer/Json2.php File to delete: plugins/API/Renderer/Php.php File to delete: plugins/Actions/Columns/InteractionPosition.php File to delete: plugins/Contents/DataArray.php File to delete: plugins/CoreAdminHome/config/test.php File to delete: plugins/CoreConsole/Commands/GenerateAngularComponent.php File to delete: plugins/CoreConsole/Commands/GenerateAngularConstructBase.php File to delete: plugins/CoreConsole/Commands/GenerateAngularDirective.php File to delete: plugins/CoreHome/LoginWhitelist.php File to delete: plugins/CoreHome/javascripts/donate.js File to delete: plugins/CoreHome/javascripts/iframeResizer.contentWindow.min.js File to delete: plugins/CoreHome/javascripts/iframeResizer.min.js File to delete: plugins/CoreHome/javascripts/noreferrer.js File to delete: plugins/CoreHome/javascripts/zen-mode.js File to delete: plugins/CorePluginsAdmin/config/test.php File to delete: plugins/CorePluginsAdmin/templates/macros.twig File to delete: plugins/CoreUpdater/ReleaseChannel/Latest3XBeta.php File to delete: plugins/CoreUpdater/ReleaseChannel/Latest3XStable.php File to delete: plugins/DBStats/config/test.php File to delete: plugins/Dashboard/DashboardManagerControl.php File to delete: plugins/Dashboard/DashboardSettingsControlBase.php File to delete: plugins/Dashboard/templates/_dashboardSettings.twig File to delete: plugins/DevicePlugins/Columns/PluginDirector.php File to delete: plugins/DevicePlugins/Columns/PluginGears.php File to delete: plugins/Diagnostics/Diagnostic/LoadDataInfileCheck.php File to delete: plugins/Ecommerce/templates/products.twig File to delete: plugins/Ecommerce/templates/sales.twig File to delete: plugins/Feedback/templates/feedbackPopup.twig File to delete: plugins/GeoIp2/Columns/Region.php File to delete: plugins/GeoIp2/config/test.php File to delete: plugins/Goals/stylesheets/goals.css File to delete: plugins/Goals/templates/_formAddGoal.twig File to delete: plugins/Goals/templates/_listGoalEdit.twig File to delete: plugins/Installation/templates/_systemCheckLegend.twig File to delete: plugins/Login/config/test.php File to delete: plugins/Marketplace/Categories/PremiumFeaturesSubcategory.php File to delete: plugins/Marketplace/Input/Mode.php File to delete: plugins/Marketplace/config/test.php File to delete: plugins/Marketplace/templates/licenseform.twig File to delete: plugins/Marketplace/templates/paid-plugins-install-list.twig File to delete: plugins/Marketplace/templates/plugin-list.twig File to delete: plugins/Marketplace/templates/uploadPluginDialog.twig File to delete: plugins/MobileMessaging/angularjs/delegate-mobile-messaging-settings.controller.js File to delete: plugins/MobileMessaging/angularjs/manage-mobile-phone-numbers.controller.js File to delete: plugins/MobileMessaging/angularjs/manage-sms-provider.controller.js File to delete: plugins/MobileMessaging/angularjs/sms-provider-credentials.directive.js File to delete: plugins/MobileMessaging/templates/credentials.twig File to delete: plugins/MobileMessaging/templates/macros.twig File to delete: plugins/Morpheus/fonts/piwik.svg File to delete: plugins/Morpheus/fonts/piwik.ttf File to delete: plugins/Morpheus/fonts/piwik.woff File to delete: plugins/Morpheus/fonts/piwik.woff2 File to delete: plugins/Morpheus/icons/dist/searchEngines/search.start.fyi.png File to delete: plugins/Morpheus/images/paypal_subscribe.png File to delete: plugins/Morpheus/images/smileyprog_0.png File to delete: plugins/Morpheus/images/smileyprog_1.png File to delete: plugins/Morpheus/images/smileyprog_2.png File to delete: plugins/Morpheus/images/smileyprog_3.png File to delete: plugins/Morpheus/images/smileyprog_4.png File to delete: plugins/Morpheus/javascripts/ajaxHelper.js File to delete: plugins/Morpheus/stylesheets/base/font.css File to delete: plugins/Overlay/config/ui-test.php File to delete: plugins/ProfessionalServices/config/test.php File to delete: plugins/SEO/Metric/Alexa.php File to delete: plugins/ScheduledReports/templates/_addReport.twig File to delete: plugins/ScheduledReports/templates/_listReports.twig File to delete: plugins/SegmentEditor/SegmentList.php File to delete: plugins/SegmentEditor/images/segment-move.png File to delete: plugins/SitesManager/templates/dialogs/dialogs.html File to delete: plugins/SitesManager/templates/dialogs/remove-dialog.html File to delete: plugins/SitesManager/templates/global-settings.html File to delete: plugins/SitesManager/templates/help/excluded-ip-help.html File to delete: plugins/SitesManager/templates/help/excluded-query-parameters-help.html File to delete: plugins/SitesManager/templates/help/excluded-user-agents-help.html File to delete: plugins/SitesManager/templates/help/timezone-help.html File to delete: plugins/SitesManager/templates/index.html File to delete: plugins/SitesManager/templates/loading.html File to delete: plugins/SitesManager/templates/sites-list/add-entity-dialog.html File to delete: plugins/SitesManager/templates/sites-list/add-site-link.html File to delete: plugins/SitesManager/templates/sites-list/site-fields.html File to delete: plugins/SitesManager/templates/sites-list/site-search-field.html File to delete: plugins/SitesManager/templates/sites-list/sites-list.html File to delete: plugins/SitesManager/templates/sites-manager-header.html File to delete: plugins/TagManager/Template/Variable/PreConfigured/FormDestionationVariable.php File to delete: plugins/TagManager/config/test.php File to delete: plugins/Tour/Engagement/ChallengeAddedUser.php File to delete: plugins/Tour/config/test.php File to delete: plugins/TwoFactorAuth/config/test.php File to delete: plugins/TwoFactorAuth/javascripts/twofactorauth.js File to delete: plugins/TwoFactorAuth/templates/_setupTwoFactorAuth.twig File to delete: plugins/TwoFactorAuth/templates/_showRecoveryCodes.twig File to delete: plugins/UserCountry/Columns/Provider.php File to delete: plugins/UserCountry/GeoIPAutoUpdater.php File to delete: plugins/UserCountry/LocationProvider/GeoIp.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/Pecl.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/Php.php File to delete: plugins/UserCountry/LocationProvider/GeoIp/ServerBased.php File to delete: plugins/UserCountry/Tasks.php File to delete: plugins/UserCountry/templates/_updaterManage.twig File to delete: plugins/UserCountry/templates/_updaterNextRunTime.twig File to delete: plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php File to delete: plugins/VisitsSummary/templates/index.twig File to delete: vendor/composer/installed.json File to delete: vendor/matomo/referrer-spam-blacklist/CONTRIBUTING.md File to delete: vendor/matomo/referrer-spam-blacklist/README.md File to delete: vendor/matomo/referrer-spam-blacklist/spammers.txt File to delete: vendor/pear/archive_tar/docs/Archive_Tar.txt File to delete: vendor/pear/archive_tar/package.xml File to delete: vendor/pear/console_getopt/package.xml File to delete: vendor/pear/pear-core-minimal/src/PEAR/Error.php File to delete: vendor/php-di/invoker/doc/parameter-resolvers.md File to delete: vendor/php-di/php-di/phpbench.json File to delete: vendor/szymach/c-pchart/codeception.yml File to delete: vendor/szymach/c-pchart/coverage.sh File to delete: vendor/szymach/c-pchart/doc/2d_pie.md File to delete: vendor/szymach/c-pchart/doc/2d_ring.md File to delete: vendor/szymach/c-pchart/doc/3d_pie.md File to delete: vendor/szymach/c-pchart/doc/3d_ring.md File to delete: vendor/szymach/c-pchart/doc/area.md File to delete: vendor/szymach/c-pchart/doc/bar.md File to delete: vendor/szymach/c-pchart/doc/barcode_128.md File to delete: vendor/szymach/c-pchart/doc/barcode_39.md File to delete: vendor/szymach/c-pchart/doc/best_fit.md File to delete: vendor/szymach/c-pchart/doc/bubble.md File to delete: vendor/szymach/c-pchart/doc/cache.md File to delete: vendor/szymach/c-pchart/doc/contour.md File to delete: vendor/szymach/c-pchart/doc/filled_spline.md File to delete: vendor/szymach/c-pchart/doc/filled_step.md File to delete: vendor/szymach/c-pchart/doc/line.md File to delete: vendor/szymach/c-pchart/doc/plot.md File to delete: vendor/szymach/c-pchart/doc/polar.md File to delete: vendor/szymach/c-pchart/doc/progress.md File to delete: vendor/szymach/c-pchart/doc/radar.md File to delete: vendor/szymach/c-pchart/doc/scatter_best_fit.md File to delete: vendor/szymach/c-pchart/doc/scatter_line.md File to delete: vendor/szymach/c-pchart/doc/scatter_plot.md File to delete: vendor/szymach/c-pchart/doc/scatter_spline.md File to delete: vendor/szymach/c-pchart/doc/scatter_threshold.md File to delete: vendor/szymach/c-pchart/doc/scatter_threshold_area.md File to delete: vendor/szymach/c-pchart/doc/spline.md File to delete: vendor/szymach/c-pchart/doc/split_path.md File to delete: vendor/szymach/c-pchart/doc/spring.md File to delete: vendor/szymach/c-pchart/doc/stacked_area.md File to delete: vendor/szymach/c-pchart/doc/stacked_bar.md File to delete: vendor/szymach/c-pchart/doc/step.md File to delete: vendor/szymach/c-pchart/doc/stock.md File to delete: vendor/szymach/c-pchart/doc/surface.md File to delete: vendor/szymach/c-pchart/doc/zone.md File to delete: vendor/szymach/c-pchart/phpcs.xml File to delete: vendor/szymach/c-pchart/src/Chart/Barcode128.php File to delete: vendor/szymach/c-pchart/src/Chart/Barcode39.php File to delete: vendor/szymach/c-pchart/src/Chart/BaseDraw.php File to delete: vendor/szymach/c-pchart/src/Chart/Cache.php File to delete: vendor/szymach/c-pchart/src/Chart/Data.php File to delete: vendor/szymach/c-pchart/src/Chart/Draw.php File to delete: vendor/szymach/c-pchart/src/Chart/Image.php File to delete: vendor/szymach/c-pchart/src/Exception/ChartIsAMethodException.php File to delete: vendor/szymach/c-pchart/src/Exception/FactoryException.php File to delete: vendor/szymach/c-pchart/src/Exception/IncorrectBarcodeNumberException.php File to delete: vendor/szymach/c-pchart/src/Exception/NotSupportedChartException.php File to delete: vendor/szymach/c-pchart/src/Factory/Factory.php File to delete: vendor/tecnickcom/tcpdf/tools/convert_fonts_examples.txt File to delete: vendor/tecnickcom/tcpdf/tools/tcpdf_addfont.php File to delete: vendor/twig/twig/drupal_test.sh File to delete: vendor/twig/twig/src/Extension/InitRuntimeInterface.php File to delete: vendor/twig/twig/src/Loader/ExistsLoaderInterface.php File to delete: vendor/twig/twig/src/Loader/SourceContextLoaderInterface.php File to delete: vendor/twig/twig/src/Node/SandboxedPrintNode.php File to delete: vendor/twig/twig/src/Node/SetTempNode.php File to delete: vendor/twig/twig/src/Node/SpacelessNode.php File to delete: vendor/twig/twig/src/TokenParser/FilterTokenParser.php File to delete: vendor/twig/twig/src/TokenParser/SpacelessTokenParser.php To delete all these files at once, you can run this command: rm "/usr/local/www/apache24/noexec/piwik.goThree.CO/PULL_REQUEST_TEMPLATE" "/usr/local/www/apache24/noexec/piwik.goThree.CO/bower.json" "/usr/local/www/apache24/noexec/piwik.goThree.CO/composer.json" "/usr/local/www/apache24/noexec/piwik.goThree.CO/composer.lock" "/usr/local/www/apache24/noexec/piwik.goThree.CO/config/environment/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/config/environment/ui-test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/Composer/ScriptHandler.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/CronArchive/SegmentArchivingRequestUrlProvider.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/CronArchive/SitesToReprocessDistributedList.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/DataFiles/cacert.pem" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/DataTable/Renderer/Php.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/DeviceDetectorFactory.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/MetricsFormatter.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/Registry.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/ScheduledTask.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/TaskScheduler.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/Tracker/TableLogAction/Cache.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/Translate.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/core/Updates/2.2.0-b15.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/MaxMindGeoIP/geoip.inc" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/MaxMindGeoIP/geoipcity.inc" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mail.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mime.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mime/Decode.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mime/Exception.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mime/Message.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Mime/Part.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/libs/Zend/Validate.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/How to install Piwik.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/composer/build-xhprof.sh" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/composer/clean-xhprof.sh" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/gpl-3.0.txt" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/internal-docs/content-tracking.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/others/ExamplePiwikTracker.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/others/api_internal_call.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/others/iframeWidget.htm" "/usr/local/www/apache24/noexec/piwik.goThree.CO/misc/others/uninstall-delete-piwik-directory.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/API/Renderer/Json2.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/API/Renderer/Php.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Actions/Columns/InteractionPosition.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Contents/DataArray.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreAdminHome/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreConsole/Commands/GenerateAngularComponent.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreConsole/Commands/GenerateAngularConstructBase.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreConsole/Commands/GenerateAngularDirective.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/LoginWhitelist.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/javascripts/donate.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/javascripts/iframeResizer.contentWindow.min.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/javascripts/iframeResizer.min.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/javascripts/noreferrer.js" rm "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreHome/javascripts/zen-mode.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CorePluginsAdmin/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CorePluginsAdmin/templates/macros.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreUpdater/ReleaseChannel/Latest3XBeta.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/CoreUpdater/ReleaseChannel/Latest3XStable.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/DBStats/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Dashboard/DashboardManagerControl.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Dashboard/DashboardSettingsControlBase.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Dashboard/templates/_dashboardSettings.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/DevicePlugins/Columns/PluginDirector.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/DevicePlugins/Columns/PluginGears.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Diagnostics/Diagnostic/LoadDataInfileCheck.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Ecommerce/templates/products.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Ecommerce/templates/sales.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Feedback/templates/feedbackPopup.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/GeoIp2/Columns/Region.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/GeoIp2/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Goals/stylesheets/goals.css" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Goals/templates/_formAddGoal.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Goals/templates/_listGoalEdit.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Installation/templates/_systemCheckLegend.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Login/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/Categories/PremiumFeaturesSubcategory.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/Input/Mode.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/templates/licenseform.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/templates/paid-plugins-install-list.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/templates/plugin-list.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Marketplace/templates/uploadPluginDialog.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/angularjs/delegate-mobile-messaging-settings.controller.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/angularjs/manage-mobile-phone-numbers.controller.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/angularjs/manage-sms-provider.controller.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/angularjs/sms-provider-credentials.directive.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/templates/credentials.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/MobileMessaging/templates/macros.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/fonts/piwik.svg" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/fonts/piwik.ttf" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/fonts/piwik.woff" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/fonts/piwik.woff2" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/icons/dist/searchEngines/search.start.fyi.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/paypal_subscribe.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/smileyprog_0.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/smileyprog_1.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/smileyprog_2.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/smileyprog_3.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/images/smileyprog_4.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/javascripts/ajaxHelper.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Morpheus/stylesheets/base/font.css" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Overlay/config/ui-test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/ProfessionalServices/config/test.php" rm "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SEO/Metric/Alexa.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/ScheduledReports/templates/_addReport.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/ScheduledReports/templates/_listReports.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SegmentEditor/SegmentList.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SegmentEditor/images/segment-move.png" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/dialogs/dialogs.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/dialogs/remove-dialog.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/global-settings.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/help/excluded-ip-help.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/help/excluded-query-parameters-help.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/help/excluded-user-agents-help.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/help/timezone-help.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/index.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/loading.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-list/add-entity-dialog.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-list/add-site-link.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-list/site-fields.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-list/site-search-field.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-list/sites-list.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/SitesManager/templates/sites-manager-header.html" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TagManager/Template/Variable/PreConfigured/FormDestionationVariable.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TagManager/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Tour/Engagement/ChallengeAddedUser.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/Tour/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TwoFactorAuth/config/test.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TwoFactorAuth/javascripts/twofactorauth.js" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TwoFactorAuth/templates/_setupTwoFactorAuth.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/TwoFactorAuth/templates/_showRecoveryCodes.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/Columns/Provider.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/GeoIPAutoUpdater.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/LocationProvider/GeoIp.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/LocationProvider/GeoIp/Pecl.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/LocationProvider/GeoIp/Php.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/LocationProvider/GeoIp/ServerBased.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/Tasks.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/templates/_updaterManage.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/UserCountry/templates/_updaterNextRunTime.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/VisitorInterest/Columns/VisitsByDaysSinceLastVisit.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/plugins/VisitsSummary/templates/index.twig" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/composer/installed.json" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/matomo/referrer-spam-blacklist/CONTRIBUTING.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/matomo/referrer-spam-blacklist/README.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/matomo/referrer-spam-blacklist/spammers.txt" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/pear/archive_tar/docs/Archive_Tar.txt" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/pear/archive_tar/package.xml" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/pear/console_getopt/package.xml" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/pear/pear-core-minimal/src/PEAR/Error.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/php-di/invoker/doc/parameter-resolvers.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/php-di/php-di/phpbench.json" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/codeception.yml" rm "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/coverage.sh" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/2d_pie.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/2d_ring.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/3d_pie.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/3d_ring.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/area.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/bar.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/barcode_128.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/barcode_39.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/best_fit.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/bubble.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/cache.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/contour.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/filled_spline.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/filled_step.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/line.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/plot.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/polar.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/progress.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/radar.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_best_fit.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_line.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_plot.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_spline.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_threshold.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/scatter_threshold_area.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/spline.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/split_path.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/spring.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/stacked_area.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/stacked_bar.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/step.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/stock.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/surface.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/doc/zone.md" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/phpcs.xml" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Barcode128.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Barcode39.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/BaseDraw.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Cache.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Data.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Draw.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Chart/Image.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Exception/ChartIsAMethodException.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Exception/FactoryException.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Exception/IncorrectBarcodeNumberException.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Exception/NotSupportedChartException.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/szymach/c-pchart/src/Factory/Factory.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/tecnickcom/tcpdf/tools/convert_fonts_examples.txt" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/tecnickcom/tcpdf/tools/tcpdf_addfont.php" rm "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/drupal_test.sh" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Extension/InitRuntimeInterface.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Loader/ExistsLoaderInterface.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Loader/SourceContextLoaderInterface.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Node/SandboxedPrintNode.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Node/SetTempNode.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/Node/SpacelessNode.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/TokenParser/FilterTokenParser.php" "/usr/local/www/apache24/noexec/piwik.goThree.CO/vendor/twig/twig/src/TokenParser/SpacelessTokenParser.php" |