Add a diagnostic: check that the database has all the tables and columns

[atom-box]

A frequent question on Matomo Forum is "How do I fix the error: Column Not Found"? We received this question in Forum twice per month in 2023 and 2024.

The proposed story here is: make a command line and / or web interface check (on the System Check page), to check that the database has all the tables and columns it should have?

Our user in the Matomo Forum proposed that it could work this way:

All needed information are already there (Mysql.php and mysqls DESCRIBE), but it still is somethat complex to match that together.

[MatomoForumNotifications]

This issue has been mentioned on Matomo forums. There might be relevant details there:

https://forum.matomo.org/t/sqlstate-42s22-column-not-found-1054-unknown-column-creator-login-in-field-list/30925/7

[atom-box]

(To add some context, the three main things I encounter which give Matomo On Premises a reputation for being "difficult" and "not for everyone" are:

• errors during core:archive
• not knowing how and when to run core:invalidate-report-data + core:archive
• having a broken update.

This story attempts to fix that third thing above, a broken update. )

[KarthikRaja1388]

Another customer is facing the same issue during update.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'botType' in 'field list'

Also the same customer had same issue with Heatmaps and Session recording