Piwik › Aktualisierung

Die Piwik-Datenbank wird von Version 2.0-rc1 auf die neue Version 2.16.1 aktualisiert.

Die folgenden Plugins werden aktualisiert: LanguagesManager

Wichtiger Hinweis für große Piwik-Installationen

Dies ist ein umfangreiche Aktualisierung. Das Einspielen dauert länger als üblich. Der folgende Hinweis ist besonders für große Installationen wichtig.

Wenn Sie eine große Piwik-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 /html/piwik/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.

Wenn Sie die Aktualisierung nicht von der Kommandozeile aus ausführen können und auch Piwik die Aktualisierung nicht durchführen kann (wegen Zeitüberschreitungen der Datenbank, des Browser oder sonstigen Fällen), können Sie auch die SQL-Befehle manuell ausführen, um Piwik zu aktualisieren.

› Klicken Sie hier, um die Liste der auszuführenden SQL-Befehle anzuzeigen und zu kopieren.

# Hinweis: Wenn Sie die Befehle manuell ausführen, könnte es passieren, dass einige fehlschlagen. In solch einem Fall ignorieren Sie die Fehlermeldung einfach und führen den nächsten Befehl in der Liste aus.
ALTER TABLE piwik_user ADD COLUMN `superuser_access` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER token_auth;
ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `piwik_log_visit` ADD COLUMN `config_browser_engine` VARCHAR(10) NOT NULL;
UPDATE piwik_log_visit SET `config_browser_engine` = IF (`config_browser_name` IN ('OP'), 'Presto', IF (`config_browser_name` IN ('SF','CH','OW','AR','EP','FL','WO','AB','IR','CS','FD','HA','MI','GE','DF','BB','BP','TI','CF','RK','B2','NF'), 'WebKit', IF (`config_browser_name` IN ('KO'), 'KHTML', IF (`config_browser_name` IN ('NS','PX','FF','FB','CA','GA','KM','MO','SM','CO','FE','KP','KZ','TB'), 'Gecko', IF (`config_browser_name` IN ('IE'), 'Trident', '')))));
UPDATE IGNORE piwik_archive_blob_2012_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
CREATE TABLE `piwik_sequence` (
                `name` VARCHAR(120) NOT NULL,
                `value` BIGINT(20) UNSIGNED NOT NULL,
                PRIMARY KEY(`name`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_02', 517);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_03', 532);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_04', 531);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_05', 532);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_06', 531);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_07', 532);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_08', 532);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_09', 533);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_10', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_11', 535);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_12', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_01', 539);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_02', 533);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_03', 536);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_04', 560);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_05', 540);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_06', 539);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_07', 544);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_08', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_09', 538);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_10', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_11', 535);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_12', 541);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_01', 536);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_02', 542);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_03', 542);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_04', 551);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_05', 543);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_06', 538);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_07', 555);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_08', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_09', 552);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_10', 552);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_11', 535);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_12', 552);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_01', 567);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_02', 541);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_03', 551);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_04', 581);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_05', 556);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_06', 559);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_07', 578);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_08', 541);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_09', 531);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_10', 539);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_11', 530);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_12', 534);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2016_01', 538);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2016_02', 595);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2016_03', 536);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2016_04', 551);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2016_05', 534);
# ATTENTION: This update script will execute some more SQL queries than that below as it is necessary to rebuilt some archives #;
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowserVersion', 'DevicesDetection_getBrowserVersions');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowser', 'DevicesDetection_getBrowsers');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getOSFamily', 'DevicesDetection_getOsFamilies');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getOS', 'DevicesDetection_getOsVersions');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getMobileVsDesktop', 'DevicesDetection_getType');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowserType', 'DevicesDetection_getBrowserEngines');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getWideScreen', 'UserSettings_getScreenType');
UPDATE piwik_archive_blob_2012_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
delete from `piwik_option` where option_name like '%defaultReport%' and option_value='';
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (
                  idsite INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                  `setting_name` VARCHAR(255) NOT NULL,
                  `setting_value` LONGTEXT NOT NULL,
                      PRIMARY KEY(idsite, setting_name)
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site` ADD COLUMN `exclude_unknown_urls` TINYINT(1) DEFAULT 0 AFTER `currency`;
ALTER TABLE `piwik_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`;

Sind Sie bereit?

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

Die Datenbank muss aktualisiert werden

Wichtiger Hinweis für große Piwik-Installationen

Sind Sie bereit?