Matomo database will be upgraded from version 3.5.1 to the new version 3.14.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:
php /mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/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 3.14.0
› 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 `drvogler_consult_piwik_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `drvogler_consult_piwik_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `drvogler_consult_piwik_access` DROP PRIMARY KEY;
ALTER TABLE `drvogler_consult_piwik_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `drvogler_consult_piwik_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `drvogler_consult_piwik_report_subscriptions` (`idreport` INT(11) NOT NULL, `token` VARCHAR(100) NULL, `email` VARCHAR(100) NOT NULL, `ts_subscribed` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `ts_unsubscribed` TIMESTAMP NULL, PRIMARY KEY ( `idreport`, `email` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `drvogler_consult_piwik_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `drvogler_consult_piwik_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `drvogler_consult_piwik_user` SET ts_password_modified = NULL;
ALTER TABLE `drvogler_consult_piwik_site` ADD COLUMN `creator_login` VARCHAR(100) NULL;
# These console commands will be run:
./console plugin:activate "IntranetMeasurable"
# These SQL queries will be executed:
ALTER TABLE `drvogler_consult_piwik_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `drvogler_consult_piwik_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `drvogler_consult_piwik_twofactor_recovery_code` (`idrecoverycode` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL, `recovery_code` VARCHAR(40) NOT NULL, PRIMARY KEY ( `idrecoverycode` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# These console commands will be run:
./console plugin:activate "TwoFactorAuth"
./console plugin:deactivate "GoogleAuthenticator"
# These SQL queries will be executed:
CREATE TABLE `drvogler_consult_piwik_tracking_failure` (`idsite` BIGINT(20) UNSIGNED NOT NULL, `idfailure` SMALLINT UNSIGNED NOT NULL, `date_first_occurred` DATETIME NOT NULL, `request_url` MEDIUMTEXT NOT NULL, PRIMARY KEY ( `idsite`, `idfailure` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `drvogler_consult_piwik_brute_force_log` (`id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, PRIMARY KEY ( `id_brute_force_log` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `drvogler_consult_piwik_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;
# These console commands will be run:
./console plugin:activate "Tour"
# These SQL queries will be executed:
ALTER TABLE `drvogler_consult_piwik_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `drvogler_consult_piwik_locks` (`key` VARCHAR(70) NOT NULL, `value` VARCHAR(255) NULL DEFAULT NULL, `expiry_time` BIGINT UNSIGNED DEFAULT 9999999999, PRIMARY KEY ( `key` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# These console commands will be run:
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleAPI"
# These SQL queries will be executed:
UPDATE `drvogler_consult_piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2021-04.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `drvogler_consult_piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2021-04.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz';
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: misc/deploy Directory to delete: themes Directory to delete: vendor/symfony/yaml Directory to delete: vendor/tedivm To delete all these directories at once, you can run this command: rm -Rf /mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/deploy /mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/themes /mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/vendor/symfony/yaml /mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/vendor/tedivm |
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: README File to delete: bower.json File to delete: composer.json File to delete: composer.lock File to delete: config/config.ini.sample.php File to delete: config/global.ini.auto-backup-before-update.php File to delete: js/README File to delete: lang/am.php File to delete: lang/ar.php File to delete: lang/be.php File to delete: lang/bg.php File to delete: lang/ca.php File to delete: lang/cs.php File to delete: lang/cy.php File to delete: lang/da.php File to delete: lang/de.php File to delete: lang/el.php File to delete: lang/en.php File to delete: lang/es.php File to delete: lang/et.php File to delete: lang/eu.php File to delete: lang/fa.php File to delete: lang/fi.php File to delete: lang/fr.php File to delete: lang/gl.php File to delete: lang/he.php File to delete: lang/hr.php File to delete: lang/hu.php File to delete: lang/id.php File to delete: lang/is.php File to delete: lang/it.php File to delete: lang/ja.php File to delete: lang/ka.php File to delete: lang/ko.php File to delete: lang/lt.php File to delete: lang/lv.php File to delete: lang/nb.php File to delete: lang/nl.php File to delete: lang/nn.php File to delete: lang/pl.php File to delete: lang/pt-br.php File to delete: lang/pt.php File to delete: lang/ro.php File to delete: lang/ru.php File to delete: lang/sk.php File to delete: lang/sl.php File to delete: lang/sq.php File to delete: lang/sr.php File to delete: lang/sv.php File to delete: lang/te.php File to delete: lang/th.php File to delete: lang/tr.php File to delete: lang/uk.php File to delete: lang/zh-cn.php File to delete: lang/zh-tw.php File to delete: misc/ExamplePiwikTracker.php File to delete: misc/How to install Piwik.html File to delete: misc/api_internal_call.php File to delete: misc/api_rest_call.php File to delete: misc/cron/archive.windows.ps1 File to delete: misc/crossdomain.xml File to delete: misc/download-count.txt File to delete: misc/generateDoc.bat File to delete: misc/generateDoc.sh File to delete: misc/gpl-3.0.txt File to delete: misc/iframeWidget.htm File to delete: misc/iframeWidget_localhost.php File to delete: misc/internal-docs/content-tracking.md File to delete: misc/log-analytics/README 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/crossdomain.xml File to delete: misc/others/db-schema-README File to delete: misc/others/db-schema.png File to delete: misc/others/db-schema.xml File to delete: misc/others/diagram_general_request.jpg File to delete: misc/others/diagram_general_request.vsd File to delete: misc/others/download-count.txt File to delete: misc/others/generateDoc.bat File to delete: misc/others/generateDoc.sh File to delete: misc/others/iframeWidget.htm File to delete: misc/others/iframeWidget_localhost.php File to delete: misc/others/phpdoc-config.ini File to delete: misc/others/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/others/phpstorm-codestyles/README.md File to delete: misc/others/stress.sh File to delete: misc/others/svn-props-to-set-new-files.svnprops File to delete: misc/others/widget_example_lastvisits.html File to delete: misc/phpdoc-config.ini File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: misc/proxy-hide-piwik-url/piwik.php File to delete: misc/stress.sh File to delete: misc/svn-props-to-set-new-files.svnprops File to delete: misc/test_cookies_GenerateHundredsWebsitesAndVisits.php File to delete: misc/test_generateLotsVisitsWebsites.php File to delete: misc/tracker_simpleImageTracker.php File to delete: misc/uninstall-delete-piwik-directory.php File to delete: misc/widget_example_lastvisits.html File to delete: tests/README.txt File to delete: libs/bower_components/jquery-ui/ui/.jshintrc File to delete: vendor/twig/twig/.editorconfig To delete all these files at once, you can run this command: rm "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/README" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/bower.json" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/composer.json" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/composer.lock" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/config/config.ini.sample.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/config/global.ini.auto-backup-before-update.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/js/README" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/am.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ar.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/be.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/bg.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ca.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/cs.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/cy.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/da.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/de.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/el.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/en.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/es.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/et.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/eu.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/fa.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/fi.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/fr.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/gl.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/he.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/hr.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/hu.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/id.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/is.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/it.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ja.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ka.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ko.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/lt.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/lv.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/nb.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/nl.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/nn.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/pl.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/pt-br.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/pt.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ro.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/ru.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/sk.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/sl.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/sq.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/sr.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/sv.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/te.php" rm "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/th.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/tr.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/uk.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/zh-cn.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/lang/zh-tw.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/ExamplePiwikTracker.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/How to install Piwik.html" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/api_internal_call.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/api_rest_call.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/cron/archive.windows.ps1" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/crossdomain.xml" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/download-count.txt" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/generateDoc.bat" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/generateDoc.sh" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/gpl-3.0.txt" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/iframeWidget.htm" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/iframeWidget_localhost.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/internal-docs/content-tracking.md" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/log-analytics/README" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/api_internal_call.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/api_rest_call.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/cli-script-bootstrap.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/crossdomain.xml" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/db-schema-README" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/db-schema.png" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/db-schema.xml" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/diagram_general_request.jpg" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/diagram_general_request.vsd" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/download-count.txt" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/generateDoc.bat" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/generateDoc.sh" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/iframeWidget.htm" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/iframeWidget_localhost.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/phpdoc-config.ini" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/phpstorm-codestyles/README.md" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/stress.sh" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/svn-props-to-set-new-files.svnprops" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/others/widget_example_lastvisits.html" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/phpdoc-config.ini" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/phpstorm-codestyles/README.md" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/proxy-hide-piwik-url/piwik.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/stress.sh" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/svn-props-to-set-new-files.svnprops" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/test_cookies_GenerateHundredsWebsitesAndVisits.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/test_generateLotsVisitsWebsites.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/tracker_simpleImageTracker.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/uninstall-delete-piwik-directory.php" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/misc/widget_example_lastvisits.html" rm "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/tests/README.txt" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/libs/bower_components/jquery-ui/ui/.jshintrc" "/mnt/web323/a0/67/52746067/htdocs/planungsbuero-vogler/piwik/vendor/twig/twig/.editorconfig" |