Matomo database will be upgraded from version 4.0.3 to the new version 4.2.0.
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:
# These SQL queries will be executed: UPDATE `piwi_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.'; UPDATE `piwi_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
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.
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: libs/bower_components Directory to delete: vendor/container-interop Directory to delete: vendor/leafo Directory to delete: vendor/mnapoli Directory to delete: vendor/piwik Directory to delete: vendor/tecnick.com Directory to delete: vendor/twig/twig/ext
To delete all these directories at once, you can run this command: rm -Rf /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/libs/bower_components /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/container-interop /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/leafo /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/mnapoli /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/piwik /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/tecnick.com /home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/twig/twig/ext
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <--
File to delete: PULL_REQUEST_TEMPLATE File to delete: bower.json File to delete: composer.json File to delete: composer.lock 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/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: vendor/monolog/monolog/.php_cs File to delete: vendor/pear/archive_tar/.travis.sh File to delete: vendor/twig/twig/.editorconfig
To delete all these files at once, you can run this command: rm "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/PULL_REQUEST_TEMPLATE" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/bower.json" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/composer.json" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/composer.lock" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/How to install Piwik.html" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/gpl-3.0.txt" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/internal-docs/content-tracking.md" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/ExamplePiwikTracker.php" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/api_internal_call.php" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/api_rest_call.php" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/download-count.txt" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/iframeWidget.htm" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/iframeWidget_localhost.php" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/stress.sh" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/uninstall-delete-piwik-directory.php" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/others/widget_example_lastvisits.html" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/misc/phpstorm-codestyles/README.md" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/monolog/monolog/.php_cs" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/pear/archive_tar/.travis.sh" "/home/parkinno/public_html/parkinnovaare.ch/web/addons/piwik/vendor/twig/twig/.editorconfig"
Errors below may be due to a partial or failed upload of Matomo files.
--> Try to reupload all the Matomo files in BINARY mode. <--