2.9.0 update issue

after update i get this error message:

API returned an error: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxxxxxxxx_stats.piwik_sequence’ doesn’t exist at Pdo.php:234

This table was added in 2.9.0 and should have been created during the update (by the database migration).

How did you update? Did you maybe forget to update the database if you upgraded manually?

I had to update manually, but i did try to use the $ ./path/to/piwik/console core:update command but it said the database was up to date, can you post or pm me the database querys i need to fix my database please?

Hi @budgierless, see this faq: 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? - Analytics Platform - Matomo

thanks, issue SOVLED.