Matomo › Aktualisieren

Die Matomo-Datenbank wird von Version 3.14.0 auf die neue Version 4.1.1 aktualisiert.

Die folgenden Dimensionen werden aktualisiert: 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.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_transfer, log_visit.config_browser_name, log_visit.config_client_type, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_total_interactions, log_visit.visitor_count_visits, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.

Wichtiger Hinweis für große Matomo-Installationen

Wenn Sie eine große Matomo-Datenbank haben, können Aktualisierungen zu lange dauern, um erfolgreich im Browser durchgeführt zu werden. In diesem Fall können Sie die Aktualisierung auch von der Kommandozeile aus starten:

php /var/www/vhosts/pfotenchaos.de/analytics.pfotenchaos.de/console core:update

Wenn Sie eine Website mit hohem Verkehrsaufkommen verwalten, empfehlen wir, das Besuchertracking vorübergehend zu deaktivieren und die Benutzeroberfläche in den Wartungsmodus zu versetzen.

Zu Ihrer Information: Dies sind die SQL Abfragen und Konsolenkommandos, welche ausgeführt werden, um die Datenbank für Matomo 4.1.1 zu aktualisieren

› Klicken Sie hier, um die Liste der auszuführenden SQL Abfragen und Konsolenkommandos anzuzeigen und zu kopieren

# Diese Konsolenkommandos werden ausgeführt: 
./console core:matomo4-migrate-token-auths

# Diese SQL Abfragen werden ausgeführt: 
CREATE TABLE `matomo_archive_invalidations` (`idinvalidation` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idarchive` INTEGER UNSIGNED NULL, `name` VARCHAR(255) NOT NULL, `idsite` INTEGER NOT NULL, `date1` DATE NOT NULL, `date2` DATE NOT NULL, `period` TINYINT UNSIGNED NOT NULL, `ts_invalidated` DATETIME NOT NULL, `status` TINYINT(1) UNSIGNED DEFAULT 0, `report` VARCHAR(255) NULL, PRIMARY KEY ( `idinvalidation` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `matomo_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);
ALTER TABLE `matomo_user` DROP COLUMN `alias`;
DELETE FROM `matomo_session` WHERE length(id) > 190;
ALTER TABLE `matomo_session` CHANGE `id` `id` VARCHAR(191);
ALTER TABLE `matomo_site_url` CHANGE `url` `url` VARCHAR(190);
ALTER TABLE `matomo_option` CHANGE `option_name` `option_name` VARCHAR(191);
ALTER TABLE `matomo_log_action` CHANGE `name` `name` VARCHAR(4096);
ALTER TABLE `matomo_log_conversion` CHANGE `url` `url` VARCHAR(4096);
ALTER TABLE `matomo_log_link_visit_action` CHANGE `interaction_position` `pageview_position` MEDIUMINT UNSIGNED DEFAULT NULL;

# Diese Konsolenkommandos werden ausgeführt: 
./console plugin:activate "BulkTracking"
./console plugin:deactivate "CustomPiwikJs"
./console plugin:uninstall "CustomPiwikJs"

# Diese SQL Abfragen werden ausgeführt: 
ALTER TABLE `matomo_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_numeric_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_archive_blob_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `matomo_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');
ALTER TABLE `matomo_log_visit` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, ADD COLUMN `profilable` TINYINT(1) NULL;
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');
ALTER TABLE `matomo_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL;
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `matomo_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');
UPDATE matomo_log_link_visit_action SET search_cat = if(custom_var_k4 = '_pk_scat', custom_var_v4, search_cat), search_count = if(custom_var_k5 = '_pk_scount', custom_var_v5, search_count) WHERE custom_var_k4 = '_pk_scat' or custom_var_k5 = '_pk_scount';
DELETE FROM `matomo_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");
UPDATE matomo_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400,
                    visitor_seconds_since_last = visitor_days_since_last * 86400;
UPDATE matomo_log_conversion SET visitor_seconds_since_first = visitor_days_since_first * 86400, 
                    visitor_seconds_since_order = visitor_days_since_order * 86400;
ALTER TABLE `matomo_log_visit` DROP COLUMN `config_gears`, DROP COLUMN `config_director`, DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`, DROP COLUMN `visitor_days_since_last`;
ALTER TABLE `matomo_log_conversion` DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`;

# Diese Konsolenkommandos werden ausgeführt: 
./console config:set --section="Tracker" --key="ignore_visits_cookie_name" --value="piwik_ignore"
./console plugin:activate "PagePerformance"
./console config:set --section="General" --key="login_allowlist_apply_to_reporting_api_requests" --value="0"

# Diese SQL Abfragen werden ausgeführt: 
ALTER TABLE `matomo_archive_invalidations` ADD COLUMN `ts_started` DATETIME NULL;

# Diese Konsolenkommandos werden ausgeführt: 
./console plugin:deactivate "ExampleTheme"

# Diese SQL Abfragen werden ausgeführt: 
UPDATE matomo_user_token_auth SET hash_algo = "sha512" where hash_algo is null or hash_algo = "" ;

# Diese Konsolenkommandos werden ausgeführt: 
./console plugin:uninstall "ExampleTheme"
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"

# Diese SQL Abfragen werden ausgeführt: 
ALTER TABLE `matomo_log_visit` ADD COLUMN `profilable` TINYINT(1) NULL, ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL;
ALTER TABLE `matomo_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD 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, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL;
ALTER TABLE `matomo_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;

Brauchen Sie Hilfe beim Upgrade von Matomo?

Wenn Sie Hilfe beim Upgrade von Matomo brauchen, sind die Ersteller von Matomo hier, um Ihnen zu einem erfolgreichen Upgrade zu helfen. Für Anleitungen, best practises und weiterführenden Support, kontaktiere die Matomo-Experten um das Upgrade sicher durchzuführen.

Sind Sie bereit?

Die Aktualisierung kann eine Weile dauern. Bitte haben Sie etwas Geduld.

Der Datei-Integritätscheck ist fehlgeschlagen und hat ein paar Fehler gemeldet. Du solltest die Probleme beheben und diese Seite neuladen, bis sie keine Fehler mehr anzeigt.

Die Datenbank muss aktualisiert werden

Wichtiger Hinweis für große Matomo-Installationen

Brauchen Sie Hilfe beim Upgrade von Matomo?

Sind Sie bereit?