670980 - Active Daily Users 0 for addon guid [e-mail]

Status: RESOLVED FIXED

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

Description

[Daniel Einspanjer [:dre] [:deinspanjer]]

+++ This bug was initially created as a clone of Bug #528161 +++

There was an old addon_id, 309971 that ADU was being recorded against.  I've nulled out the GUID for that addon_id.  After the export tonight, stats should be available normally.

On 2011-07-13, please run the following update query (first checking that the results are sane and such)

UPDATE update_counts SET addon_id=310118 WHERE addon_id=309971

Comment 1

[Wil Clouser [:clouserw]]

mysql> select count(*) from update_counts where addon_id=309971;
+----------+
| count(*) |
+----------+
|       74 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from update_counts where addon_id=310118;
+----------+
| count(*) |
+----------+
|        1 | 
+----------+
1 row in set (0.00 sec)

mysql> update update_counts set addon_id=310118 where addon_id=309971;
Query OK, 74 rows affected (0.15 sec)
Rows matched: 74  Changed: 74  Warnings: 0