Matomo database will be upgraded from version 3.13.5 to the new version 4.1.0-b2.
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_visit.config_browser_name, log_visit.config_client_type, log_visit.location_region, 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 /var/www/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-b2
› 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_invalidations` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2008_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_blob_2008_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_log_link_visit_action` ;
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:
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, MODIFY COLUMN `location_region` char(3) DEFAULT 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, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` 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: vendor/wikimedia To delete all these directories at once, you can run this command: rm -Rf /var/www/piwik/vendor/wikimedia |
| Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: plugins/CoreHome/javascripts/broadcast.spec.js File to delete: vendor/bin/lessc To delete all these files at once, you can run this command: rm "/var/www/piwik/plugins/CoreHome/javascripts/broadcast.spec.js" "/var/www/piwik/vendor/bin/lessc" |
| Errors below may be due to a partial or failed upload of Matomo files. |
| --> Try to reupload all the Matomo files in BINARY mode. <-- |
| File size mismatch: /var/www/piwik/core/ArchiveProcessor/Loader.php (expected length: 15831, found: 14982) |
| File size mismatch: /var/www/piwik/core/AssetManager/UIAssetMerger/StylesheetUIAssetMerger.php (expected length: 9408, found: 9415) |
| File size mismatch: /var/www/piwik/core/CliMulti.php (expected length: 13740, found: 13737) |
| File size mismatch: /var/www/piwik/core/CliMulti/Process.php (expected length: 6680, found: 7326) |
| File size mismatch: /var/www/piwik/core/CliMulti/RequestCommand.php (expected length: 3731, found: 3739) |
| File size mismatch: /var/www/piwik/core/CliMulti/RequestParser.php (expected length: 2829, found: 3075) |
| File size mismatch: /var/www/piwik/core/CronArchive/FixedSiteIds.php (expected length: 1301, found: 1424) |
| File size mismatch: /var/www/piwik/core/CronArchive.php (expected length: 49111, found: 49415) |
| File size mismatch: /var/www/piwik/core/CronArchive/QueueConsumer.php (expected length: 21879, found: 23210) |
| File size mismatch: /var/www/piwik/core/CronArchive/SharedSiteIds.php (expected length: 5618, found: 6249) |
| File size mismatch: /var/www/piwik/core/DataAccess/RawLogDao.php (expected length: 16590, found: 16359) |
| Missing file: /var/www/piwik/core/DataFiles/cacert.pem |
| File size mismatch: /var/www/piwik/core/DataTable/Filter/CalculateEvolutionFilter.php (expected length: 6198, found: 6588) |
| File size mismatch: /var/www/piwik/core/DataTable.php (expected length: 68720, found: 68721) |
| File size mismatch: /var/www/piwik/core/Date.php (expected length: 33325, found: 35372) |
| File size mismatch: /var/www/piwik/core/ErrorHandler.php (expected length: 7383, found: 7735) |
| File size mismatch: /var/www/piwik/core/Filechecks.php (expected length: 7878, found: 8880) |
| File size mismatch: /var/www/piwik/core/Http.php (expected length: 40937, found: 41692) |
| File size mismatch: /var/www/piwik/core/Period/Factory.php (expected length: 6727, found: 6377) |
| File size mismatch: /var/www/piwik/core/Period/Range.php (expected length: 18576, found: 18643) |
| File size mismatch: /var/www/piwik/core/Plugin/ThemeStyles.php (expected length: 5958, found: 5957) |
| File size mismatch: /var/www/piwik/core/SettingsServer.php (expected length: 7034, found: 7134) |
| File size mismatch: /var/www/piwik/core/Tracker.php (expected length: 11329, found: 11109) |
| File size mismatch: /var/www/piwik/core/Tracker/VisitExcluded.php (expected length: 12008, found: 12007) |
| File size mismatch: /var/www/piwik/core/Tracker/Visit.php (expected length: 22707, found: 22167) |
| File size mismatch: /var/www/piwik/core/Version.php (expected length: 803, found: 806) |
| File size mismatch: /var/www/piwik/libs/Zend/Session/Exception.php (expected length: 2532, found: 2542) |
| File size mismatch: /var/www/piwik/plugins/API/Filter/DataComparisonFilter.php (expected length: 24124, found: 24012) |
| File size mismatch: /var/www/piwik/plugins/API/RowEvolution.php (expected length: 21160, found: 21091) |
| File size mismatch: /var/www/piwik/plugins/CoreAdminHome/Controller.php (expected length: 11293, found: 11378) |
| File size mismatch: /var/www/piwik/plugins/CoreAdminHome/templates/generalSettings.twig (expected length: 13331, found: 13394) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/common/services/periods.js (expected length: 11297, found: 11900) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/common/services/piwik.js (expected length: 3067, found: 2979) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/common/services/piwik-url.js (expected length: 999, found: 1281) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/comparisons/comparisons.service.spec.js (expected length: 24555, found: 24603) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/period-selector/period-selector.controller.js (expected length: 12964, found: 13359) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/reporting-page/reportingpage.controller.js (expected length: 5276, found: 6034) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/angularjs/siteselector/siteselector-model.service.js (expected length: 3614, found: 3862) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/CoreHome.php (expected length: 28117, found: 28170) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/javascripts/broadcast.js (expected length: 30906, found: 31100) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/javascripts/dataTable.js (expected length: 79632, found: 77361) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/javascripts/popover.js (expected length: 10937, found: 11074) |
| File size mismatch: /var/www/piwik/plugins/CoreHome/lang/en.json (expected length: 9057, found: 9182) |
| File size mismatch: /var/www/piwik/plugins/CoreUpdater/SystemSettings.php (expected length: 5393, found: 5351) |
| File size mismatch: /var/www/piwik/plugins/CoreUpdater/templates/newVersionAvailable.twig (expected length: 1973, found: 1934) |
| File size mismatch: /var/www/piwik/plugins/DevicesDetection/lang/el.json (expected length: 5221, found: 5271) |
| File size mismatch: /var/www/piwik/plugins/GeoIp2/Controller.php (expected length: 7876, found: 7883) |
| File size mismatch: /var/www/piwik/plugins/GeoIp2/GeoIP2AutoUpdater.php (expected length: 28291, found: 28577) |
| File size mismatch: /var/www/piwik/plugins/GeoIp2/LocationProvider/GeoIp2.php (expected length: 7492, found: 7516) |
| File size mismatch: /var/www/piwik/plugins/GeoIp2/LocationProvider/GeoIp2/ServerModule.php (expected length: 12662, found: 13057) |
| File size mismatch: /var/www/piwik/plugins/Goals/Goals.php (expected length: 15787, found: 15789) |
| File size mismatch: /var/www/piwik/plugins/PrivacyManager/Controller.php (expected length: 17349, found: 17658) |
| File size mismatch: /var/www/piwik/plugins/PrivacyManager/Model/DataSubjects.php (expected length: 20498, found: 20536) |
| File size mismatch: /var/www/piwik/plugins/Provider/Columns/Provider.php (expected length: 2917, found: 3402) |
| File size mismatch: /var/www/piwik/plugins/Referrers/angularjs/campaign-builder/campaign-builder.controller.js (expected length: 2937, found: 3114) |
| File size mismatch: /var/www/piwik/plugins/Referrers/angularjs/campaign-builder/campaign-builder.directive.html (expected length: 3593, found: 3939) |
| File size mismatch: /var/www/piwik/plugins/Referrers/API.php (expected length: 32210, found: 32232) |
| File size mismatch: /var/www/piwik/plugins/Referrers/lang/en.json (expected length: 7079, found: 7284) |
| File size mismatch: /var/www/piwik/plugins/Referrers/Referrers.php (expected length: 7503, found: 7613) |
| File size mismatch: /var/www/piwik/plugins/SEO/Metric/Alexa.php (expected length: 1652, found: 1702) |
| File size mismatch: /var/www/piwik/plugins/SEO/Metric/Bing.php (expected length: 1623, found: 1666) |
| File size mismatch: /var/www/piwik/plugins/SEO/Metric/DomainAge.php (expected length: 3719, found: 3716) |
| File size mismatch: /var/www/piwik/plugins/SEO/Metric/Google.php (expected length: 1684, found: 1727) |
| File size mismatch: /var/www/piwik/plugins/SitesManager/templates/siteWithoutData.twig (expected length: 6284, found: 6474) |
| File size mismatch: /var/www/piwik/plugins/SitesManager/templates/_trackingCodeEmail.twig (expected length: 2111, found: 2228) |
| File size mismatch: /var/www/piwik/plugins/TagManager/Dao/TagsDao.php (expected length: 9050, found: 9337) |
| File size mismatch: /var/www/piwik/plugins/Transitions/API.php (expected length: 27561, found: 27541) |
| Missing file: /var/www/piwik/plugins/UserCountry/Columns/Provider.php |
| File size mismatch: /var/www/piwik/plugins/UserCountry/Controller.php (expected length: 4129, found: 5686) |
| File size mismatch: /var/www/piwik/plugins/UserCountry/Diagnostic/GeolocationDiagnostic.php (expected length: 2620, found: 2766) |
| File size mismatch: /var/www/piwik/plugins/UserCountry/lang/en.json (expected length: 4293, found: 4610) |
| File size mismatch: /var/www/piwik/plugins/UserCountry/LocationProvider/DefaultProvider.php (expected length: 3269, found: 3661) |
| File size mismatch: /var/www/piwik/plugins/UserCountry/LocationProvider.php (expected length: 17699, found: 17985) |
| File size mismatch: /var/www/piwik/plugins/UsersManager/Model.php (expected length: 21596, found: 22050) |
| File size mismatch: /var/www/piwik/vendor/composer/autoload_classmap.php (expected length: 352857, found: 357794) |
| File size mismatch: /var/www/piwik/vendor/composer/autoload_namespaces.php (expected length: 822, found: 883) |
| File size mismatch: /var/www/piwik/vendor/composer/autoload_static.php (expected length: 398894, found: 404479) |
| Integrity check failed: /var/www/piwik/vendor/composer/include_paths.php |
| File size mismatch: /var/www/piwik/vendor/composer/installed.json (expected length: 87959, found: 89091) |
| File size mismatch: /var/www/piwik/vendor/composer/installed.php (expected length: 10492, found: 10496) |
| File size mismatch: /var/www/piwik/vendor/composer/InstalledVersions.php (expected length: 13351, found: 13355) |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/lessc.inc.php |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/lessify |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/lessify.inc.php |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/LICENSE |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/Makefile |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/package.sh |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/plessc |
| Missing file: /var/www/piwik/vendor/leafo/lessphp/README.md |