Matomo database will be upgraded from version 4.1.1 to the new version 4.6.0.
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_2016_01` 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_2020_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwik_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.'; ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`; UPDATE `piwik_segment` SET `hash` = 'e8c5462c1ba566232bc993b7ca65ad31' WHERE `idsegment` = '1'; 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"
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.
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <--
File to delete: misc/composer/build-xhprof.sh File to delete: misc/composer/clean-xhprof.sh File to delete: package-lock.json File to delete: vendor/lox/xhprof/bin/xhprofile File to delete: node_modules/jquery.dotdotdot/.npmignore File to delete: vendor/php-di/php-di/.gitstats.yml File to delete: vendor/php-di/php-di/.phpstorm.meta.php File to delete: vendor/twig/twig/.php_cs.dist
To delete all these files at once, you can run this command: rm "/var/www/analytics/matomo/misc/composer/build-xhprof.sh" "/var/www/analytics/matomo/misc/composer/clean-xhprof.sh" "/var/www/analytics/matomo/package-lock.json" "/var/www/analytics/matomo/vendor/lox/xhprof/bin/xhprofile" "/var/www/analytics/matomo/node_modules/jquery.dotdotdot/.npmignore" "/var/www/analytics/matomo/vendor/php-di/php-di/.gitstats.yml" "/var/www/analytics/matomo/vendor/php-di/php-di/.phpstorm.meta.php" "/var/www/analytics/matomo/vendor/twig/twig/.php_cs.dist"