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)

Production
x86
macOS
defect
Not set
normal

Tracking

()

RESOLVED FIXED

People

(Reporter: glob, Assigned: glob)

References

()

Details

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
Component: Extensions: Other → Extensions
You need to log in before you can comment on or make changes to this bug.