Matomo database will be upgraded from version 3.14.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_visit.config_browser_name, log_visit.config_client_type, log_visit.location_region, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits.
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 /home/speedtrack/public_html/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 console commands will be run:
./console core:matomo4-migrate-token-auths
# These SQL queries will be executed:
CREATE TABLE `spdtrk_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 `spdtrk_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);
ALTER TABLE `spdtrk_user` DROP COLUMN `alias`;
DELETE FROM `spdtrk_session` WHERE length(id) > 190;
ALTER TABLE `spdtrk_session` CHANGE `id` `id` VARCHAR(191);
ALTER TABLE `spdtrk_site_url` CHANGE `url` `url` VARCHAR(190);
ALTER TABLE `spdtrk_option` CHANGE `option_name` `option_name` VARCHAR(191);
ALTER TABLE `spdtrk_log_action` CHANGE `name` `name` VARCHAR(4096);
ALTER TABLE `spdtrk_log_conversion` CHANGE `url` `url` VARCHAR(4096);
ALTER TABLE `spdtrk_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 `spdtrk_archive_invalidations` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2008_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_numeric_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_archive_blob_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `spdtrk_log_link_visit_action` ;
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');
ALTER TABLE `spdtrk_log_visit` ;
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');
ALTER TABLE `spdtrk_log_conversion` ;
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `spdtrk_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');
UPDATE spdtrk_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';
# These console commands will be run:
./console plugin:activate "GeoIp2"
# These SQL queries will be executed:
DELETE FROM `spdtrk_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");
UPDATE spdtrk_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 spdtrk_log_conversion SET visitor_seconds_since_first = visitor_days_since_first * 86400, visitor_seconds_since_order = visitor_days_since_order * 86400;
ALTER TABLE `spdtrk_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 `spdtrk_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 `spdtrk_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 spdtrk_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 `spdtrk_log_visit` 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, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `spdtrk_log_conversion` 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 `spdtrk_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. |
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <-- Directory to delete: libs/bower_components Directory to delete: vendor/aws Directory to delete: vendor/container-interop Directory to delete: vendor/facebook Directory to delete: vendor/guzzle Directory to delete: vendor/leafo Directory to delete: vendor/phpdocumentor Directory to delete: vendor/phpseclib Directory to delete: vendor/phpspec Directory to delete: vendor/phpunit Directory to delete: vendor/piwik Directory to delete: vendor/sebastian Directory to delete: vendor/symfony/var-dumper Directory to delete: vendor/symfony/yaml Directory to delete: vendor/twig/twig/ext Directory to delete: vendor/webmozart To delete all these directories at once, you can run this command: rm -Rf /home/speedtrack/public_html/libs/bower_components /home/speedtrack/public_html/vendor/aws /home/speedtrack/public_html/vendor/container-interop /home/speedtrack/public_html/vendor/facebook /home/speedtrack/public_html/vendor/guzzle /home/speedtrack/public_html/vendor/leafo /home/speedtrack/public_html/vendor/phpdocumentor /home/speedtrack/public_html/vendor/phpseclib /home/speedtrack/public_html/vendor/phpspec /home/speedtrack/public_html/vendor/phpunit /home/speedtrack/public_html/vendor/piwik /home/speedtrack/public_html/vendor/sebastian /home/speedtrack/public_html/vendor/symfony/var-dumper /home/speedtrack/public_html/vendor/symfony/yaml /home/speedtrack/public_html/vendor/twig/twig/ext /home/speedtrack/public_html/vendor/webmozart |
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: composer.phar File to delete: lookupcountry.php 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/download-count.txt File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/stress.sh File to delete: misc/others/widget_example_lastvisits.html File to delete: stats/ctry_usage_201805.png File to delete: stats/ctry_usage_201806.png File to delete: stats/ctry_usage_201807.png File to delete: stats/ctry_usage_201808.png File to delete: stats/ctry_usage_201809.png File to delete: stats/ctry_usage_201810.png File to delete: stats/ctry_usage_201811.png File to delete: stats/ctry_usage_201812.png File to delete: stats/ctry_usage_201901.png File to delete: stats/ctry_usage_201902.png File to delete: stats/ctry_usage_201903.png File to delete: stats/ctry_usage_201904.png File to delete: stats/ctry_usage_201905.png File to delete: stats/ctry_usage_201906.png File to delete: stats/ctry_usage_201907.png File to delete: stats/ctry_usage_201908.png File to delete: stats/ctry_usage_201909.png File to delete: stats/ctry_usage_201910.png File to delete: stats/ctry_usage_201911.png File to delete: stats/ctry_usage_201912.png File to delete: stats/ctry_usage_202001.png File to delete: stats/ctry_usage_202002.png File to delete: stats/ctry_usage_202003.png File to delete: stats/ctry_usage_202004.png File to delete: stats/ctry_usage_202005.png File to delete: stats/ctry_usage_202006.png File to delete: stats/ctry_usage_202007.png File to delete: stats/ctry_usage_202008.png File to delete: stats/ctry_usage_202009.png File to delete: stats/ctry_usage_202010.png File to delete: stats/ctry_usage_202011.png File to delete: stats/ctry_usage_202012.png File to delete: stats/ctry_usage_202101.png File to delete: stats/daily_usage_201805.png File to delete: stats/daily_usage_201806.png File to delete: stats/daily_usage_201807.png File to delete: stats/daily_usage_201808.png File to delete: stats/daily_usage_201809.png File to delete: stats/daily_usage_201810.png File to delete: stats/daily_usage_201811.png File to delete: stats/daily_usage_201812.png File to delete: stats/daily_usage_201901.png File to delete: stats/daily_usage_201902.png File to delete: stats/daily_usage_201903.png File to delete: stats/daily_usage_201904.png File to delete: stats/daily_usage_201905.png File to delete: stats/daily_usage_201906.png File to delete: stats/daily_usage_201907.png File to delete: stats/daily_usage_201908.png File to delete: stats/daily_usage_201909.png File to delete: stats/daily_usage_201910.png File to delete: stats/daily_usage_201911.png File to delete: stats/daily_usage_201912.png File to delete: stats/daily_usage_202001.png File to delete: stats/daily_usage_202002.png File to delete: stats/daily_usage_202003.png File to delete: stats/daily_usage_202004.png File to delete: stats/daily_usage_202005.png File to delete: stats/daily_usage_202006.png File to delete: stats/daily_usage_202007.png File to delete: stats/daily_usage_202008.png File to delete: stats/daily_usage_202009.png File to delete: stats/daily_usage_202010.png File to delete: stats/daily_usage_202011.png File to delete: stats/daily_usage_202012.png File to delete: stats/daily_usage_202101.png File to delete: stats/dns_cache.db File to delete: stats/hourly_usage_201805.png File to delete: stats/hourly_usage_201806.png File to delete: stats/hourly_usage_201807.png File to delete: stats/hourly_usage_201808.png File to delete: stats/hourly_usage_201809.png File to delete: stats/hourly_usage_201810.png File to delete: stats/hourly_usage_201811.png File to delete: stats/hourly_usage_201812.png File to delete: stats/hourly_usage_201901.png File to delete: stats/hourly_usage_201902.png File to delete: stats/hourly_usage_201903.png File to delete: stats/hourly_usage_201904.png File to delete: stats/hourly_usage_201905.png File to delete: stats/hourly_usage_201906.png File to delete: stats/hourly_usage_201907.png File to delete: stats/hourly_usage_201908.png File to delete: stats/hourly_usage_201909.png File to delete: stats/hourly_usage_201910.png File to delete: stats/hourly_usage_201911.png File to delete: stats/hourly_usage_201912.png File to delete: stats/hourly_usage_202001.png File to delete: stats/hourly_usage_202002.png File to delete: stats/hourly_usage_202003.png File to delete: stats/hourly_usage_202004.png File to delete: stats/hourly_usage_202005.png File to delete: stats/hourly_usage_202006.png File to delete: stats/hourly_usage_202007.png File to delete: stats/hourly_usage_202008.png File to delete: stats/hourly_usage_202009.png File to delete: stats/hourly_usage_202010.png File to delete: stats/hourly_usage_202011.png File to delete: stats/hourly_usage_202012.png File to delete: stats/hourly_usage_202101.png File to delete: stats/index.html File to delete: stats/usage.png File to delete: stats/usage_201805.html File to delete: stats/usage_201806.html File to delete: stats/usage_201807.html File to delete: stats/usage_201808.html File to delete: stats/usage_201809.html File to delete: stats/usage_201810.html File to delete: stats/usage_201811.html File to delete: stats/usage_201812.html File to delete: stats/usage_201901.html File to delete: stats/usage_201902.html File to delete: stats/usage_201903.html File to delete: stats/usage_201904.html File to delete: stats/usage_201905.html File to delete: stats/usage_201906.html File to delete: stats/usage_201907.html File to delete: stats/usage_201908.html File to delete: stats/usage_201909.html File to delete: stats/usage_201910.html File to delete: stats/usage_201911.html File to delete: stats/usage_201912.html File to delete: stats/usage_202001.html File to delete: stats/usage_202002.html File to delete: stats/usage_202003.html File to delete: stats/usage_202004.html File to delete: stats/usage_202005.html File to delete: stats/usage_202006.html File to delete: stats/usage_202007.html File to delete: stats/usage_202008.html File to delete: stats/usage_202009.html File to delete: stats/usage_202010.html File to delete: stats/usage_202011.html File to delete: stats/usage_202012.html File to delete: stats/usage_202101.html File to delete: stats/webalizer.current File to delete: stats/webalizer.hist File to delete: vendor/bin/lessc File to delete: vendor/davaxi/sparkline/.codeclimate.yml File to delete: vendor/doctrine/instantiator/.travis.install.sh File to delete: vendor/geoip2/geoip2/.php_cs To delete all these files at once, you can run this command: rm "/home/speedtrack/public_html/bower.json" "/home/speedtrack/public_html/composer.json" "/home/speedtrack/public_html/composer.lock" "/home/speedtrack/public_html/composer.phar" "/home/speedtrack/public_html/lookupcountry.php" "/home/speedtrack/public_html/misc/gpl-3.0.txt" "/home/speedtrack/public_html/misc/internal-docs/content-tracking.md" "/home/speedtrack/public_html/misc/others/ExamplePiwikTracker.php" "/home/speedtrack/public_html/misc/others/api_internal_call.php" "/home/speedtrack/public_html/misc/others/api_rest_call.php" "/home/speedtrack/public_html/misc/others/download-count.txt" "/home/speedtrack/public_html/misc/others/iframeWidget_localhost.php" "/home/speedtrack/public_html/misc/others/stress.sh" "/home/speedtrack/public_html/misc/others/widget_example_lastvisits.html" "/home/speedtrack/public_html/stats/ctry_usage_201805.png" "/home/speedtrack/public_html/stats/ctry_usage_201806.png" "/home/speedtrack/public_html/stats/ctry_usage_201807.png" "/home/speedtrack/public_html/stats/ctry_usage_201808.png" "/home/speedtrack/public_html/stats/ctry_usage_201809.png" "/home/speedtrack/public_html/stats/ctry_usage_201810.png" "/home/speedtrack/public_html/stats/ctry_usage_201811.png" "/home/speedtrack/public_html/stats/ctry_usage_201812.png" "/home/speedtrack/public_html/stats/ctry_usage_201901.png" "/home/speedtrack/public_html/stats/ctry_usage_201902.png" "/home/speedtrack/public_html/stats/ctry_usage_201903.png" "/home/speedtrack/public_html/stats/ctry_usage_201904.png" "/home/speedtrack/public_html/stats/ctry_usage_201905.png" "/home/speedtrack/public_html/stats/ctry_usage_201906.png" "/home/speedtrack/public_html/stats/ctry_usage_201907.png" "/home/speedtrack/public_html/stats/ctry_usage_201908.png" "/home/speedtrack/public_html/stats/ctry_usage_201909.png" "/home/speedtrack/public_html/stats/ctry_usage_201910.png" "/home/speedtrack/public_html/stats/ctry_usage_201911.png" "/home/speedtrack/public_html/stats/ctry_usage_201912.png" "/home/speedtrack/public_html/stats/ctry_usage_202001.png" "/home/speedtrack/public_html/stats/ctry_usage_202002.png" "/home/speedtrack/public_html/stats/ctry_usage_202003.png" "/home/speedtrack/public_html/stats/ctry_usage_202004.png" "/home/speedtrack/public_html/stats/ctry_usage_202005.png" "/home/speedtrack/public_html/stats/ctry_usage_202006.png" "/home/speedtrack/public_html/stats/ctry_usage_202007.png" "/home/speedtrack/public_html/stats/ctry_usage_202008.png" "/home/speedtrack/public_html/stats/ctry_usage_202009.png" "/home/speedtrack/public_html/stats/ctry_usage_202010.png" "/home/speedtrack/public_html/stats/ctry_usage_202011.png" "/home/speedtrack/public_html/stats/ctry_usage_202012.png" "/home/speedtrack/public_html/stats/ctry_usage_202101.png" "/home/speedtrack/public_html/stats/daily_usage_201805.png" "/home/speedtrack/public_html/stats/daily_usage_201806.png" "/home/speedtrack/public_html/stats/daily_usage_201807.png" rm "/home/speedtrack/public_html/stats/daily_usage_201808.png" "/home/speedtrack/public_html/stats/daily_usage_201809.png" "/home/speedtrack/public_html/stats/daily_usage_201810.png" "/home/speedtrack/public_html/stats/daily_usage_201811.png" "/home/speedtrack/public_html/stats/daily_usage_201812.png" "/home/speedtrack/public_html/stats/daily_usage_201901.png" "/home/speedtrack/public_html/stats/daily_usage_201902.png" "/home/speedtrack/public_html/stats/daily_usage_201903.png" "/home/speedtrack/public_html/stats/daily_usage_201904.png" "/home/speedtrack/public_html/stats/daily_usage_201905.png" "/home/speedtrack/public_html/stats/daily_usage_201906.png" "/home/speedtrack/public_html/stats/daily_usage_201907.png" "/home/speedtrack/public_html/stats/daily_usage_201908.png" "/home/speedtrack/public_html/stats/daily_usage_201909.png" "/home/speedtrack/public_html/stats/daily_usage_201910.png" "/home/speedtrack/public_html/stats/daily_usage_201911.png" "/home/speedtrack/public_html/stats/daily_usage_201912.png" "/home/speedtrack/public_html/stats/daily_usage_202001.png" "/home/speedtrack/public_html/stats/daily_usage_202002.png" "/home/speedtrack/public_html/stats/daily_usage_202003.png" "/home/speedtrack/public_html/stats/daily_usage_202004.png" "/home/speedtrack/public_html/stats/daily_usage_202005.png" "/home/speedtrack/public_html/stats/daily_usage_202006.png" "/home/speedtrack/public_html/stats/daily_usage_202007.png" "/home/speedtrack/public_html/stats/daily_usage_202008.png" "/home/speedtrack/public_html/stats/daily_usage_202009.png" "/home/speedtrack/public_html/stats/daily_usage_202010.png" "/home/speedtrack/public_html/stats/daily_usage_202011.png" "/home/speedtrack/public_html/stats/daily_usage_202012.png" "/home/speedtrack/public_html/stats/daily_usage_202101.png" "/home/speedtrack/public_html/stats/dns_cache.db" "/home/speedtrack/public_html/stats/hourly_usage_201805.png" "/home/speedtrack/public_html/stats/hourly_usage_201806.png" "/home/speedtrack/public_html/stats/hourly_usage_201807.png" "/home/speedtrack/public_html/stats/hourly_usage_201808.png" "/home/speedtrack/public_html/stats/hourly_usage_201809.png" "/home/speedtrack/public_html/stats/hourly_usage_201810.png" "/home/speedtrack/public_html/stats/hourly_usage_201811.png" "/home/speedtrack/public_html/stats/hourly_usage_201812.png" "/home/speedtrack/public_html/stats/hourly_usage_201901.png" "/home/speedtrack/public_html/stats/hourly_usage_201902.png" "/home/speedtrack/public_html/stats/hourly_usage_201903.png" "/home/speedtrack/public_html/stats/hourly_usage_201904.png" "/home/speedtrack/public_html/stats/hourly_usage_201905.png" "/home/speedtrack/public_html/stats/hourly_usage_201906.png" "/home/speedtrack/public_html/stats/hourly_usage_201907.png" "/home/speedtrack/public_html/stats/hourly_usage_201908.png" "/home/speedtrack/public_html/stats/hourly_usage_201909.png" "/home/speedtrack/public_html/stats/hourly_usage_201910.png" "/home/speedtrack/public_html/stats/hourly_usage_201911.png" rm "/home/speedtrack/public_html/stats/hourly_usage_201912.png" "/home/speedtrack/public_html/stats/hourly_usage_202001.png" "/home/speedtrack/public_html/stats/hourly_usage_202002.png" "/home/speedtrack/public_html/stats/hourly_usage_202003.png" "/home/speedtrack/public_html/stats/hourly_usage_202004.png" "/home/speedtrack/public_html/stats/hourly_usage_202005.png" "/home/speedtrack/public_html/stats/hourly_usage_202006.png" "/home/speedtrack/public_html/stats/hourly_usage_202007.png" "/home/speedtrack/public_html/stats/hourly_usage_202008.png" "/home/speedtrack/public_html/stats/hourly_usage_202009.png" "/home/speedtrack/public_html/stats/hourly_usage_202010.png" "/home/speedtrack/public_html/stats/hourly_usage_202011.png" "/home/speedtrack/public_html/stats/hourly_usage_202012.png" "/home/speedtrack/public_html/stats/hourly_usage_202101.png" "/home/speedtrack/public_html/stats/index.html" "/home/speedtrack/public_html/stats/usage.png" "/home/speedtrack/public_html/stats/usage_201805.html" "/home/speedtrack/public_html/stats/usage_201806.html" "/home/speedtrack/public_html/stats/usage_201807.html" "/home/speedtrack/public_html/stats/usage_201808.html" "/home/speedtrack/public_html/stats/usage_201809.html" "/home/speedtrack/public_html/stats/usage_201810.html" "/home/speedtrack/public_html/stats/usage_201811.html" "/home/speedtrack/public_html/stats/usage_201812.html" "/home/speedtrack/public_html/stats/usage_201901.html" "/home/speedtrack/public_html/stats/usage_201902.html" "/home/speedtrack/public_html/stats/usage_201903.html" "/home/speedtrack/public_html/stats/usage_201904.html" "/home/speedtrack/public_html/stats/usage_201905.html" "/home/speedtrack/public_html/stats/usage_201906.html" "/home/speedtrack/public_html/stats/usage_201907.html" "/home/speedtrack/public_html/stats/usage_201908.html" "/home/speedtrack/public_html/stats/usage_201909.html" "/home/speedtrack/public_html/stats/usage_201910.html" "/home/speedtrack/public_html/stats/usage_201911.html" "/home/speedtrack/public_html/stats/usage_201912.html" "/home/speedtrack/public_html/stats/usage_202001.html" "/home/speedtrack/public_html/stats/usage_202002.html" "/home/speedtrack/public_html/stats/usage_202003.html" "/home/speedtrack/public_html/stats/usage_202004.html" "/home/speedtrack/public_html/stats/usage_202005.html" "/home/speedtrack/public_html/stats/usage_202006.html" "/home/speedtrack/public_html/stats/usage_202007.html" "/home/speedtrack/public_html/stats/usage_202008.html" "/home/speedtrack/public_html/stats/usage_202009.html" "/home/speedtrack/public_html/stats/usage_202010.html" "/home/speedtrack/public_html/stats/usage_202011.html" "/home/speedtrack/public_html/stats/usage_202012.html" "/home/speedtrack/public_html/stats/usage_202101.html" "/home/speedtrack/public_html/stats/webalizer.current" rm "/home/speedtrack/public_html/stats/webalizer.hist" "/home/speedtrack/public_html/vendor/bin/lessc" "/home/speedtrack/public_html/vendor/davaxi/sparkline/.codeclimate.yml" "/home/speedtrack/public_html/vendor/doctrine/instantiator/.travis.install.sh" "/home/speedtrack/public_html/vendor/geoip2/geoip2/.php_cs" |