Piwik # 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 0.5.4 to the new version 0.5.5.
Important note 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/web18/html/sites/stats/index.php -- "module=CoreUpdater"
- 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.
DROP INDEX index_idsite_date ON piwik_log_visit;
CREATE INDEX index_idsite_date_config ON piwik_log_visit (idsite, visit_server_date, config_md5config(8));
DROP INDEX index_all ON piwik_archive_numeric_2010_01;
CREATE INDEX index_idsite_dates_period ON piwik_archive_numeric_2010_01 (idsite, date1, date2, period);
DROP INDEX index_all ON piwik_archive_numeric_2010_02;
CREATE INDEX index_idsite_dates_period ON piwik_archive_numeric_2010_02 (idsite, date1, date2, period);
DROP INDEX index_all ON piwik_archive_numeric_2010_03;
CREATE INDEX index_idsite_dates_period ON piwik_archive_numeric_2010_03 (idsite, date1, date2, period);
DROP INDEX index_all ON piwik_archive_blob_2010_01;
DROP INDEX index_all ON piwik_archive_blob_2010_02;
DROP INDEX index_all ON piwik_archive_blob_2010_03;
UPDATE piwik_option
SET option_value = "0.5.5"
WHERE option_name = "version_core";
Ready to go?
The database upgrade process may take a while, so please be patient.