Matomo › Update

Matomo database will be upgraded from version 4.6.2 to the new version 4.12.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:

php /var/www/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.12.3

› Click here to view and copy the list of SQL queries and console commands that will get executed

# These SQL queries will be executed: 
ALTER TABLE `matomo42_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `matomo42_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=utf8mb4 ROW_FORMAT=DYNAMIC;
ALTER TABLE `matomo42_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `matomo42_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `matomo42_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
ALTER TABLE `matomo42_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `matomo42_user` DROP COLUMN `invite_status`;
ALTER TABLE `matomo42_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `matomo42_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `matomo42_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `matomo42_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `matomo42_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`;
ALTER TABLE `matomo42_user` ADD UNIQUE KEY uniq_email (`email`);
ALTER TABLE `matomo42_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT 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.

Database Upgrade Required

Important notes for large Matomo installations

Need help upgrading Matomo?

Ready to go?