Closed Bug 565536 Opened 14 years ago Closed 14 years ago

500 million downloads are missing

Categories

(addons.mozilla.org Graveyard :: Statistics, defect, P1)

Product:
addons.mozilla.org Graveyard
Component:
Statistics
Type:
defect

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: fligtar, Assigned: clouserw)

References

(
URL
)

Details

(Whiteboard: [z][qa!]) 

The homepage, stats dashboard, and API all say we have 1.4 billion downloads. We had 1.9 billion a few weeks ago. This number should be going up, not down.
Because you're using the StatsManager, the query looks like this:

u'SELECT SUM(`download_counts`.`count`) AS `count__sum` FROM `download_counts` WHERE `download_counts`.`date` > 1990-01-01 '

This is intentionally filtering out 0000-00-00 dates, but that's not what we want here.

It's an easy fix if you want to cherry pick into 5.10.3.
Target Milestone: --- → 5.11
Assignee: nobody → clouserw
Fixed for me with http://github.com/jbalogh/zamboni/commit/8e4e52e46c4684b6741b773cf08c21d97ccedc47

In [4]: DownloadCount.objects.aggregate(sum=Sum('count'))['sum']
Out[4]: 1932762973
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Verified FIXED on:

https://preview.addons.mozilla.org/z/en-US/firefox/?browse=featured:

* 1,934,030,835add-ons downloaded
* 167,900,768add-ons in use
URL: https://preview.addons.mozilla.org/z/...
Status: RESOLVED → VERIFIED
Whiteboard: [z] → [z][qa!]
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.