Die Piwik-Datenbank wird von Version 2.0-rc1 auf die neue Version 3.0.2 aktualisiert.
Die folgenden Dimensionen werden aktualisiert: log_visit.user_id, log_visit.visit_goal_buyer, log_visit.visit_goal_converted, log_visit.visit_total_time, log_visit.visitor_count_visits, log_visit.visitor_days_since_first, log_visit.visitor_days_since_order, log_visit.visitor_returning.
Wichtiger Hinweis für große Piwik-Installationen
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 /kunden/190983_70794/rp-hosting/6811/7811/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.
› Klicken Sie hier, um die Liste der auszuführenden SQL-Befehle anzuzeigen und zu kopieren.
# Zu Ihrer Information: Dies sind die SQL Queries, welche ausgeführt werden, um die Datenbank für Piwik 3.0.2 zu aktualisieren
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_01 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_2017_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_03 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_01',501);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_10',665);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_11',559);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_12',665);
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',553);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_03',543);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_04',562);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_05',565);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_06',574);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_07',569);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_08',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_09',576);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_10',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_11',567);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_12',612);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_01',607);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_02',594);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_03',607);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_04',603);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_05',609);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_06',602);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_07',603);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_08',603);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_09',601);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_10',602);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_11',599);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_12',607);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_01',762);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_02',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_03',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_04',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_05',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_06',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_07',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_08',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_09',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_10',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_11',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_12',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_01',539);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_02',516);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_03',514);
# 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_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_01 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_2017_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_01 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_2017_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_01 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_2017_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_03 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`;
CREATE TABLE `piwik_plugin_setting` (`plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, `user_login` VARCHAR(100) NOT NULL DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_plugin_setting` ADD INDEX index_plugin_name_user_login (`plugin_name`, `user_login`);
DELETE FROM `piwik_option` WHERE `option_name` like "Plugin_%_Settings";
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL, `plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site_setting` ADD INDEX(idsite, plugin_name);
ALTER TABLE `piwik_log_visit` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `piwik_log_conversion_item` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_log_conversion` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED default NULL;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idaction_name_ref` `idaction_name_ref` INTEGER(10) UNSIGNED NULL;
ALTER TABLE `piwik_user` CHANGE `password` `password` VARCHAR(255) NOT NULL;
ALTER TABLE `piwik_log_visit` ADD COLUMN `user_id` VARCHAR(200) NULL, MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_days_since_first` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_days_since_order` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_days_since_first` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_days_since_order` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL;
Brauchen Sie Hilfe beim Upgrade von Piwik?
Wenn Sie Hilfe beim Upgrade von Piwik brauchen, sind die Ersteller von Piwik hier, um Ihnen zu einem erfolgreichen Upgrade zu helfen. Für Anleitungen, best practises und weiterführenden Support, kontaktiere die Piwik-Experten um das Upgrade sicher durchzuführen.
Sind Sie bereit?
Die Aktualisierung kann eine Weile dauern. Bitte haben Sie etwas Geduld.