Matomo database will be upgraded from version 5.2.2 to the new version 5.3.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 /home/grangeweb/websites/grangeweb.ch/statistics/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 SQL queries will be executed:
ALTER TABLE `piwik_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
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: scripts
To delete all these directories at once, you can run this command:
rm -Rf /home/grangeweb/websites/grangeweb.ch/statistics/scripts
|
Files were found in your Matomo, but we didn't expect them.
--> Please delete these files to prevent errors. <--
File to delete: 20191510_statistics_backup_site.zip
File to delete: PULL_REQUEST_TEMPLATE
File to delete: backup/grangeweb_statistics___(10-25-16_05-10-2025).sql
File to delete: backup/grangeweb_statistics___(10-25-18_05-09-2025).sql
File to delete: backup/grangeweb_statistics___(10-25-20_05-11-2025).sql
File to delete: bower.json
File to delete: composer.json
File to delete: composer.lock
File to delete: config/environment/test.php
File to delete: config/environment/ui-test.php
File to delete: js/piwik-min.js
File to delete: js/piwik.js.orig
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/api_internal_call.php
File to delete: misc/others/api_rest_call.php
File to delete: misc/others/download-count.txt
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: statistics_grangeweb.zip
To delete all these files at once, you can run this command:
rm "/home/grangeweb/websites/grangeweb.ch/statistics/20191510_statistics_backup_site.zip" "/home/grangeweb/websites/grangeweb.ch/statistics/PULL_REQUEST_TEMPLATE" "/home/grangeweb/websites/grangeweb.ch/statistics/backup/grangeweb_statistics___(10-25-16_05-10-2025).sql" "/home/grangeweb/websites/grangeweb.ch/statistics/backup/grangeweb_statistics___(10-25-18_05-09-2025).sql" "/home/grangeweb/websites/grangeweb.ch/statistics/backup/grangeweb_statistics___(10-25-20_05-11-2025).sql" "/home/grangeweb/websites/grangeweb.ch/statistics/bower.json" "/home/grangeweb/websites/grangeweb.ch/statistics/composer.json" "/home/grangeweb/websites/grangeweb.ch/statistics/composer.lock" "/home/grangeweb/websites/grangeweb.ch/statistics/config/environment/test.php" "/home/grangeweb/websites/grangeweb.ch/statistics/config/environment/ui-test.php" "/home/grangeweb/websites/grangeweb.ch/statistics/js/piwik-min.js" "/home/grangeweb/websites/grangeweb.ch/statistics/js/piwik.js.orig" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/How to install Piwik.html" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/gpl-3.0.txt" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/internal-docs/content-tracking.md" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/api_internal_call.php" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/api_rest_call.php" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/download-count.txt" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/iframeWidget_localhost.php" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/stress.sh" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/uninstall-delete-piwik-directory.php" "/home/grangeweb/websites/grangeweb.ch/statistics/misc/others/widget_example_lastvisits.html" "/home/grangeweb/websites/grangeweb.ch/statistics/statistics_grangeweb.zip"
|
