Matomo database will be upgraded from version 5.1.0 to the new version 5.2.2.
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/piwik.sh.ch/httpdocs/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.2
› 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="utf8mb3_general_ci"
./console core:invalidate-report-data --dates=2025-02-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. |
Directories were found in your Matomo, but we didn't expect them. --> Please delete these directories to prevent errors. <-- Directory to delete: system To delete all these directories at once, you can run this command: rm -Rf /var/www/vhosts/piwik.sh.ch/httpdocs/system |
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: piwik.min.js File to delete: piwik_9/access.frm File to delete: piwik_9/archive_blob_2008_12.frm File to delete: piwik_9/archive_blob_2018_01.frm File to delete: piwik_9/archive_blob_2018_10.frm File to delete: piwik_9/archive_blob_2018_11.frm File to delete: piwik_9/archive_blob_2018_12.frm File to delete: piwik_9/archive_blob_2019_01.frm File to delete: piwik_9/archive_blob_2019_02.frm File to delete: piwik_9/archive_blob_2019_03.frm File to delete: piwik_9/archive_blob_2019_04.frm File to delete: piwik_9/archive_blob_2019_05.frm File to delete: piwik_9/archive_blob_2019_06.frm File to delete: piwik_9/archive_blob_2019_07.frm File to delete: piwik_9/archive_blob_2019_08.frm File to delete: piwik_9/archive_blob_2019_09.frm File to delete: piwik_9/archive_blob_2019_10.frm File to delete: piwik_9/archive_blob_2019_11.frm File to delete: piwik_9/archive_blob_2019_12.frm File to delete: piwik_9/archive_blob_2020_01.frm File to delete: piwik_9/archive_blob_2020_02.frm File to delete: piwik_9/archive_blob_2020_03.frm File to delete: piwik_9/archive_blob_2020_04.frm File to delete: piwik_9/archive_blob_2020_05.frm File to delete: piwik_9/archive_blob_2020_06.frm File to delete: piwik_9/archive_blob_2020_07.frm File to delete: piwik_9/archive_numeric_2008_12.frm File to delete: piwik_9/archive_numeric_2018_01.frm File to delete: piwik_9/archive_numeric_2018_10.frm File to delete: piwik_9/archive_numeric_2018_11.frm File to delete: piwik_9/archive_numeric_2018_12.frm File to delete: piwik_9/archive_numeric_2019_01.frm File to delete: piwik_9/archive_numeric_2019_02.frm File to delete: piwik_9/archive_numeric_2019_03.frm File to delete: piwik_9/archive_numeric_2019_04.frm File to delete: piwik_9/archive_numeric_2019_05.frm File to delete: piwik_9/archive_numeric_2019_06.frm File to delete: piwik_9/archive_numeric_2019_07.frm File to delete: piwik_9/archive_numeric_2019_08.frm File to delete: piwik_9/archive_numeric_2019_09.frm File to delete: piwik_9/archive_numeric_2019_10.frm File to delete: piwik_9/archive_numeric_2019_11.frm File to delete: piwik_9/archive_numeric_2019_12.frm File to delete: piwik_9/archive_numeric_2020_01.frm File to delete: piwik_9/archive_numeric_2020_02.frm File to delete: piwik_9/archive_numeric_2020_03.frm File to delete: piwik_9/archive_numeric_2020_04.frm File to delete: piwik_9/archive_numeric_2020_05.frm File to delete: piwik_9/archive_numeric_2020_06.frm File to delete: piwik_9/archive_numeric_2020_07.frm File to delete: piwik_9/db.opt File to delete: piwik_9/goal.frm File to delete: piwik_9/log_action.frm File to delete: piwik_9/log_conversion.frm File to delete: piwik_9/log_conversion_item.frm File to delete: piwik_9/log_link_visit_action.frm File to delete: piwik_9/log_profiling.frm File to delete: piwik_9/log_visit.frm File to delete: piwik_9/logger_message.frm File to delete: piwik_9/option.frm File to delete: piwik_9/plugin_setting.frm File to delete: piwik_9/privacy_logdata_anonymizations.frm File to delete: piwik_9/report.frm File to delete: piwik_9/report_subscriptions.frm File to delete: piwik_9/segment.frm File to delete: piwik_9/sequence.frm File to delete: piwik_9/session.frm File to delete: piwik_9/site.frm File to delete: piwik_9/site_setting.frm File to delete: piwik_9/site_url.frm File to delete: piwik_9/user.frm File to delete: piwik_9/user_dashboard.frm File to delete: piwik_9/user_language.frm File to delete: piwik_backup.zip File to delete: .hidden To delete all these files at once, you can run this command: rm "/var/www/vhosts/piwik.sh.ch/httpdocs/bower.json" "/var/www/vhosts/piwik.sh.ch/httpdocs/composer.json" "/var/www/vhosts/piwik.sh.ch/httpdocs/composer.lock" "/var/www/vhosts/piwik.sh.ch/httpdocs/config/environment/cli.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/config/environment/test.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/config/environment/ui-test.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/How to install Piwik.html" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/gpl-3.0.txt" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/internal-docs/content-tracking.md" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/ExamplePiwikTracker.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/api_internal_call.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/api_rest_call.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/cli-script-bootstrap.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/download-count.txt" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/iframeWidget.htm" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/iframeWidget_localhost.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/stress.sh" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/uninstall-delete-piwik-directory.php" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/others/widget_example_lastvisits.html" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/var/www/vhosts/piwik.sh.ch/httpdocs/misc/phpstorm-codestyles/README.md" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik.min.js" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/access.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2008_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2018_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2018_10.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2018_11.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2018_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_02.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_03.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_04.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_05.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_06.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_07.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_08.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_09.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_10.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_11.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2019_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_02.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_03.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_04.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_05.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_06.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_blob_2020_07.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2008_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2018_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2018_10.frm" rm "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2018_11.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2018_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_02.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_03.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_04.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_05.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_06.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_07.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_08.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_09.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_10.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_11.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2019_12.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_01.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_02.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_03.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_04.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_05.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_06.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/archive_numeric_2020_07.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/db.opt" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/goal.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_action.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_conversion.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_conversion_item.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_link_visit_action.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_profiling.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/log_visit.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/logger_message.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/option.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/plugin_setting.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/privacy_logdata_anonymizations.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/report.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/report_subscriptions.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/segment.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/sequence.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/session.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/site.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/site_setting.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/site_url.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/user.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/user_dashboard.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_9/user_language.frm" "/var/www/vhosts/piwik.sh.ch/httpdocs/piwik_backup.zip" "/var/www/vhosts/piwik.sh.ch/httpdocs/.hidden" |