Matomo database will be upgraded from version 4.0.1-b1 to the new version 4.2.1.
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 /mnt/web008/e3/48/551948/htdocs/Piwik_01/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.2.1
› 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 plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"
# These SQL queries will be executed:
UPDATE `archive_numeric_2013_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2013_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2014_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2014_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2014_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2014_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2014_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2015_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `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 `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 `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/angularjs Directory to delete: libs/bower_components Directory to delete: themes Directory to delete: vendor/container-interop Directory to delete: vendor/leafo Directory to delete: vendor/mnapoli Directory to delete: vendor/myclabs Directory to delete: vendor/piwik Directory to delete: vendor/symfony/yaml Directory to delete: vendor/twig/twig/ext To delete all these directories at once, you can run this command: rm -Rf /mnt/web008/e3/48/551948/htdocs/Piwik_01/libs/angularjs /mnt/web008/e3/48/551948/htdocs/Piwik_01/libs/bower_components /mnt/web008/e3/48/551948/htdocs/Piwik_01/themes /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/container-interop /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/leafo /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/mnapoli /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/myclabs /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/piwik /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/symfony/yaml /mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/twig/twig/ext |
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: PULL_REQUEST_TEMPLATE File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/config.ini.sample.php File to delete: config/global.ini.auto-backup-before-update.php File to delete: lang/am.php File to delete: lang/ar.php File to delete: lang/be.php File to delete: lang/bg.php File to delete: lang/ca.php File to delete: lang/cs.php File to delete: lang/cy.php File to delete: lang/da.php File to delete: lang/de.php File to delete: lang/el.php File to delete: lang/en.php File to delete: lang/es.php File to delete: lang/et.php File to delete: lang/eu.php File to delete: lang/fa.php File to delete: lang/fi.php File to delete: lang/fr.php File to delete: lang/gl.php File to delete: lang/he.php File to delete: lang/hr.php File to delete: lang/hu.php File to delete: lang/id.php File to delete: lang/is.php File to delete: lang/it.php File to delete: lang/ja.php File to delete: lang/ka.php File to delete: lang/ko.php File to delete: lang/lt.php File to delete: lang/lv.php File to delete: lang/nb.php File to delete: lang/nl.php File to delete: lang/nn.php File to delete: lang/pl.php File to delete: lang/pt-br.php File to delete: lang/pt.php File to delete: lang/ro.php File to delete: lang/ru.php File to delete: lang/sk.php File to delete: lang/sl.php File to delete: lang/sq.php File to delete: lang/sr.php File to delete: lang/sv.php File to delete: lang/te.php File to delete: lang/th.php File to delete: lang/tr.php File to delete: lang/uk.php File to delete: lang/zh-cn.php File to delete: lang/zh-tw.php File to delete: misc/How to install Piwik.html File to delete: misc/cron/archive.windows.ps1 File to delete: misc/gpl-3.0.txt File to delete: misc/internal-docs/content-tracking.md File to delete: misc/license.txt File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/api_internal_call.php File to delete: misc/others/api_rest_call.php File to delete: misc/others/cli-script-bootstrap.php File to delete: misc/others/crossdomain.xml File to delete: misc/others/download-count.txt File to delete: misc/others/generateDoc.bat File to delete: misc/others/generateDoc.sh File to delete: misc/others/iframeWidget.htm File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/phpdoc-config.ini File to delete: misc/others/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/others/phpstorm-codestyles/README.md File to delete: misc/others/stress.sh File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: misc/others/widget_example_lastvisits.html File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: misc/proxy-hide-piwik-url/piwik.php File to delete: vendor/pear/archive_tar/.travis.sh File to delete: vendor/twig/twig/.editorconfig To delete all these files at once, you can run this command: rm "/mnt/web008/e3/48/551948/htdocs/Piwik_01/PULL_REQUEST_TEMPLATE" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/bower.json" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/composer.json" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/composer.lock" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/config/config.ini.sample.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/config/global.ini.auto-backup-before-update.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/am.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ar.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/be.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/bg.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ca.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/cs.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/cy.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/da.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/de.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/el.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/en.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/es.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/et.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/eu.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/fa.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/fi.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/fr.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/gl.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/he.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/hr.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/hu.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/id.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/is.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/it.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ja.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ka.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ko.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/lt.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/lv.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/nb.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/nl.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/nn.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/pl.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/pt-br.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/pt.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ro.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/ru.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/sk.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/sl.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/sq.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/sr.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/sv.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/te.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/th.php" rm "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/tr.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/uk.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/zh-cn.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/lang/zh-tw.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/How to install Piwik.html" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/cron/archive.windows.ps1" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/gpl-3.0.txt" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/internal-docs/content-tracking.md" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/license.txt" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/ExamplePiwikTracker.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/api_internal_call.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/api_rest_call.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/cli-script-bootstrap.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/crossdomain.xml" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/download-count.txt" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/generateDoc.bat" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/generateDoc.sh" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/iframeWidget.htm" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/iframeWidget_localhost.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/phpdoc-config.ini" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/phpstorm-codestyles/README.md" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/stress.sh" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/uninstall-delete-piwik-directory.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/others/widget_example_lastvisits.html" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/phpstorm-codestyles/README.md" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/misc/proxy-hide-piwik-url/piwik.php" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/pear/archive_tar/.travis.sh" "/mnt/web008/e3/48/551948/htdocs/Piwik_01/vendor/twig/twig/.editorconfig" |