I have Matomo installations on 3 web servers, with a shared database and the configuration flag multi_server_environment = 1. The configuration file has an entry PluginsInstalled[] = "HeatmapSessionRecording" and I can see it in the console and web UI. But when I try to activate it (either through the console or in the web UI), I get the error message
Base table or view not found: 1146 Table 'matomo.log_hsr_event' doesn't exist
The database does not contain any tables starting with log_hsr
Please reference this note:
And then there are several short guides here:
We are also experiencing the same issue. All of our files are synced too. I don’t think the enabling of the plugin is installing it correctly. It’s not creating the proper tables in order for the plugin to work. Please advise on if there’s a solution for creating any required tables for this plugin along with the correct schema and column/row types.
We are getting
ERROR: There was an error while updating the javascript tracker: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'service_instance_db.matomo_site_hsr' doesn't exist (Module: CorePluginsAdmin, Action: activate, In CLI mode: false)
and
ERROR: There was an error while regenerating container releases: /libs/Zend/Db/Statement/Pdo.php(236): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'service_instance_db.matomo_site_hsr' doesn't exist [Query: ?module=CorePluginsAdmin&action=activate&pluginName=HeatmapSessionRecording&nonce=[noonce_hash_here]&redirectTo=referrer&referrer=https%3A%2F%2Fwebanalytics.nga.mil%2Findex.php%3Fmodule%3DCorePluginsAdmin%26action%3Dplugins%26idSite%3D74%26period%3Drange%26date%3Dlast7%26activated%3D (Module: CorePluginsAdmin, Action: activate, In CLI mode: false)