Matomo complains about missing annotations table - any way to fix this?

[dsp76]

Hi,
our cloudron hosted Matomo complains about the missing annotations table. Is there an easy way to fix this? To repair the package / database?

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'XYZ.annotations' doesn't exist

[james]

Hello @dsp76

What is the latest actions that happened with your Matomo app?
Did you do an update, configure something or anything?
Can you download your latest app backup and check the SQL file if this table exists there?

[dsp76]

Actually I didn't look into it for quite a while. The error is not blocking the usage and tracking. It shows up once in a while and of course I can't load or add new annotations.

Also - when the annotations plugin is active, I get this message in the dashboard:

Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data. Please try again. If this error occurs repeatedly please contact your Matomo administrator for assistance.

Deactivating the plugin solves the error, but of course removes the functionality of this core plugin.

[dsp76]

OK, as a hint for others: I found out, that some tables had different database collations. Thats why some migrations didn't work. Its most likely due to the fact, we imported an existing Matomo instance into cloudron: https://forum.cloudron.io/topic/10759/migrating-matomo/2?_=1762191084826

With help of AI we fixed thos database errors pretty quick now.
Annotations work again. Also another plugin in Matomo, which complained about missing tables.