Matomo database will be upgraded from version 5.1.2 to the new version 5.3.1.
The following plugins will be updated: TagManager.
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/analytics.sensemakers.nl/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 5.3.1
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These console commands will be run:
./console core:invalidate-report-data --dates=2025-04-01,today --plugin=Actions.Actions_hits
# These SQL queries will be executed:
ALTER TABLE `seo_archive_invalidations` ADD COLUMN `processing_host` VARCHAR(100) NULL DEFAULT NULL, ADD COLUMN `process_id` VARCHAR(15) NULL DEFAULT NULL;
# These console commands will be run:
./console featureflags:delete ImprovedAllWebsitesDashboard
# These SQL queries will be executed:
ALTER TABLE `seo_tagmanager_container` ADD COLUMN `isTagFireLimitAllowedInPreviewMode` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ignoreGtmDataLayer`;
ALTER TABLE `seo_tagmanager_container_version` CHANGE `name` `name` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `seo_tagmanager_container` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_tag` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_trigger` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_variable` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_container` ADD COLUMN `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ignoreGtmDataLayer`;
ALTER TABLE `seo_tagmanager_container` CHANGE `activelySyncGtmDataLayer` `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE `seo_tagmanager_container_version` CHANGE `name` `name` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `seo_tagmanager_container` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_tag` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_trigger` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `seo_tagmanager_variable` CHANGE `name` `name` VARCHAR(255) NOT 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.
Details
