500 million downloads are missing

VERIFIED FIXED in 5.11

Status

addons.mozilla.org Graveyard
Statistics
P1
major
VERIFIED FIXED
8 years ago
2 years ago

People

(Reporter: fligtar, Assigned: clouserw)

Tracking

Details

(Whiteboard: [z][qa!], URL)

(Reporter)

Description

8 years ago
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)

Updated

8 years ago
Assignee: nobody → clouserw
(Assignee)

Comment 2

8 years ago
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
Last Resolved: 8 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
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.