Matomo database will be upgraded from version 3.3.0 to the new version 3.13.6.
The following dimensions will be updated: log_visit.location_region.
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: CREATE TABLE `piwiksuz_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 `piwiksuz_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`); ALTER TABLE `piwiksuz_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `piwiksuz_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `piwiksuz_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL; ALTER TABLE `piwiksuz_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT; ALTER TABLE `piwiksuz_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT; ALTER TABLE `piwiksuz_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT; ALTER TABLE `piwiksuz_access` CHANGE `access` `access` VARCHAR(50) NULL; ALTER TABLE `piwiksuz_access` DROP PRIMARY KEY; ALTER TABLE `piwiksuz_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT; ALTER TABLE `piwiksuz_access` ADD INDEX index_loginidsite (`login`, `idsite`); ALTER TABLE `piwiksuz_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; CREATE TABLE `piwiksuz_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 `piwiksuz_report_subscriptions` ADD UNIQUE KEY unique_token (`token`); ALTER TABLE `piwiksuz_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL; UPDATE `piwiksuz_user` SET ts_password_modified = NULL; ALTER TABLE `piwiksuz_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 `piwiksuz_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0'; ALTER TABLE `piwiksuz_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0; ALTER TABLE `piwiksuz_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL; ALTER TABLE `piwiksuz_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT ''; CREATE TABLE `piwiksuz_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 `piwiksuz_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 `piwiksuz_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 `piwiksuz_brute_force_log` ADD INDEX index_ip_address (`ip_address`); ALTER TABLE `piwiksuz_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 `piwiksuz_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL; CREATE TABLE `piwiksuz_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 `piwiksuz_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2024-12.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz'; UPDATE `piwiksuz_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2024-12.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz'; ALTER TABLE `piwiksuz_log_visit` MODIFY COLUMN `location_region` char(3) DEFAULT NULL; ALTER TABLE `piwiksuz_log_conversion` MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
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.
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/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/widget_example_lastvisits.html
To delete all these files at once, you can run this command: rm "/home/felixdif/piwiksuz/PULL_REQUEST_TEMPLATE" "/home/felixdif/piwiksuz/bower.json" "/home/felixdif/piwiksuz/composer.json" "/home/felixdif/piwiksuz/composer.lock" "/home/felixdif/piwiksuz/misc/How to install Piwik.html" "/home/felixdif/piwiksuz/misc/gpl-3.0.txt" "/home/felixdif/piwiksuz/misc/internal-docs/content-tracking.md" "/home/felixdif/piwiksuz/misc/others/api_internal_call.php" "/home/felixdif/piwiksuz/misc/others/api_rest_call.php" "/home/felixdif/piwiksuz/misc/others/download-count.txt" "/home/felixdif/piwiksuz/misc/others/iframeWidget_localhost.php" "/home/felixdif/piwiksuz/misc/others/stress.sh" "/home/felixdif/piwiksuz/misc/others/widget_example_lastvisits.html"