What version of Piwik do I have?

There are two ways to know which version of Piwik you are using:

  • In the top right menu, click on “Help” screen. The title of the Help will say “About Piwik X.Y.Z” (X.Y.Z being the Piwik version).
  • or in the top right menu, click on “User”, then click on “API” in left menu. Scroll down to the API.getPiwikVersion and click on the Example link to view your Piwik version.
  • or look in the file core/Version.php: you can download this file from your FTP server, inside this file will be the version number you are currently using.

If you want to know which version is currently the most up to date version of Piwik, click here.

What should I do when I want to update Piwik to the latest version?

Updating Piwik is easy and we hope you will always use the latest version of Piwik! It is possible to update from any old version to the latest one. Please see the Update guide for further instructions.

How do I backup my MySQL database?

Please see the WordPress guide on how to backup your database.

How do I restore my MySQL database?

Please see the WordPress guide on how to restore your database from backup.

How do I enable Maintenance mode (to display a maintenance message in Piwik, and disable tracking) prior to updates?

You can set a setting in your config/config.ini.php file as explained in this FAQ.

What should I do when the upgrade failed with “Syntax error or access violation: 1142 INDEX command denied to user”

Ask your sysadmin to GRANT your database user INDEX privilege. This is required to CREATE, DROP, and ALTER indexes, and allow Piwik to update successfully.

After the update, I get sql errors, I would like to try the update again. How do I force Piwik to re-upgrade the database from a past version?

It may happen in rare cases that Piwik believes it has upgraded to a newer version, but that the database itself was not actually upgraded. This FAQ explains how to re-run the database upgrade from a particular version.

For example, this could happen if the database crashed or overloaded during the DB upgrade (we recommend to enable maintenance and run the ugprade in the command line). It could also happen if the new Piwik files in core/Updates/ haven’t yet been uploaded to the latest files, but a Piwik user visits the Piwik UI and issues the partial upgrade leading to the errors.

As a result SQL error messages are often printed in some – or all – the reports. Errors messages such as

Error trying to execute the query 'CREATE TABLE [...]  Base table or view already exists: 1050 Table exists


SQLSTATE[42S22]: Column not found: 1054 Unknown column on clause


SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP X check that column/key exist


Error trying to execute the query 'ALTER TABLE' SQLSTATE[42S22]: Column not found: 1054 Unknown column


Error in Piwik (tracker): Error query: fetch() failed: Unknown column '...' in 'field list'

The good news is that it possible in all cases to resolve the issue and not experience any data loss or other problem!

You can manually tell Piwik to run the upgrade again by executing the following SQL query (eg. using a tool such as phpMyAdmin):

UPDATE `piwik_option` SET option_value = "1.X" WHERE option_name = "version_core";

Replace 1.X with the version you were using prior to upgrading, for example “1.10”. After running this query, visit Piwik: you should see the upgrade screen again. You can run the upgrade in the command line if your Piwik is large, or simply click the button and wait until completion.

If you still have problems, you can get help in the forums or contact Professional Services for paid support by world leading Piwik experts.

How do I upgrade a large Piwik instance without losing any tracking data?

If you have a large Piwik instance, upgrading to the latest Piwik version may take a long time (if one of the newest Piwik releases include database schema changes).

To upgrade your large Piwik instance, follow the manual three step procedure. This includes putting Piwik UI and Tracker in maintenance mode, and run the core:update command in the console. While Piwik Tracker is in maintenance mode, no data is being collected in the database. Therefore you may lose data for the few hours when Piwik was in maintenance.

This FAQ explains how to import the missing tracking requests in Piwik.

You have two options.

Option 1

During maintenance, visitors on your websites and mobile apps are still issuing the tracking requests. These piwik.php? tracking requests are stored in your Piwik server access logs files. Once the upgrade to the latest Piwik version is successful, you can create a new log file that contains all these piwik.php requests (for the time window that Piwik was in maintenance mode and not tracking).

Then you can replay this log file in Piwik which will backfill all your data: learn more in this FAQ.

Option 2

The second option requires the use of the QueuedTracking plugin with Redis.

  1. Install and setup QueuedTracking plugin.
  2. Enable writing requests into Redis
  3. Start Piwik upgrade
  4. Finish Piwik upgrade
  5. Process all requests from Redis into DB to backfill all your data (via ./console queuedtracking:process console command)
  6. Disable QueuedTracking plugin (Redis) again
  7. Piwik normal behavior resumes

If you have any feedback or suggestion, please leave a comment below.

I would like to test early beta and RC releases, how do I enable automatic updates to use these development versions?

Login as the Super User in Piwik, go to Administration > General Settings. Next to “When checking for new version of Piwik, always get”, select “The latest beta release”. Click Save at the bottom of the page. You are now using the beta release channel!

If you want to update to the latest beta version, go to Administration, then click on the “Check for updates” box in the top right of the screen. In this box, click “Check for updates”. If a new beta is available, the “About Piwik” box will turn orange. You can then update Piwik in one click.

We do only release beta versions that are supposed to be stable (when our thousands of automated tests were successful), but please note that beta versions have a risk of containing bugs (which in some very rare cases could lead to data loss). If you find and report a bug in a beta version, we will aim to fix it as quickly as possible.

Thank you so much for using the beta channel!

Any questions?

Many answers and more information about Piwik You can find here:

We are social

Follow us: