The following plugins will be updated: CustomDimensions.
The following dimensions will be updated: log_conversion.pageviews_before, log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.product_price, log_visit.config_browser_name, log_visit.config_client_type, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits.
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/media-hannover.de/analytics.media-hannover.de/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_custom_dimensions` ADD COLUMN `case_sensitive` TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER `extractions`;
ALTER TABLE `piwik_custom_dimensions` DROP INDEX `idcustomdimension_idsite`;
ALTER TABLE `piwik_custom_dimensions` ADD PRIMARY KEY(`idcustomdimension`, `idsite`);
ALTER TABLE `piwik_log_visit` MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED 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
| File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error. |
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <--
Directory to delete: vendor/doctrine
To delete all these directories at once, you can run this command: rm -Rf /var/www/vhosts/media-hannover.de/analytics.media-hannover.de/vendor/doctrine
|
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <--
File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/environment/cli.php File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: misc/How to install Piwik.html File to delete: misc/gpl-3.0.txt File to delete: misc/internal-docs/content-tracking.md File to delete: misc/others/ExamplePiwikTracker.php File to delete: misc/others/api_internal_call.php File to delete: misc/others/api_rest_call.php File to delete: misc/others/cli-script-bootstrap.php File to delete: misc/others/download-count.txt File to delete: misc/others/iframeWidget.htm File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/stress.sh File to delete: misc/others/uninstall-delete-piwik-directory.php File to delete: misc/others/widget_example_lastvisits.html File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: test.html
To delete all these files at once, you can run this command: rm "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/bower.json" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/composer.json" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/composer.lock" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/config/environment/cli.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/config/environment/test.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/config/environment/ui-test.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/How to install Piwik.html" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/gpl-3.0.txt" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/internal-docs/content-tracking.md" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/ExamplePiwikTracker.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/api_internal_call.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/api_rest_call.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/cli-script-bootstrap.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/download-count.txt" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/iframeWidget.htm" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/iframeWidget_localhost.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/stress.sh" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/uninstall-delete-piwik-directory.php" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/others/widget_example_lastvisits.html" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/misc/phpstorm-codestyles/README.md" "/var/www/vhosts/media-hannover.de/analytics.media-hannover.de/test.html"
|