15890 - Query for fixed bugs by resolution date no longer works

Status: VERIFIED FIXED

(Bugzilla :: Bugzilla-General, defect, P3)

Description

[Phil Peterson]

I usually use a bugzilla query to find out which bugs have been fixed in the
last week. The query looks like:

Status: Resolved,Verified
Resolution: Fixed
Where the fields: resolution
Dates: 1-Oct-99
To: Now
Changed to value: FIXED

And this usually works. When I tried it today, I got the error message:

Please stand by ...

Content-type: text/html

Software error:

select bugs.bug_id, bugs.groupset, substring(bugs.bug_severity, 1, 3),
assign.login_name, substring(bugs.resolution,1,4),
bugs.target_milestone, bugs.short_desc from bugs left join votes on bugs.bug_id
= votes.bug_id, profiles assign, profiles
report left join profiles qacont on bugs.qa_contact = qacont.userid, versions
projector where bugs.assigned_to =
assign.userid and bugs.reporter = report.userid and bugs.product =
projector.program and bugs.version = projector.value
and bugs.groupset & 1024 = bugs.groupset and ( bugs.product = 'MailNews' ) and (
bugs.bug_status = 'RESOLVED' or
bugs.bug_status = 'VERIFIED' ) and ( bugs.resolution = 'FIXED' ) and
bugs_activity.bug_id = bugs.bug_id and (
bugs_activity.field = 'resolution') and bugs_activity.bug_when >= '1999/10/01
00:00:00' and bugs_activity.newvalue =
'FIXED' group by bugs.bug_id order by bugs.priority, bugs.bug_severity: at
globals.pl line 45.

Please send mail to this site's webmaster for help.

Comment 1

[Terry Weissman]

Yikes.  I have reproduced and am trying to chase it down...

Comment 2

[Terry Weissman]

That turned out to be easy.  Fixed.

Comment 3

[Phil Peterson]

Thanks, Terry.

Verified (in case that counts for anything)

Comment 4

[Dave Miller [:justdave]]

Moving to Bugzilla product

Comment 5

[Pulsebot]

Pushed by ffxbld-merge:
https://hg.mozilla.org/releases/mozilla-beta/rev/3ffb5a690ff8
[fenix] For https://github.com/mozilla-mobile/fenix/issues/15890 - Ensure app locale switcher works for Windows builds