Matomo database will be upgraded from version 4.4.1 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 `session` CHANGE `data` `data` MEDIUMTEXT;
# These console commands will be run:
./console plugin:activate "CoreVue"
# These SQL queries will be executed:
ALTER TABLE `user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `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 `changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
ALTER TABLE `user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `user` DROP COLUMN `invite_status`;
ALTER TABLE `user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`;
ALTER TABLE `user` ADD UNIQUE KEY uniq_email (`email`);
ALTER TABLE `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.
