Piwik › Update

# Open Source Web Analytics

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-rc6 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 /var/www/websites/mphanke/ads2buy.com/subdomains/analytic/html/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.

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.