visit_total_time set too low in database #3817

JohnDeery opened this Issue Mar 12, 2013 · 1 comment

2 participants


While trying to import logs, I kept running across an error stating that the visit_total_time was out of range. Looking at the number trying to be inserted (65842) vs the column type (smallint, max of 65535), this is only 18.2 hours... crazy but some people might be on that long.

Changed the column to mediumint in my database to give a total of 16777215 (unsigned) seconds or 6.3 months
Keywords: out-of-bounds

Piwik Open Source Analytics member

In b420123: Fixes #3817 Capping visit_total_time

Thanks for the report!

PS: this visit is most likely a bot or browser with auto refresh

@JohnDeery JohnDeery added this to the 1.12 - The Great 1.x Backlog milestone Jul 8, 2014
@mattab mattab was assigned by JohnDeery Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment