#3037 Rogue stat from the future

Other
closed-fixed
Rob Malda
Admin (123)
5
2004-08-31
2004-08-11
Jamie McCarthy
No

I don't know what's going on, but I just happened to notice this on
linux.com. My guess is that there's a story set months in the
future? We shouldn't write these stats if that's the case.

mysql> select * from stats_daily where substring(day, 1, 7) =
'2004-12';
+--------+---------------+------+------------+------------------------
+-------+
| id | section | skid | day | name | value
|
+--------+---------------+------+------------+------------------------
+-------+
| 578879 | articles | 1 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579013 | community | 2 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579147 | desktops | 3 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579281 | documentation | 4 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579415 | forums | 5 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579549 | howtos | 6 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579683 | index | 1 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579817 | mobile | 7 | 2004-12-19 |
avg_comments_per_story | 0 |
| 579951 | programming | 8 | 2004-12-19 |
avg_comments_per_story | 0 |
| 580085 | security | 9 | 2004-12-19 |
avg_comments_per_story | 0 |
| 580219 | servers | 10 | 2004-12-19 |
avg_comments_per_story | 0 |
| 580348 | all | 1 | 2004-12-19 |
avg_comments_per_story | 0 |
| 580349 | all | 1 | 2004-12-19 | topichits_70_shell |
10 |
+--------+---------------+------+------------+------------------------
+-------+
13 rows in set (2.41 sec)

Discussion

  • Jonathan Pater
    Jonathan Pater
    2004-08-31

    • assigned_to: cowboyneal --> cmdrtaco
    • status: open --> open-fixed
     
  • Rob Malda
    Rob Malda
    2004-08-31

    • status: open-fixed --> closed-fixed