Database Upgrade Required

The following dimensions will be updated: log_visit.campaign_content, log_visit.campaign_id, log_visit.campaign_keyword, log_visit.campaign_medium, log_visit.campaign_name, log_visit.campaign_source.

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/counter/data/www/beta.counter.w3m.ru/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.1.1
ALTER TABLE `piwik_log_visit` ADD COLUMN `campaign_content` VARCHAR(255) NULL, ADD COLUMN `campaign_id` VARCHAR(100) NULL, ADD COLUMN `campaign_keyword` VARCHAR(255) NULL, ADD COLUMN `campaign_medium` VARCHAR(255) NULL, ADD COLUMN `campaign_name` VARCHAR(255) NULL, ADD COLUMN `campaign_source` VARCHAR(255) NULL;
ALTER TABLE `piwik_log_conversion` ADD COLUMN `campaign_content` VARCHAR(255) NULL, ADD COLUMN `campaign_id` VARCHAR(100) NULL, ADD COLUMN `campaign_keyword` VARCHAR(255) NULL, ADD COLUMN `campaign_medium` VARCHAR(255) NULL, ADD COLUMN `campaign_name` VARCHAR(255) NULL, ADD COLUMN `campaign_source` VARCHAR(255) 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.