I installed Matomo On-Premise on a web hosting using Softaculous Apps Installer, to analyze several websites:
Version de Matomo: 5.7.1
Version de MySQL: 11.4.10-MariaDB
Version de PHP: 8.4.17
The archiving process failed as soon as one of the websites received a visit. Each website that has received at least one visit generates an error message in the log :
Error: Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=12&period=day&date=2026-02-06&format=json&trigger=archivephp. Response was '{“result”:“error”,“message”:"Mysqli prepare error: Table ‘dbuser.mt8k_log_bot_request’ doesn’t exist - in plugin BotTracking.
The Table ‘mt8k_log_bot_request’ is indeed missing from the database, even if the BotTracking plugin is activated, but the diagnostic tool did not identify any integrity issues.
I then completely uninstalled Matomo and reinstalled it from scratch, with the same result.
A temporary solution is to disable the BotTracking plugin, trigger an archiving process, and then re-enable the plugin: the archiving process runs correctly, but the problem reappears as soon as one of the websites receives a new visit, causing subsequent archiving processes to fail.
Any ideas for a definitive solution?