Matomo › Update

Matomo database will be upgraded from version 3.5.0 to the new version 4.1.0.

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.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 /www/htdocs/w007ca1e/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.1.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: 
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-11.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-11.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_2011_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2011_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2011_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2011_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2011_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2012_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_05` CHANGE `name` `name` VARCHAR(190);
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_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_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_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2011_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2011_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2011_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2011_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2011_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2012_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_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_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_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_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_01` 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: 
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;
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.

Database Upgrade Required

Important notes for large Matomo installations

Need help upgrading Matomo?

Ready to go?