The following plugins will be updated: LanguagesManager, DevicesDetection, Goals, CustomDimensions.
The following dimensions will be updated: log_conversion.revenue, log_link_visit_action.idaction_content_interaction, log_link_visit_action.idaction_content_name, log_link_visit_action.idaction_content_piece, log_link_visit_action.idaction_content_target, log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.idpageview, log_link_visit_action.product_price, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_link_visit_action.time_dom_completion, log_link_visit_action.time_dom_processing, log_link_visit_action.time_network, log_link_visit_action.time_on_load, log_link_visit_action.time_server, log_link_visit_action.time_spent_ref_action, log_link_visit_action.time_transfer, log_visit.config_browser_engine, log_visit.config_browser_name, log_visit.config_browser_version, log_visit.config_client_type, log_visit.config_cookie, log_visit.config_device_brand, log_visit.config_device_model, log_visit.config_device_type, log_visit.config_flash, log_visit.config_java, log_visit.config_os, log_visit.config_pdf, log_visit.config_quicktime, log_visit.config_realplayer, log_visit.config_resolution, log_visit.config_silverlight, log_visit.config_windowsmedia, log_visit.location_browser_lang, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.location_region, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_entry_idaction_name, log_visit.visit_entry_idaction_url, log_visit.visit_exit_idaction_name, log_visit.visit_exit_idaction_url, log_visit.visit_goal_buyer, log_visit.visit_goal_converted, log_visit.visit_total_actions, log_visit.visit_total_events, log_visit.visit_total_interactions, log_visit.visit_total_searches, log_visit.visit_total_time, log_visit.visitor_count_visits, log_visit.visitor_localtime, log_visit.visitor_returning, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.
Important notes for large Matomo installations
This is a major update! It will take longer than usual.
The following advice is especially important for large 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 /home/stats/public_html/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.1.1
› 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 `piwi_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`; ALTER TABLE `piwi_log_visit` CHANGE `config_os_version` `config_os_version` VARCHAR( 100 ) DEFAULT NULL, CHANGE `config_device_type` `config_device_type` VARCHAR( 100 ) DEFAULT NULL; ALTER TABLE `piwi_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`; ALTER TABLE `piwi_custom_dimensions` ADD COLUMN `case_sensitive` TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER `extractions`; ALTER TABLE `piwi_custom_dimensions` DROP INDEX `idcustomdimension_idsite`; ALTER TABLE `piwi_custom_dimensions` ADD PRIMARY KEY(`idcustomdimension`, `idsite`); ALTER TABLE `piwi_log_visit` MODIFY COLUMN `profilable` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_entry_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL DEFAULT NULL, MODIFY COLUMN `visit_exit_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_exit_idaction_url` INTEGER(10) UNSIGNED NULL DEFAULT 0, MODIFY COLUMN `visit_total_actions` INT(11) UNSIGNED NULL, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `location_browser_lang` VARCHAR(20) NULL, MODIFY COLUMN `config_browser_engine` VARCHAR(10) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_browser_version` VARCHAR(20) NULL, MODIFY COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `config_os` CHAR(3) NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, MODIFY COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, MODIFY COLUMN `config_resolution` VARCHAR(18) NULL, MODIFY COLUMN `config_cookie` TINYINT(1) NULL, MODIFY COLUMN `config_flash` TINYINT(1) NULL, MODIFY COLUMN `config_java` TINYINT(1) NULL, MODIFY COLUMN `config_pdf` TINYINT(1) NULL, MODIFY COLUMN `config_quicktime` TINYINT(1) NULL, MODIFY COLUMN `config_realplayer` TINYINT(1) NULL, MODIFY COLUMN `config_silverlight` TINYINT(1) NULL, MODIFY COLUMN `config_windowsmedia` TINYINT(1) NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL; ALTER TABLE `piwi_log_conversion` MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL, MODIFY COLUMN `revenue` float default NULL; ALTER TABLE `piwi_log_link_visit_action` MODIFY COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, MODIFY COLUMN `search_cat` VARCHAR(200) NULL, MODIFY COLUMN `search_count` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, MODIFY COLUMN `product_price` DOUBLE NULL, MODIFY COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL, MODIFY COLUMN `idaction_content_interaction` INTEGER(10) UNSIGNED DEFAULT NULL, MODIFY COLUMN `idaction_content_name` INTEGER(10) UNSIGNED DEFAULT NULL, MODIFY COLUMN `idaction_content_piece` INTEGER(10) UNSIGNED DEFAULT NULL, MODIFY COLUMN `idaction_content_target` INTEGER(10) UNSIGNED DEFAULT NULL, MODIFY COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, MODIFY COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, MODIFY COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, MODIFY COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, MODIFY COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, MODIFY COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;
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.
Details
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: misc/others/uninstall-delete-piwik-directory.php To delete all these files at once, you can run this command: rm "/home/stats/public_html/misc/others/uninstall-delete-piwik-directory.php"
Errors below may be due to a partial or failed upload of Matomo files.
--> Try to reupload all the Matomo files in BINARY mode. <--
File size mismatch: /home/stats/public_html/js/piwik.min.js (expected length: 61980, found: 70428)
Missing file: /home/stats/public_html/offline-service-worker.js