MySQL Errors During Upgrade 2.8x to 2.10?


Upgrading Piwik from 2.82 to 2.10 (possibly not the recommended way), and receiving the following error:

[X] Critical Error during the update process:

    * /var/www/piwik/core/Updates/2.9.0-b1.php:

Error trying to execute the query ‘ALTER TABLE piwik_log_visit ADD COLUMN config_browser_engine VARCHAR(10) NOT NULL’.
The error was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘piwikprod/#sql-ib154’ already exists

The above is the core error message.

Any recommendations for how to work around this? Changes to the DB?

The rest of the update seems to have went through ok.

(Matthieu Napoli) #2

Can you check that the column config_browser_engine now exists and is of the correct type in table piwik_log_visit?