565536 - 500 million downloads are missing

Status: VERIFIED FIXED

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

Description

[Justin Scott [:fligtar]]

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.

Comment 1

[Jeff Balogh (:jbalogh)]

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.

Comment 2

[Wil Clouser [:clouserw]]

Fixed for me with http://github.com/jbalogh/zamboni/commit/8e4e52e46c4684b6741b773cf08c21d97ccedc47

In [4]: DownloadCount.objects.aggregate(sum=Sum('count'))['sum']
Out[4]: 1932762973

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

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