560391 - "Popular Collections" are off/incorrect on the homepage

Status: RESOLVED INVALID

(addons.mozilla.org Graveyard :: Collections, defect)

Description

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

Fligtar noticed this:

On https://preview.addons.mozilla.org/z/en-US/firefox/, the "Popular Collections" are off.

Specifically, the first one has 1,386 subscribers, while the next two have 3 and 1, respectively.

(Compare with Remora: https://preview.addons.mozilla.org/en-US/firefox/)

Comment 1

[Jeff Balogh (:jbalogh)]

These are ordered by weekly subscribers, and that info must not be available on preview.  Check out https://addons.mozilla.org/z/en-US/firefox/?browse=featured.

mysql> select localized_string, weekly_subscribers from collections c, translations t where c.name=t.id and t.locale='en-us' order by weekly_subscribers desc limit 10;
+-------------------------+--------------------+
| localized_string        | weekly_subscribers |
+-------------------------+--------------------+
| Family Organizer        |                  1 | 
| Fashion Your Firefox    |                  0 | 
| Web Developer's Toolbox |                  0 | 
| Games for Gamers        |                  0 | 
| Traveler's Pack         |                  0 | 
| The Best Add-ons Ever   |                  0 | 
| Addons for Researchers  |                  0 | 
| Firebug Add-ons         |                  0 | 
| Social Circuit          |                  0 | 
| Reference Desk          |                  0 | 
+-------------------------+--------------------+

Comment 2

[Justin Scott [:fligtar]]

Oh, we switched from total subscribers to weekly subscribers in zamboni? I think I remember that now.

Comment 3

[Jeff Balogh (:jbalogh)]

(In reply to comment #2)
> Oh, we switched from total subscribers to weekly subscribers in zamboni? I
> think I remember that now.

It should make that box refresh more.