I'm operating a few webcam sites where a few unpolite visitors reload the start pages many thousand times. In the 1.5.1 Live! plug-in, I've spotted an unexpected 'visiting time ceiling' of 18 hours 12 minutes. Visits longer then that still seem to be analyzed/processed correctly. It's just the time in the table header that clips.
Keywords: Live plug-in
Can you please post screenshots of the bug, and also show the log_visit rows for these visitors? Thank you
Piwik screenshots of two huge sessions, both erroneously ending after 18h 12m:
Hundreds of similar pages are following after the first ones...
Logfile accross both sessions (and a few more short ones) filtered to that visitor's IP:
These are accesses to / only, all child accesses have been stripped.
18h 12m 15s equals 65535s - which is exactly (2^16)-1
OK, I think this is an acceptable bug. Otherwise we could maybe rename it to "More than 18h 12min" ?
I guess the problem is the database definition. In the log_visit table the field visit_total_time is a smallint(5). Well, smallint can't store values above 65535. We could change the fieldtype to int, that would fix this problem.
Sorry, I prefer marking this one as a "known documented display bug" rather than increase the field size to BIGINT which would have performance overhead. It is not common for piwik to track visitors for more than 18h, since it sounds like a bot and we generally exclude bots. in fact maybe this bot should not be tracked via IP exclusion or upcoming user agent exclusion... #2375