# free/libre analytics platform

Database Upgrade Required

Your Piwik database is out-of-date, and must be upgraded before you can continue.

Piwik database will be upgraded from version 2.2.2 to the new version 2.6.1.

The following dimensions will be updated: log_visit.config_device_brand, log_visit.config_device_model, log_visit.config_device_type, log_visit.config_os_version.

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 /var/www/web236/html/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.
• If you are not able to use the command line updater and if Piwik fails to upgrade (due to a timeout of the database, a browser timeout, or any other issue), you could manually execute the SQL queries to update Piwik.
  › Click here to view and copy the list of SQL queries that will get executed
  
  # Note: if you manually execute these queries, it is expected that some of them fail. In this case, simply ignore the errors, and run the next ones in the list.

   ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR( 255 ) NOT NULL ;
   UPDATE `piwik_option` SET option_value = '2.6.0-b1' WHERE option_name = 'version_core';
   ALTER TABLE `piwik_log_visit` ADD COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, ADD COLUMN `config_os_version` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
   UPDATE `piwik_option` SET option_value = 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL' WHERE option_name = 'version_log_visit.config_device_brand';
   UPDATE `piwik_option` SET option_value = 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL' WHERE option_name = 'version_log_visit.config_device_model';
   UPDATE `piwik_option` SET option_value = 'TINYINT( 100 ) NULL DEFAULT NULL' WHERE option_name = 'version_log_visit.config_device_type';
   UPDATE `piwik_option` SET option_value = 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL' WHERE option_name = 'version_log_visit.config_os_version';


Ready to go?

The database upgrade process may take a while, so please be patient.