After upgrading to Joomla! 3.10.3, banner component started logging every individual impression and click, instead of logging hourly impressions/clicks.
Publish a banner on the frontend
Enable "Track impressions" in Banner component settings
Navigate through the frontend for a while, so the banner is loaded a few times
Check Banner Tracks in Banner Component
A single log per hour for each banner should be displayed in Banner tracks view.
Several logs per hour are shown for each banner (check attached image). This causes _banner_tracks table to grow insanely fast (nearly 3 million records in barely 3 weeks), and make banner component hard to manage.
mysql - 5.6.40 - utf8_general_ci - utf8mb4_general_ci
PHP 7.4.27
Apache
fpm-fcgi
Joomla! 3.10.4 Stable [ Daraja ] 11-December-2021 15:02 GMT
Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
The site was upgraded from an old 3.9.18 version to 3.10.3
Searching for any possible solution this PR came along
Apparently this was included again in 3.10, and this comment is related to my specific issue
Actually, this comment is what made this PR appear in my search.
Labels |
Removed:
?
|
Labels |
Added:
No Code Attached Yet
|
It might fix your issue so please give it a test to confirm or rule it out.
Labels |
Added:
Information Required
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2022-02-06 21:47:32 |
Closed_By | ⇒ | Quy |
Added screenshot.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/36375.