@msonnad opened this Issue on February 13th 2020

Hi We are getting the
Mysqli prepare error: Table 'piwik.piwik_locks' doesn't exist

Mysqli prepare error: Table 'piwik.piwik_brute_force_log' doesn't exist
errors .

Tried to update the UPDATE piwik.piwik_option SET option_value = "3.13.1" WHERE option_name = "version_core";
This doesnt make any impact.
Very often we used to get
image

this error.

Thanks, Manjunath S S

@toredash commented on February 13th 2020 Contributor

I suspect you have forgot to update your database tables.

Please run:
./path/to/matomo/console core:update

@msonnad commented on February 13th 2020

@toredash Thanks for your reply.
Can u please help me where to run this command?

I tried running under deployment directory /apache2/htdocs/Piwik, and under PHP/
not able to execute the command.

** Update **
I aable to run the command. and successfully updated the table
image

After update also, I am seeing the same error on UI.
image

@sgiehl commented on February 13th 2020 Member

You might have broke the update process by manually updating the version in the options table.
Maybe try setting the option back to the version you had before and rerun the update on console

@msonnad commented on February 13th 2020

Hi @sgiehl ,
Thanks its worked for me.
After updating the Piwik . We need to execute the core: update

This Issue was closed on February 13th 2020
Powered by GitHub Issue Mirror