Database Upgrade Required

The following plugins will be updated: TagManager.

The following dimensions will be updated: log_conversion.pageviews_before.

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/vhosts/hochoertler.at/statistik.hochoertler.at/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.2.1

› 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_tagmanager_container` ADD COLUMN `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ignoreGtmDataLayer`;
ALTER TABLE `piwik_tagmanager_container` CHANGE `activelySyncGtmDataLayer` `activelySyncGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE `piwik_tagmanager_container_version` CHANGE `name` `name` VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE `piwik_tagmanager_container` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `piwik_tagmanager_tag` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `piwik_tagmanager_trigger` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `piwik_tagmanager_variable` CHANGE `name` `name` VARCHAR(255) NOT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `pageviews_before` SMALLINT UNSIGNED 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.