Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/16/d366565988/htdocs/piwik/libs/upgradephp/upgrade.php on line 180
Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/16/d366565988/htdocs/piwik/libs/upgradephp/upgrade.php on line 194
Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/16/d366565988/htdocs/piwik/libs/upgradephp/upgrade.php on line 194
Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/16/d366565988/htdocs/piwik/libs/upgradephp/upgrade.php on line 200
Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/16/d366565988/htdocs/piwik/libs/upgradephp/upgrade.php on line 202 Matomo ›Update
Database Upgrade Required
Your Matomo database is out-of-date, and must be upgraded before you can continue.
Matomo database will be upgraded from version 3.4.0 to the new version 3.5.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:
#FYI: these are the SQL queries that will be executed to upgrade your database to Matomo 3.5.0 CREATE TABLE `piwik_privacy_logdata_anonymizations` (`idlogdata_anonymization` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idsites` TEXT NULL DEFAULT NULL, `date_start` DATETIME NOT NULL, `date_end` DATETIME NOT NULL, `anonymize_ip` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_location` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_userid` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `unset_visit_columns` TEXT NOT NULL DEFAULT '', `unset_link_visit_action_columns` TEXT NOT NULL DEFAULT '', `output` MEDIUMTEXT NULL DEFAULT NULL, `scheduled_date` DATETIME NULL, `job_start_date` DATETIME NULL, `job_finish_date` DATETIME NULL, `requester` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY ( `idlogdata_anonymization` )) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `piwik_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`); ALTER TABLE `piwik_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `piwik_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
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: misc/package Directory to delete: plugins/Contents/tests Directory to delete: plugins/ExamplePlugin/tests Directory to delete: tests/PHPUnit Directory to delete: tests/UI Directory to delete: tests/angularjs Directory to delete: tests/javascript Directory to delete: tests/lib Directory to delete: tests/resources Directory to delete: vendor/mnapoli Directory to delete: vendor/myclabs Directory to delete: vendor/tecnick.com
To delete all these directories at once, you can run this command: rm -Rf /homepages/16/d366565988/htdocs/piwik/misc/package /homepages/16/d366565988/htdocs/piwik/plugins/Contents/tests /homepages/16/d366565988/htdocs/piwik/plugins/ExamplePlugin/tests /homepages/16/d366565988/htdocs/piwik/tests/PHPUnit /homepages/16/d366565988/htdocs/piwik/tests/UI /homepages/16/d366565988/htdocs/piwik/tests/angularjs /homepages/16/d366565988/htdocs/piwik/tests/javascript /homepages/16/d366565988/htdocs/piwik/tests/lib /homepages/16/d366565988/htdocs/piwik/tests/resources /homepages/16/d366565988/htdocs/piwik/vendor/mnapoli /homepages/16/d366565988/htdocs/piwik/vendor/myclabs /homepages/16/d366565988/htdocs/piwik/vendor/tecnick.com
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: misc/How to install Piwik.html File to delete: misc/others/cli-script-bootstrap.php File to delete: misc/others/iframeWidget.htm File to delete: misc/phpstorm-codestyles/Piwik_codestyle.xml File to delete: misc/phpstorm-codestyles/README.md File to delete: tests/index.html File to delete: tests/LocalTracker.php File to delete: tests/README.screenshots.md File to delete: tests/README.testing-data.md File to delete: tests/README.troubleshooting.md File to delete: tests/travis/autoupdate_travis_yml.sh File to delete: tests/travis/checkout_dependent_plugins.sh File to delete: tests/travis/checkout_test_against_branch.sh File to delete: tests/travis/configure_git.sh File to delete: tests/travis/generate_docs.sh File to delete: tests/travis/get_required_piwik_version.php File to delete: tests/travis/install_mysql_5.6.sh File to delete: tests/travis/install_python_2.6.sh File to delete: tests/travis/php-fpm.ini File to delete: tests/travis/piwik_nginx.conf File to delete: tests/travis/prepare.sh File to delete: tests/travis/setup_webserver.sh File to delete: tests/travis/travis-helper.sh File to delete: tests/travis/travis.sh File to delete: tests/travis/upload_artifacts.sh File to delete: vendor/maxmind-db/reader/autoload.php File to delete: libs/bower_components/jquery-ui/ui/.jshintrc File to delete: vendor/monolog/monolog/.php_cs File to delete: vendor/pear/archive_tar/.travis.sh File to delete: vendor/piwik/device-detector/.php_cs File to delete: vendor/twig/twig/.editorconfig
To delete all these files at once, you can run this command: rm "/homepages/16/d366565988/htdocs/piwik/PULL_REQUEST_TEMPLATE" "/homepages/16/d366565988/htdocs/piwik/misc/How to install Piwik.html" "/homepages/16/d366565988/htdocs/piwik/misc/others/cli-script-bootstrap.php" "/homepages/16/d366565988/htdocs/piwik/misc/others/iframeWidget.htm" "/homepages/16/d366565988/htdocs/piwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/homepages/16/d366565988/htdocs/piwik/misc/phpstorm-codestyles/README.md" "/homepages/16/d366565988/htdocs/piwik/tests/index.html" "/homepages/16/d366565988/htdocs/piwik/tests/LocalTracker.php" "/homepages/16/d366565988/htdocs/piwik/tests/README.screenshots.md" "/homepages/16/d366565988/htdocs/piwik/tests/README.testing-data.md" "/homepages/16/d366565988/htdocs/piwik/tests/README.troubleshooting.md" "/homepages/16/d366565988/htdocs/piwik/tests/travis/autoupdate_travis_yml.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/checkout_dependent_plugins.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/checkout_test_against_branch.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/configure_git.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/generate_docs.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/get_required_piwik_version.php" "/homepages/16/d366565988/htdocs/piwik/tests/travis/install_mysql_5.6.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/install_python_2.6.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/php-fpm.ini" "/homepages/16/d366565988/htdocs/piwik/tests/travis/piwik_nginx.conf" "/homepages/16/d366565988/htdocs/piwik/tests/travis/prepare.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/setup_webserver.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/travis-helper.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/travis.sh" "/homepages/16/d366565988/htdocs/piwik/tests/travis/upload_artifacts.sh" "/homepages/16/d366565988/htdocs/piwik/vendor/maxmind-db/reader/autoload.php" "/homepages/16/d366565988/htdocs/piwik/libs/bower_components/jquery-ui/ui/.jshintrc" "/homepages/16/d366565988/htdocs/piwik/vendor/monolog/monolog/.php_cs" "/homepages/16/d366565988/htdocs/piwik/vendor/pear/archive_tar/.travis.sh" "/homepages/16/d366565988/htdocs/piwik/vendor/piwik/device-detector/.php_cs" "/homepages/16/d366565988/htdocs/piwik/vendor/twig/twig/.editorconfig"