Matomo database will be upgraded from version 4.0.1-b1 to the new version 4.13.2.
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.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:
# These SQL queries will be executed: UPDATE `piwik_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2022_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2022_02` SET `name` = 'done' WHERE `name` = 'done.'; ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`; ALTER TABLE `piwik_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;
# These console commands will be run: ./console config:set --section="General" --key="login_allow_logme" --value="1"
# These SQL queries will be executed: ALTER TABLE `piwik_session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run: ./console plugin:activate "CoreVue"
# These SQL queries will be executed: ALTER TABLE `piwik_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL; CREATE TABLE `piwik_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `piwik_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL; ALTER TABLE `piwik_changes` DROP INDEX `unique_plugin_version_title`; ALTER TABLE `piwik_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100)); ALTER TABLE `piwik_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept'; ALTER TABLE `piwik_user` DROP COLUMN `invite_status`; ALTER TABLE `piwik_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null; ALTER TABLE `piwik_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null; ALTER TABLE `piwik_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null; ALTER TABLE `piwik_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null; ALTER TABLE `piwik_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`; ALTER TABLE `piwik_user` ADD UNIQUE KEY uniq_email (`email`); ALTER TABLE `piwik_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT null; ALTER TABLE `piwik_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; ALTER TABLE `piwik_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; 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;
The database upgrade process may take a while, so please be patient.
File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error.
File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error.
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <--
Directory to delete: libs/bower_components Directory to delete: vendor/container-interop Directory to delete: vendor/doctrine Directory to delete: vendor/leafo Directory to delete: vendor/mnapoli Directory to delete: vendor/piwik Directory to delete: vendor/tecnick.com Directory to delete: vendor/twig/twig/ext
To delete all these directories at once, you can run this command: rm -Rf /www/htdocs/v118081/piwik.mjot.de/libs/bower_components /www/htdocs/v118081/piwik.mjot.de/vendor/container-interop /www/htdocs/v118081/piwik.mjot.de/vendor/doctrine /www/htdocs/v118081/piwik.mjot.de/vendor/leafo /www/htdocs/v118081/piwik.mjot.de/vendor/mnapoli /www/htdocs/v118081/piwik.mjot.de/vendor/piwik /www/htdocs/v118081/piwik.mjot.de/vendor/tecnick.com /www/htdocs/v118081/piwik.mjot.de/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: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: index.htm File to delete: misc/How to install Piwik.html File to delete: misc/composer/build-xhprof.sh File to delete: misc/composer/clean-xhprof.sh 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.htm File to delete: misc/others/iframeWidget_localhost.php 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: vendor/monolog/monolog/.php_cs File to delete: vendor/pear/archive_tar/.travis.sh File to delete: vendor/php-di/php-di/.phpstorm.meta.php File to delete: vendor/twig/twig/.editorconfig File to delete: vendor/twig/twig/.php_cs.dist
To delete all these files at once, you can run this command: rm "/www/htdocs/v118081/piwik.mjot.de/bower.json" "/www/htdocs/v118081/piwik.mjot.de/composer.json" "/www/htdocs/v118081/piwik.mjot.de/composer.lock" "/www/htdocs/v118081/piwik.mjot.de/config/environment/test.php" "/www/htdocs/v118081/piwik.mjot.de/config/environment/ui-test.php" "/www/htdocs/v118081/piwik.mjot.de/index.htm" "/www/htdocs/v118081/piwik.mjot.de/misc/How to install Piwik.html" "/www/htdocs/v118081/piwik.mjot.de/misc/composer/build-xhprof.sh" "/www/htdocs/v118081/piwik.mjot.de/misc/composer/clean-xhprof.sh" "/www/htdocs/v118081/piwik.mjot.de/misc/gpl-3.0.txt" "/www/htdocs/v118081/piwik.mjot.de/misc/internal-docs/content-tracking.md" "/www/htdocs/v118081/piwik.mjot.de/misc/others/ExamplePiwikTracker.php" "/www/htdocs/v118081/piwik.mjot.de/misc/others/api_internal_call.php" "/www/htdocs/v118081/piwik.mjot.de/misc/others/api_rest_call.php" "/www/htdocs/v118081/piwik.mjot.de/misc/others/download-count.txt" "/www/htdocs/v118081/piwik.mjot.de/misc/others/iframeWidget.htm" "/www/htdocs/v118081/piwik.mjot.de/misc/others/iframeWidget_localhost.php" "/www/htdocs/v118081/piwik.mjot.de/misc/others/stress.sh" "/www/htdocs/v118081/piwik.mjot.de/misc/others/uninstall-delete-piwik-directory.php" "/www/htdocs/v118081/piwik.mjot.de/misc/others/widget_example_lastvisits.html" "/www/htdocs/v118081/piwik.mjot.de/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/www/htdocs/v118081/piwik.mjot.de/misc/phpstorm-codestyles/README.md" "/www/htdocs/v118081/piwik.mjot.de/vendor/monolog/monolog/.php_cs" "/www/htdocs/v118081/piwik.mjot.de/vendor/pear/archive_tar/.travis.sh" "/www/htdocs/v118081/piwik.mjot.de/vendor/php-di/php-di/.phpstorm.meta.php" "/www/htdocs/v118081/piwik.mjot.de/vendor/twig/twig/.editorconfig" "/www/htdocs/v118081/piwik.mjot.de/vendor/twig/twig/.php_cs.dist"