Database Upgrade Required

Matomo database will be upgraded from version 4.10.1 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:

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.13.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 `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;

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.