New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Live plug-in user time limit of 18h 12m #2650
Comments
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: Logfile accross both sessions (and a few more short ones) filtered to that visitor's IP: |
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 |
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
The text was updated successfully, but these errors were encountered: