Matomo database will be upgraded from version 5.1.1 to the new version 5.2.1.
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 /srv/users/treeanalytics/apps/piwik-analytics/public/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 console commands will be run:
./console config:set --section="database" --key="collation" --value="utf8_general_ci"
./console core:invalidate-report-data --dates=2025-11-01,today --plugin=Actions.Actions_hits
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. |
Files were found in your Matomo, but we didn't expect them.
--> Please delete these files to prevent errors. <--
File to delete: config/environment/test.php
File to delete: config/environment/ui-test.php
File to delete: misc/others/ExamplePiwikTracker.php
File to delete: misc/others/uninstall-delete-piwik-directory.php
File to delete: package-lock.json
To delete all these files at once, you can run this command:
rm "/srv/users/treeanalytics/apps/piwik-analytics/public/config/environment/test.php" "/srv/users/treeanalytics/apps/piwik-analytics/public/config/environment/ui-test.php" "/srv/users/treeanalytics/apps/piwik-analytics/public/misc/others/ExamplePiwikTracker.php" "/srv/users/treeanalytics/apps/piwik-analytics/public/misc/others/uninstall-delete-piwik-directory.php" "/srv/users/treeanalytics/apps/piwik-analytics/public/package-lock.json"
|
