Created
April 12, 2011 16:35
-
-
Save andymckay/915856 to your computer and use it in GitHub Desktop.
Cope with deleted addons
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Index: maintenance.py | |
=================================================================== | |
--- maintenance.py (revision 87210) | |
+++ maintenance.py (working copy) | |
@@ -61,6 +61,7 @@ | |
REPLACE INTO stats_share_counts_totals (addon_id, service, count) | |
(SELECT addon_id, service, SUM(count) | |
FROM stats_share_counts | |
+ RIGHT JOIN addons ON addon_id = addons.id | |
WHERE service IN (%s) | |
GROUP BY addon_id, service)""" % | |
','.join('"%s"' % x for x in LINK_SHARING_SERVICES)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment