Closed
Bug 731201
Opened 13 years ago
Closed 13 years ago
user activity report is showing duplicate rows for some changes
Categories
(bugzilla.mozilla.org :: Extensions, defect)
Tracking
()
RESOLVED
FIXED
People
(Reporter: glob, Assigned: glob)
References
()
Details
user activity report is showing duplicate rows for some changes, see the changes to bug 715713 on https://bugzilla.mozilla.org/page.cgi?id=user_activity.html&action=run&who=mozilla%2Bbugcloser%40davedash.com&from=2012-02-22&to=2012%E2%80%9102%E2%80%9122&sort=when
the query is returning
> | bug_status | 727963 | NULL | 2012.02.22 20:46:07 | NEW | RESOLVED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | resolution | 727963 | NULL | 2012.02.22 20:46:07 | | FIXED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | bug_status | 711971 | NULL | 2012.02.22 20:46:07 | NEW | RESOLVED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | resolution | 711971 | NULL | 2012.02.22 20:46:07 | | FIXED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | bug_status | 687672 | NULL | 2012.02.22 20:46:07 | NEW | RESOLVED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | resolution | 687672 | NULL | 2012.02.22 20:46:07 | | FIXED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | bug_status | 720652 | NULL | 2012.02.22 20:46:07 | NEW | RESOLVED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | resolution | 720652 | NULL | 2012.02.22 20:46:07 | | FIXED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | bug_status | 715713 | NULL | 2012.02.22 20:46:07 | NEW | RESOLVED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
> | resolution | 715713 | NULL | 2012.02.22 20:46:07 | | FIXED | mozilla+bugcloser@davedash.com | NULL | 2012-02-22 20:46:07 |
which is correct; however the code isn't picking up on the bug id change, and folding them all into updates against the same bug.
Assignee: nobody → glob
Status: NEW → ASSIGNED
ah, the problem was all these changes were made during the same second, and the report was only looking at the user+time to determine if it's a different changeset. i've added the bug id.
Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bmo/4.0/
modified extensions/BMO/lib/Reports.pm
modified extensions/BMO/template/en/default/pages/user_activity.html.tmpl
Committed revision 8097.
this revisions also adds support for &debug=1 to dump the query's sql.
Status: ASSIGNED → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Updated•5 years ago
|
Component: Extensions: Other → Extensions
You need to log in
before you can comment on or make changes to this bug.
Description
•