Upgrade to 3.13.1 matomo_locks doesn't exist

[gpiero]

Hi
I have three validation environments
after updating to version 3.13.1 I have the following problem on all of them

the autoarchiving process fails with the same error

"INFO [2020-01-21 10:07:22] 3999 Error: Got invalid response from API request: ?module=API&method=API.get&idSite=12&period=day&date=last4&format=php&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:11573:"SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘piwik_v_entrisc.matomo_locks’ doesn’t exist "

[Kreki]

same problem here

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘db1176673-matomo.matomo_locks’ doesn’t exist

[OriginalOcto]

Not sure if you’ve tried this, but from an command line in the directory:

<path_to_wampstack_dir>\php

run:

php <path_to_wampstack_dir>\apache2\htdocs\piwik\console core:update

This will prompt you for a database upgrade if required - this resolved a few SQL issues for myself on upgrade! Hope it helps!

[gpiero]

thank you very much
it worked perfectly!

[OriginalOcto]

No problemo - good news!