Matomo database will be upgraded from version 2.15.0 to the new version 4.3.0.
The following plugins will be updated: LanguagesManager, Goals, Provider.
The following dimensions will be updated: 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.idpageview, log_link_visit_action.product_price, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_link_visit_action.time_spent_ref_action, log_visit.config_browser_engine, log_visit.config_browser_name, log_visit.config_browser_version, log_visit.config_client_type, log_visit.config_cookie, log_visit.config_device_brand, log_visit.config_device_model, log_visit.config_device_type, log_visit.config_flash, log_visit.config_java, log_visit.config_os, log_visit.config_pdf, log_visit.config_quicktime, log_visit.config_realplayer, log_visit.config_resolution, log_visit.config_silverlight, log_visit.config_windowsmedia, log_visit.location_browser_lang, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.location_region, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_entry_idaction_name, log_visit.visit_entry_idaction_url, log_visit.visit_exit_idaction_name, log_visit.visit_exit_idaction_url, log_visit.visit_goal_buyer, log_visit.visit_goal_converted, log_visit.visit_total_actions, log_visit.visit_total_events, log_visit.visit_total_interactions, log_visit.visit_total_searches, log_visit.visit_total_time, log_visit.visitor_count_visits, log_visit.visitor_localtime, log_visit.visitor_returning, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.
Important notes for large Matomo installations
This is a major update! It will take longer than usual.
The following advice is especially important for large 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 /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/console core:update
If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 4.3.0
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These SQL queries will be executed:
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\",\"nb_uniq_visitors\"],\"widget\":1,\"columns_to_display\":[\"nb_visits\",\"nb_uniq_visitors\"],\"rows\":[],\"rows_to_display\":[],\"forceView\":\"1\",\"viewDataTable\":\"graphEvolution\"},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetLivegetSimpleLastVisitCount\",\"parameters\":{\"module\":\"Live\",\"action\":\"getSimpleLastVisitCount\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1,\"isFooterExpandedInDashboard\":false},\"isHidden\":false}],[{\"uniqueId\":\"widgetUserCountryMapvisitorMap\",\"parameters\":{\"module\":\"UserCountryMap\",\"action\":\"visitorMap\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetDevicesDetectiongetBrowsers\",\"parameters\":{\"module\":\"DevicesDetection\",\"action\":\"getBrowsers\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = 1;
CREATE TABLE `piwik_plugin_setting` (`plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, `user_login` VARCHAR(100) NOT NULL DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_plugin_setting` ADD INDEX index_plugin_name_user_login (`plugin_name`, `user_login`);
DELETE FROM `piwik_option` WHERE `option_name` like "Plugin_%_Settings";
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL, `plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site_setting` ADD INDEX(idsite, plugin_name);
ALTER TABLE `piwik_log_visit` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `piwik_log_conversion_item` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_log_conversion` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED default NULL;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idaction_name_ref` `idaction_name_ref` INTEGER(10) UNSIGNED NULL;
ALTER TABLE `piwik_user` CHANGE `password` `password` VARCHAR(255) NOT NULL;
CREATE TABLE `piwik_privacy_logdata_anonymizations` (`idlogdata_anonymization` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idsites` TEXT NULL DEFAULT NULL, `date_start` DATETIME NOT NULL, `date_end` DATETIME NOT NULL, `anonymize_ip` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_location` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_userid` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `unset_visit_columns` TEXT NOT NULL DEFAULT '', `unset_link_visit_action_columns` TEXT NOT NULL DEFAULT '', `output` MEDIUMTEXT NULL DEFAULT NULL, `scheduled_date` DATETIME NULL, `job_start_date` DATETIME NULL, `job_finish_date` DATETIME NULL, `requester` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY ( `idlogdata_anonymization` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`);
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwik_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwik_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `piwik_access` DROP PRIMARY KEY;
ALTER TABLE `piwik_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `piwik_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `piwik_report_subscriptions` (`idreport` INT(11) NOT NULL, `token` VARCHAR(100) NULL, `email` VARCHAR(100) NOT NULL, `ts_subscribed` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `ts_unsubscribed` TIMESTAMP NULL, PRIMARY KEY ( `idreport`, `email` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `piwik_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `piwik_user` SET ts_password_modified = NULL;
ALTER TABLE `piwik_site` ADD COLUMN `creator_login` VARCHAR(100) NULL;
# These console commands will be run:
./console plugin:activate "IntranetMeasurable"
# These SQL queries will be executed:
ALTER TABLE `piwik_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `piwik_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `piwik_twofactor_recovery_code` (`idrecoverycode` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL, `recovery_code` VARCHAR(40) NOT NULL, PRIMARY KEY ( `idrecoverycode` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# These console commands will be run:
./console plugin:activate "TwoFactorAuth"
./console plugin:deactivate "GoogleAuthenticator"
# These SQL queries will be executed:
CREATE TABLE `piwik_tracking_failure` (`idsite` BIGINT(20) UNSIGNED NOT NULL, `idfailure` SMALLINT UNSIGNED NOT NULL, `date_first_occurred` DATETIME NOT NULL, `request_url` MEDIUMTEXT NOT NULL, PRIMARY KEY ( `idsite`, `idfailure` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `piwik_brute_force_log` (`id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, PRIMARY KEY ( `id_brute_force_log` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;
# These console commands will be run:
./console plugin:activate "Tour"
# These SQL queries will be executed:
ALTER TABLE `piwik_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `piwik_locks` (`key` VARCHAR(70) NOT NULL, `value` VARCHAR(255) NULL DEFAULT NULL, `expiry_time` BIGINT UNSIGNED DEFAULT 9999999999, PRIMARY KEY ( `key` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# These console commands will be run:
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleAPI"
# These SQL queries will be executed:
UPDATE `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2024-12.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2024-12.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz';
# 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_2014_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_04` 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_blob_2014_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_04` 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_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 plugin:activate "CustomDimensions"
./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_2014_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_04` 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.';
ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
ALTER TABLE `piwik_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;
ALTER TABLE `piwik_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`;
ALTER TABLE `piwik_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwik_log_visit` CHANGE `location_provider` `location_provider` VARCHAR(200) NULL;
ALTER TABLE `piwik_log_visit` ADD COLUMN `profilable` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_returning` 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_entry_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL DEFAULT NULL, MODIFY COLUMN `visit_exit_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_exit_idaction_url` INTEGER(10) UNSIGNED NULL DEFAULT 0, MODIFY COLUMN `visit_total_actions` INT(11) UNSIGNED NULL, ADD COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `location_browser_lang` VARCHAR(20) NULL, MODIFY COLUMN `config_browser_engine` VARCHAR(10) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_browser_version` VARCHAR(20) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `config_os` CHAR(3) NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, MODIFY COLUMN `config_resolution` VARCHAR(18) NULL, MODIFY COLUMN `config_cookie` TINYINT(1) NULL, MODIFY COLUMN `config_flash` TINYINT(1) NULL, MODIFY COLUMN `config_java` TINYINT(1) NULL, MODIFY COLUMN `config_pdf` TINYINT(1) NULL, MODIFY COLUMN `config_quicktime` TINYINT(1) NULL, MODIFY COLUMN `config_realplayer` TINYINT(1) NULL, MODIFY COLUMN `config_silverlight` TINYINT(1) NULL, MODIFY COLUMN `config_windowsmedia` TINYINT(1) NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_returning` 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 `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 `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `time_spent_ref_action` 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;
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.
| File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error. |
| Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <-- Directory to delete: libs/Zend/Cache Directory to delete: libs/Zend/Config Directory to delete: libs/Zend/Mail Directory to delete: libs/Zend/Validate Directory to delete: libs/bower_components Directory to delete: libs/jquery Directory to delete: libs/pChart Directory to delete: libs/sparkline Directory to delete: libs/tcpdf Directory to delete: vendor/container-interop Directory to delete: vendor/doctrine/annotations Directory to delete: vendor/doctrine/lexer Directory to delete: vendor/leafo Directory to delete: vendor/mnapoli Directory to delete: vendor/php-di/php-di/src/DI Directory to delete: vendor/piwik Directory to delete: vendor/symfony/yaml Directory to delete: vendor/tecnick.com Directory to delete: vendor/twig/twig/ext Directory to delete: vendor/twig/twig/lib To delete all these directories at once, you can run this command: rm -Rf /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Cache /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Config /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mail /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Validate /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/bower_components /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jquery /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/pChart /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/sparkline /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/tcpdf /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/container-interop /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/annotations /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/lexer /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/leafo /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/mnapoli /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/php-di/php-di/src/DI /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/piwik /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/yaml /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/tecnick.com /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/twig/twig/ext /mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/twig/twig/lib |
| Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/global.ini.auto-backup-before-update.php File to delete: libs/Archive_Tar/Tar.php File to delete: libs/MaxMindGeoIP/geoip.inc File to delete: libs/MaxMindGeoIP/geoipcity.inc File to delete: libs/PEAR.php File to delete: libs/PEAR/Exception.php File to delete: libs/PEAR/FixPHP5PEARWarnings.php File to delete: libs/PEAR/LICENSE File to delete: libs/PEAR5.php File to delete: libs/PclZip/lgpl-2.1.txt File to delete: libs/PclZip/pclzip.lib.php File to delete: libs/PiwikTracker/LICENSE File to delete: libs/PiwikTracker/LICENSE.txt File to delete: libs/PiwikTracker/README.md File to delete: libs/PiwikTracker/composer.json File to delete: libs/UserAgentParser/README.md File to delete: libs/UserAgentParser/UserAgentParser.php File to delete: libs/UserAgentParser/UserAgentParser.test.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/angularjs/LICENSE File to delete: libs/angularjs/angular-animate.js File to delete: libs/angularjs/angular-animate.min.js File to delete: libs/angularjs/angular-cookies.js File to delete: libs/angularjs/angular-cookies.min.js File to delete: libs/angularjs/angular-csp.css File to delete: libs/angularjs/angular-loader.js File to delete: libs/angularjs/angular-loader.min.js File to delete: libs/angularjs/angular-mocks.js File to delete: libs/angularjs/angular-resource.js File to delete: libs/angularjs/angular-resource.min.js File to delete: libs/angularjs/angular-route.js File to delete: libs/angularjs/angular-route.min.js File to delete: libs/angularjs/angular-sanitize.js File to delete: libs/angularjs/angular-sanitize.min.js File to delete: libs/angularjs/angular-scenario.js File to delete: libs/angularjs/angular-touch.js File to delete: libs/angularjs/angular-touch.min.js File to delete: libs/angularjs/angular.js File to delete: libs/angularjs/angular.min.js File to delete: libs/angularjs/errors.json File to delete: libs/angularjs/version.json File to delete: libs/angularjs/version.txt File to delete: libs/html5shiv/html5shiv.js File to delete: libs/javascript/json2.js File to delete: libs/javascript/sprintf.js File to delete: libs/jqplot/jqplot.core.js File to delete: libs/jqplot/jqplot.lineRenderer.js File to delete: libs/jqplot/jqplot.linearAxisRenderer.js File to delete: libs/jqplot/jqplot.themeEngine.js File to delete: libs/jqplot/plugins/jqplot.barRenderer.js File to delete: libs/jqplot/plugins/jqplot.pieRenderer.js File to delete: libs/mousetrap/README.md File to delete: libs/mousetrap/mousetrap.min.js File to delete: misc/How to install Piwik.html File to delete: misc/gpl-3.0.txt File to delete: misc/internal-docs/content-tracking.md File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/api_internal_call.php File to delete: misc/others/api_rest_call.php File to delete: misc/others/cli-script-bootstrap.php File to delete: misc/others/download-count.txt File to delete: misc/others/iframeWidget.htm File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/others/phpstorm-codestyles/README.md File to delete: misc/others/stress.sh File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: misc/others/widget_example_lastvisits.html File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: misc/proxy-hide-piwik-url/piwik.php File to delete: vendor/composer/installed.json File to delete: vendor/doctrine/cache/build.properties File to delete: vendor/doctrine/cache/build.xml File to delete: vendor/doctrine/cache/composer.json File to delete: vendor/doctrine/cache/lib/Doctrine/Common/Cache/RiakCache.php File to delete: vendor/doctrine/cache/phpunit.xml.dist File to delete: vendor/monolog/monolog/CHANGELOG.mdown File to delete: vendor/monolog/monolog/README.mdown File to delete: vendor/monolog/monolog/composer.json File to delete: vendor/monolog/monolog/doc/01-usage.md File to delete: vendor/monolog/monolog/doc/02-handlers-formatters-processors.md File to delete: vendor/monolog/monolog/doc/03-utilities.md File to delete: vendor/monolog/monolog/doc/04-extending.md File to delete: vendor/monolog/monolog/doc/sockets.md File to delete: vendor/monolog/monolog/phpunit.xml.dist File to delete: vendor/mustangostang/spyc/README File to delete: vendor/mustangostang/spyc/composer.json File to delete: vendor/pear/archive_tar/composer.json File to delete: vendor/pear/archive_tar/docs/Archive_Tar.txt File to delete: vendor/pear/console_getopt/composer.json File to delete: vendor/pear/pear-core-minimal/composer.json File to delete: vendor/pear/pear-core-minimal/src/PEAR/ErrorStack5.php File to delete: vendor/pear/pear-core-minimal/src/PEAR5.php File to delete: vendor/pear/pear_exception/composer.json File to delete: vendor/php-di/invoker/composer.json File to delete: vendor/php-di/invoker/doc/parameter-resolvers.md File to delete: vendor/php-di/php-di/composer.json File to delete: vendor/php-di/php-di/phpunit.xml.dist File to delete: vendor/psr/log/composer.json File to delete: vendor/symfony/console/Symfony/Component/Console/composer.json File to delete: vendor/symfony/console/Symfony/Component/Console/phpunit.xml.dist File to delete: vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/composer.json File to delete: vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/phpunit.xml.dist File to delete: vendor/symfony/monolog-bridge/Symfony/Bridge/Monolog/composer.json File to delete: vendor/symfony/monolog-bridge/Symfony/Bridge/Monolog/phpunit.xml.dist File to delete: vendor/tedivm/jshrink/composer.json File to delete: vendor/tedivm/jshrink/package.xml File to delete: vendor/tedivm/jshrink/phpunit.xml.dist File to delete: vendor/twig/twig/composer.json File to delete: vendor/twig/twig/phpunit.xml.dist File to delete: vendor/monolog/monolog/.php_cs File to delete: vendor/pear/archive_tar/.travis.sh File to delete: vendor/twig/twig/.editorconfig To delete all these files at once, you can run this command: rm "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/bower.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/composer.lock" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/config/global.ini.auto-backup-before-update.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Archive_Tar/Tar.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/MaxMindGeoIP/geoip.inc" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/MaxMindGeoIP/geoipcity.inc" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PEAR.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PEAR/Exception.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PEAR/FixPHP5PEARWarnings.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PEAR/LICENSE" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PEAR5.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PclZip/lgpl-2.1.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PclZip/pclzip.lib.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PiwikTracker/LICENSE" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PiwikTracker/LICENSE.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PiwikTracker/README.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/PiwikTracker/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/UserAgentParser/README.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/UserAgentParser/UserAgentParser.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/UserAgentParser/UserAgentParser.test.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mime.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mime/Decode.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mime/Exception.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mime/Message.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/Zend/Mime/Part.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/LICENSE" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-animate.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-animate.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-cookies.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-cookies.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-csp.css" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-loader.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-loader.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-mocks.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-resource.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-resource.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-route.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-route.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-sanitize.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-sanitize.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-scenario.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-touch.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular-touch.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/angular.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/errors.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/version.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/angularjs/version.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/html5shiv/html5shiv.js" rm "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/javascript/json2.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/javascript/sprintf.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/jqplot.core.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/jqplot.lineRenderer.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/jqplot.linearAxisRenderer.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/jqplot.themeEngine.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/plugins/jqplot.barRenderer.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/jqplot/plugins/jqplot.pieRenderer.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/mousetrap/README.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/libs/mousetrap/mousetrap.min.js" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/How to install Piwik.html" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/gpl-3.0.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/internal-docs/content-tracking.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/ExamplePiwikTracker.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/api_internal_call.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/api_rest_call.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/cli-script-bootstrap.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/download-count.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/iframeWidget.htm" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/iframeWidget_localhost.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/phpstorm-codestyles/README.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/stress.sh" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/uninstall-delete-piwik-directory.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/others/widget_example_lastvisits.html" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/phpstorm-codestyles/README.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/misc/proxy-hide-piwik-url/piwik.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/composer/installed.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/cache/build.properties" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/cache/build.xml" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/cache/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/cache/lib/Doctrine/Common/Cache/RiakCache.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/doctrine/cache/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/CHANGELOG.mdown" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/README.mdown" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/doc/01-usage.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/doc/02-handlers-formatters-processors.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/doc/03-utilities.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/doc/04-extending.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/doc/sockets.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/mustangostang/spyc/README" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/mustangostang/spyc/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/archive_tar/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/archive_tar/docs/Archive_Tar.txt" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/console_getopt/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/pear-core-minimal/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/pear-core-minimal/src/PEAR/ErrorStack5.php" rm "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/pear-core-minimal/src/PEAR5.php" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/pear_exception/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/php-di/invoker/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/php-di/invoker/doc/parameter-resolvers.md" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/php-di/php-di/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/php-di/php-di/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/psr/log/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/console/Symfony/Component/Console/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/console/Symfony/Component/Console/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/monolog-bridge/Symfony/Bridge/Monolog/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/symfony/monolog-bridge/Symfony/Bridge/Monolog/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/tedivm/jshrink/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/tedivm/jshrink/package.xml" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/tedivm/jshrink/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/twig/twig/composer.json" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/twig/twig/phpunit.xml.dist" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/monolog/monolog/.php_cs" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/pear/archive_tar/.travis.sh" "/mnt/web204/e0/41/54194841/htdocs/piwik/piwik/vendor/twig/twig/.editorconfig" |