I’m trying to upgrade my Piwik instance after a VERY long time. From 2.4.1 to 2.14.2.
In one instance, my upgrade looked like it first listed the number of SQL statements it’s going to run and then ran through all of them.
In this instance however, this happened:
Your Piwik database is out-of-date, and must be upgraded before you can continue.
Piwik database will be upgraded from version 2.4.1 to the new version 2.14.2.
The following dimensions will be updated: log_visit.config_browser_engine, log_visit.user_id.
The database upgrade process may take a while, so please be patient.
Executing DROP TABLE IF EXISTS
piwik_site_setting… Done. [1 / 341]
Executing CREATE TABLE
idsite INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
setting_name VARCHAR(255) NOT NULL,
setting_value LONGTEXT NOT NULL,
PRIMARY KEY(idsite, setting_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8… Done. [2 / 341]
Executing ALTER TABLE
piwik_log_visit ADD COLUMN
user_id VARCHAR(200) NULL, MODIFY COLUMN
config_browser_engine VARCHAR(10) NOT NULL… Done. [3 / 341]
Piwik has been successfully updated!
So, I ran the update command again. This time, it just ran one SQL command:
piwik_log_link_visit_action ADD COLUMN
idaction_content_interaction INTEGER(10) UNSIGNED DEFAULT NULL, ADD COLUMN
idaction_content_name INTEGER(10) UNSIGNED DEFAULT NULL, ADD COLUMN
idaction_content_piece INTEGER(10) UNSIGNED DEFAULT NULL, ADD COLUMN
idaction_content_target INTEGER(10) UNSIGNED DEFAULT NULL…
If I manually run the update again, it keeps saying that all updates are complete.
The application seems to be running fine and it seems to think that it’s at 2.14.2. What do I need to do ?