Bot Tracking Plugin table not created on MySQL 5.5

Plugins & Platform
1

One of my Matomo installs runs on a MySQL 5.5 database.

A recent update of Matomo to Version 5.6.2 broke Matomo. Statistics cannot be shown any more and an error message appears stating that the log_bot_tracking table is missing from the database.

It seems that the table creation code in the plugin (https://github.com/matomo-org/matomo/blob/31abe433efb15c740feeeabbfe3e042414c9183f/plugins/BotTracking/Dao/BotRequestsDao.php) uses DEFAULT CURRENT_TIMESTAMP on the created_time column, which is not supported by MySQL 5.5. Therefore, table creation fails during the update.

I know that MySQL 5.5 is rather outdated now, but it would be great if Matomo and the Bot Tracking plugin would still work.

1 Like
2

5.5 is 16 years old now and insecure. You should definitely look at upgrading; there wouldn’t be any reason to provide a version for this database version. You could try manually creating the table by using TIMESTAMP rather than DATETIME but there aren’t any guarantees that would work

1 Like
3

Maybe there is a bigger problem? I would be tested the BotTracking (Core) Plugin.

Matomo Version 5.7.1
PHP version 8.4.17
MySQL Version: 10.11.14-MariaDB-0+deb12u2
Plugins: TrackingSpamPrevention, CodeInjector

I had “Activated” the Plugin in the Administration → Manage Plugins.

Matomo writes: “You can add/delete/modify the keywords in Administration → Bot Tracker → Configuration.”
There is no Administration → Bot Tracker
(this is here: Administration → Websites → Settings → “Global list of user agents to exclude”)

Matomo writes: “either with activating the setting in Administration → General settings → Bot Tracker”
There is no Administration → General settings → Bot Tracker

There is only new in the Reports-Pages Sidebar: AI-Assistant → AI Bots Overview.
But the PlugIn “AIAgents” is deactivated.

What is the problem?

4

That is a different plugin, you would need to check with the developer. codifex is talking about the core botracker.

1 Like
5

I am also. See the link in my comment. I have only the BotTracking (Core) activated for the test and NOT the PlugIn “AIAgents”.

BotTracking (Core): Active
AIAgents (Core): Inactive

6

The link you supplied goes to a plugin not created by Matomo. If you install that plugin, you will probably see the menu they suggest. Bot Tracker (Digitalist) ≠ BotTracking (Matomo Core)

1 Like
7

OK. Then the link is incorrect. I will delete it.