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 1.5.1 to the new version 1.6.

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 /usr/local/www/piwik/index.php -- "module=CoreUpdater"
• It is also recommended for high traffic Piwik servers 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_log_conversion_item` ADD idaction_category2 INTEGER(10) UNSIGNED NOT NULL AFTER idaction_category, ADD idaction_category3 INTEGER(10) UNSIGNED NOT NULL, ADD idaction_category4 INTEGER(10) UNSIGNED NOT NULL, ADD idaction_category5 INTEGER(10) UNSIGNED NOT NULL;
   ALTER TABLE `piwik_log_visit` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v2 custom_var_v2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k3 custom_var_k3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v3 custom_var_v3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k4 custom_var_k4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL;
   ALTER TABLE `piwik_log_conversion` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v2 custom_var_v2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k3 custom_var_k3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v3 custom_var_v3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k4 custom_var_k4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL;
   ALTER TABLE `piwik_log_link_visit_action` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v2 custom_var_v2 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k3 custom_var_k3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v3 custom_var_v3 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k4 custom_var_k4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL;
   UPDATE `piwik_option` SET option_value = '1.6-rc1' WHERE option_name = 'version_core';


Ready to go?

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