Piwik database will be upgraded from version 2.0-rc1 to the new version 3.0.0.
The following plugins will be updated: LanguagesManager, Goals, Provider.
The following dimensions will be updated: log_link_visit_action.idpageview, log_link_visit_action.interaction_position, log_link_visit_action.time_spent_ref_action, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.referer_url, log_visit.user_id, 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_days_since_first, log_visit.visitor_days_since_last, log_visit.visitor_days_since_order, log_visit.visitor_localtime, log_visit.visitor_returning.
Important notes for large Piwik installations
If you have a large Piwik 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/alfazeta/ftp/piwik/console core:update
If you manage a high traffic Piwik server, we recommend to momentarily disable visitor Tracking and put the Piwik User Interface in maintenance mode.
› Click here to view and copy the list of SQL queries that will get executed
# FYI: these are the SQL queries that will be executed to upgrade your database to Piwik 3.0.0
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_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_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_12 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',502);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_03',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_04',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_05',3265);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_06',3954);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_07',2211);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_08',1665);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_09',1455);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_10',2326);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_11',1578);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_12',1336);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_01',2011);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_02',1394);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_03',1628);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_04',1585);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_05',1576);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_06',1300);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_07',1902);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_08',1985);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_09',1300);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_10',1088);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_11',1326);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_12',1190);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_01',1433);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_02',1270);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_03',1178);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_04',1265);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_05',1379);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_06',1294);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_07',1397);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_08',1484);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_09',1647);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_10',1561);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_11',1547);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_12',1835);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_01',2328);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_02',1704);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_03',1708);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_04',1696);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_05',1648);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_06',1057);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_07',597);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_08',596);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_09',593);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_10',596);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_11',593);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_12',719);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_01',653);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_04',516);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_05',650);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_06',791);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_12',632);
# 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_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetSEOgetRank\",\"parameters\":{\"module\":\"SEO\",\"action\":\"getRank\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetUserCountryMapvisitorMap\",\"parameters\":{\"module\":\"UserCountryMap\",\"action\":\"visitorMap\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphcolumnsArray\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_uniq_visitors\"],\"widget\":1,\"rows\":[]},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerVisitDuration\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsPerVisitDuration\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1,\"filter_limit\":50,\"viewDataTable\":\"table\"},\"isHidden\":false}],[{\"uniqueId\":\"widgetDevicesDetectiongetBrowsers\",\"parameters\":{\"module\":\"DevicesDetection\",\"action\":\"getBrowsers\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitTimegetVisitInformationPerServerTime\",\"parameters\":{\"module\":\"VisitTime\",\"action\":\"getVisitInformationPerServerTime\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphcolumnsArray\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\",\"avg_time_on_site\",\"nb_actions_per_visit\",\"nb_pageviews\"],\"viewDataTable\":\"graphEvolution\",\"filter_limit\":10,\"rows\":[],\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"viewDataTable\":{\"module\":\"Live\",\"action\":\"widget\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0}],[{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"viewDataTable\":\"tableAllColumns\",\"filter_limit\":10,\"flat\":1,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getWebsites\"},\"filter_limit\":10,\"flat\":0,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetSEOgetRank\",\"parameters\":{\"module\":\"SEO\",\"action\":\"getRank\",\"filter_limit\":10,\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetReferrersgetReferrerType\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getReferrerType\",\"viewDataTable\":\"graphPie\",\"filter_limit\":10,\"enable_filter_excludelowpop\":1,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetVisitTimegetVisitInformationPerServerTime\",\"parameters\":{\"module\":\"VisitTime\",\"action\":\"getVisitInformationPerServerTime\",\"viewDataTable\":\"graphVerticalBar\",\"filter_limit\":10,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerVisitDuration\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsPerVisitDuration\",\"viewDataTable\":\"graphPie\",\"filter_limit\":10,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerPage\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsPerPage\",\"viewDataTable\":\"graphPie\",\"filter_limit\":10,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetDevicesDetectiongetBrowsers\",\"parameters\":{\"module\":\"DevicesDetection\",\"action\":\"getBrowsers\",\"viewDataTable\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0}]]}' WHERE iddashboard = '1';
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphcolumnsArray\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\",\"avg_time_on_site\",\"nb_outlinks\"],\"widget\":1,\"rows\":[]},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerVisitDuration\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsPerVisitDuration\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetCoreHomegetPromoVideo\",\"parameters\":{\"module\":\"CoreHome\",\"action\":\"getPromoVideo\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetUserCountryMapvisitorMap\",\"parameters\":{\"module\":\"UserCountryMap\",\"action\":\"visitorMap\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetDevicesDetectiongetBrowsers\",\"parameters\":{\"module\":\"DevicesDetection\",\"action\":\"getBrowsers\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitTimegetVisitInformationPerServerTime\",\"parameters\":{\"module\":\"VisitTime\",\"action\":\"getVisitInformationPerServerTime\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
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_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_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_2016_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_12 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_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_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_2016_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_12 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_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_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_12 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`;
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetSEOgetRank\",\"parameters\":{\"module\":\"SEO\",\"action\":\"getRank\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetUserCountryMapvisitorMap\",\"parameters\":{\"module\":\"UserCountryMap\",\"action\":\"visitorMap\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_uniq_visitors\"],\"widget\":1,\"rows\":[],\"forceView\":\"1\",\"viewDataTable\":\"graphEvolution\"},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1,\"filter_limit\":50,\"viewDataTable\":\"table\"},\"isHidden\":false}],[{\"uniqueId\":\"widgetUserSettingsgetBrowser\",\"parameters\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\",\"avg_time_on_site\",\"nb_actions_per_visit\",\"nb_pageviews\"],\"viewDataTable\":\"graphEvolution\",\"filter_limit\":10,\"rows\":[],\"widget\":1,\"forceView\":\"1\"},\"isHidden\":0},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"viewDataTable\":{\"module\":\"Live\",\"action\":\"widget\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0}],[{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"viewDataTable\":\"tableAllColumns\",\"filter_limit\":10,\"flat\":1,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getWebsites\"},\"filter_limit\":10,\"flat\":0,\"widget\":1},\"isHidden\":0},{\"uniqueId\":\"widgetSEOgetRank\",\"parameters\":{\"module\":\"SEO\",\"action\":\"getRank\",\"filter_limit\":10,\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetUserSettingsgetBrowser\",\"parameters\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\",\"viewDataTable\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\"},\"filter_limit\":10,\"widget\":1},\"isHidden\":0}]]}' WHERE iddashboard = '1';
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\",\"avg_time_on_site\",\"nb_outlinks\"],\"widget\":1,\"rows\":[],\"forceView\":\"1\",\"viewDataTable\":\"graphEvolution\"},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetCoreHomegetPromoVideo\",\"parameters\":{\"module\":\"CoreHome\",\"action\":\"getPromoVideo\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetUserCountryMapvisitorMap\",\"parameters\":{\"module\":\"UserCountryMap\",\"action\":\"visitorMap\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetUserSettingsgetBrowser\",\"parameters\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
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_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`;
ALTER TABLE `piwik_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwik_log_visit` CHANGE `location_provider` `location_provider` VARCHAR(200) 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_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, ADD COLUMN `visit_total_interactions` SMALLINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_url` TEXT NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, MODIFY COLUMN `visitor_days_since_last` SMALLINT(5) UNSIGNED 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;
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, 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;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, ADD COLUMN `interaction_position` SMALLINT UNSIGNED DEFAULT NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(10) UNSIGNED NULL;
Need help upgrading Piwik?
If you need support to upgrade your Piwik, the creators of Piwik are here to help you make the Piwik upgrade a success and provide all instructions, best practises and ongoing support. Contact the Piwik experts to get started upgrading your Piwik safely.
Ready to go?
The database upgrade process may take a while, so please be patient.
File integrity check failed and reported some errors. This is most likely due to a partial or failed upload of some of the Piwik files. You should reupload all the Piwik files in BINARY mode and refresh this page until it shows no error. |
Missing file: /home/alfazeta/ftp/piwik/composer.lock |
Missing file: /home/alfazeta/ftp/piwik/vendor/piwik/cache/composer.lock |
Missing file: /home/alfazeta/ftp/piwik/vendor/piwik/decompress/composer.lock |