Matomo database will be upgraded from version 4.1.1 to the new version 4.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 /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/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 4.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:
php /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/console core:invalidate-report-data --sites=all --dates=2020-11-23,2021-04-12 --plugin=VisitFrequency
# These SQL queries will be executed:
UPDATE `piwik_archive_numeric_2010_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2010_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2011_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2012_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.';
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.
| 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: matomo Directory to delete: vendor/container-interop Directory to delete: vendor/leafo Directory to delete: vendor/piwik Directory to delete: vendor/twig/twig/ext To delete all these directories at once, you can run this command: rm -Rf /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/libs/bower_components /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/matomo /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/vendor/container-interop /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/vendor/leafo /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/vendor/piwik /var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/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: How to install Matomo.html 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_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 To delete all these files at once, you can run this command: rm "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/How to install Matomo.html" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/PULL_REQUEST_TEMPLATE" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/bower.json" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/composer.json" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/composer.lock" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/How to install Piwik.html" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/gpl-3.0.txt" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/internal-docs/content-tracking.md" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/ExamplePiwikTracker.php" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/api_internal_call.php" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/api_rest_call.php" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/download-count.txt" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/iframeWidget_localhost.php" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/stress.sh" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/uninstall-delete-piwik-directory.php" "/var/www/vhosts/kkbits-mail.com/piwiki.kk-bits.com/misc/others/widget_example_lastvisits.html" |