Matomo database will be upgraded from version 4.0.4 to the new version 4.13.3.
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 `matomo_archive_numeric_2008_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2022_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2023_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2023_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2023_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `matomo_archive_numeric_2023_04` SET `name` = 'done' WHERE `name` = 'done.'; ALTER TABLE `matomo_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`; ALTER TABLE `matomo_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 `matomo_session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run: ./console plugin:activate "CoreVue"
# These SQL queries will be executed: ALTER TABLE `matomo_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL; CREATE TABLE `matomo_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 `matomo_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL; ALTER TABLE `matomo_changes` DROP INDEX `unique_plugin_version_title`; ALTER TABLE `matomo_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100)); ALTER TABLE `matomo_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept'; ALTER TABLE `matomo_user` DROP COLUMN `invite_status`; ALTER TABLE `matomo_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null; ALTER TABLE `matomo_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null; ALTER TABLE `matomo_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null; ALTER TABLE `matomo_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null; ALTER TABLE `matomo_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`; ALTER TABLE `matomo_user` ADD UNIQUE KEY uniq_email (`email`); ALTER TABLE `matomo_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT 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: node_modules/jquery/external
To delete all these directories at once, you can run this command: rm -Rf /mnt/web113/a2/11/57601011/htdocs/safia/analytics/libs/bower_components /mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery/external
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <--
File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: misc/composer/build-xhprof.sh File to delete: misc/composer/clean-xhprof.sh File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: node_modules/jquery.dotdotdot/src/jquery.dotdotdot.min.js File to delete: node_modules/mousetrap/mousetrap.sublime-project File to delete: node_modules/ng-dialog/yarn.lock File to delete: package-lock.json File to delete: node_modules/chroma-js/.npmignore File to delete: node_modules/iframe-resizer/.eslintrc File to delete: node_modules/iframe-resizer/.ncurc.json File to delete: node_modules/iframe-resizer/.prettierrc File to delete: node_modules/jquery.browser/.npmignore File to delete: node_modules/jquery.dotdotdot/.npmignore File to delete: node_modules/jquery.scrollto/.jscsrc File to delete: node_modules/jquery.scrollto/.npmignore File to delete: node_modules/ng-dialog/.eslintrc File to delete: node_modules/ng-dialog/.npmignore File to delete: node_modules/qrcodejs2/.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 "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/config/environment/test.php" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/config/environment/ui-test.php" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/misc/composer/build-xhprof.sh" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/misc/composer/clean-xhprof.sh" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/misc/others/ExamplePiwikTracker.php" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/misc/others/uninstall-delete-piwik-directory.php" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery.dotdotdot/src/jquery.dotdotdot.min.js" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/mousetrap/mousetrap.sublime-project" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/ng-dialog/yarn.lock" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/package-lock.json" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/chroma-js/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/iframe-resizer/.eslintrc" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/iframe-resizer/.ncurc.json" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/iframe-resizer/.prettierrc" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery.browser/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery.dotdotdot/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery.scrollto/.jscsrc" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/jquery.scrollto/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/ng-dialog/.eslintrc" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/ng-dialog/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/node_modules/qrcodejs2/.npmignore" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/vendor/php-di/php-di/.gitstats.yml" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/vendor/php-di/php-di/.phpstorm.meta.php" "/mnt/web113/a2/11/57601011/htdocs/safia/analytics/vendor/twig/twig/.php_cs.dist"