Missing Database Table

Running Matomo 3.9.1 (although this error showed up on earlier versions, too).

My database is getting too large for my taste, so I want to either delete some data or (more likely) reports. Knowledgebase says I can do this on the Privacy>Anonymize Data page. When I navigate to that page I get an error:
## SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydbname.mydbprefix_privacy_logdata_anonymizations' doesn't exist

What do I need to do to fix this?

Replying to my own topic because it’s been two years and still have no solution. I just updated to 4.2.1 and I’m still getting the error:

## SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydbname.myydbprefix_privacy_logdata_anonymizations' doesn't exist

I’m also getting a Column not found error:

## SQLSTATE[42S22]: Column not found: 1054 Unknown column 'json_encoded' in 'field list'

that appears on Settings - Platform->Marketplace, and Diagnostic->Database Usage

Still don’t know how to fix this. Ready to ditch Matomo altogether, or maybe I should trash this installation and try again.


The privacy_logdata_anonymizations table should have been created at the 3.5.0 upgrade.

You can check


for reference on how that table should look like.

And similarly for the missing column:



Thank you so much, Lukas!!

I added the db table privacy_logdata_anonymizations, and the colums json_encoded, and everything seems to be working just fine so far.

I assume the issue was that I messed up an update somewhere along the way. I feel a lot better now. I have a client who wants a simpler alternative to Google Analytics for her suite of WordPress sites and I want to be able to recommend Matomo.

Thanks again for your help!!