Last modified: 2013-06-27 13:49:00 UTC
Whenever you think that you've fixed that damn script, you suddenly realize there's something else that's still wrong. Testing the fix for bug 49758, looking at its results: Created reports per component: VisualEditor General 33 MediaWiki extensions UniversalLanguageSelector 27 VisualEditor Editing Tools 25 VisualEditor MediaWiki integration 12 Wikimedia Bugzilla 11 Created reports per product: MediaWiki 43 Wikimedia 45 MediaWiki extensions 104 Security 3 Tools 5 it is clear that the "product" list does not list those products with the **highest** number of new tickets in the last week. This can be also seen on https://bugzilla.wikimedia.org/report.cgi?x_axis_field=&y_axis_field=product&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&longdesc_type=allwordssubstr&longdesc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_id=&bug_id_type=anyexact&votes=&votes_type=greaterthaneq&emailtype1=substring&email1=&emailtype2=substring&email2=&emailtype3=substring&email3=&chfield=[Bug+creation]&chfieldvalue=&chfieldfrom=-7d&chfieldto=Now&j_top=AND&f1=noop&o1=noop&v1=&format=table&action=wrap which right now lists these top 5 products: MediaWiki extensions 104 VisualEditor 95 MediaWiki 48 Wikimedia 47 Parsoid 23
Looking back at the very first revision of operations/puppet/templates/misc/bugzilla_report.php it already says: getBugsPerProduct() uses SELECT name, count(*) FROM bugs but getBugsPerComponent() uses SELECT name, count(*) as total FROM bugs That's the only difference I can spot in the query designs.
Related URL: https://gerrit.wikimedia.org/r/69629 (Gerrit Change Iecdc7439463f58be272cf0b73f662ac91d0b061b)
Shizzle, /me blind. "ORDER BY foo DESC" is teh win!
Deployed.
