Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I have an issue whose symptom is duplicated rows in users statistics tab. For each day (not all, really, but most of them) both new users and active users views show two rows instead of one.
In statspro table I observed there are two records per day, one of wich whith timestamp pointing at 00:00:00 and one at 01:00:00 hours, extract of data is in attachment.
I did'nt manage to find out from where problem is, by the way my configuration is:
- Drupal 6.14
- Statistics Pro 6.x-1.x-dev
- MS IIS 6 w/ FASTCGI
- PHP 5.2.9-1
- MySQL 5.1.32-community
My installation is a test application and runs on a enterprise intranet server, basic system configuration is forced by enterprise policies, so no way to swicth to LAMP.
| Comment | File | Size | Author |
|---|---|---|---|
| statspro-extract.zip | 1.35 KB | mas160 |
Comments
Comment #1
rsevero commentedI believe there were some kind of subtle unexpected behavior in PHP and MySQL timestamp interaction that created two lines per day one hour apart in some situations. I really couldn't figure out when exactly it was happening.
I changed the day column type from timestamp to date with commit #371810 so there is no chance of this particular error appearing again.