23453 - Broken keywords/cc query.

Status: VERIFIED FIXED

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

Description

[Matthew Tuck [:CodeMachine]]

Please stand by ...

Content-type: text/html

Software error:

select bugs.bug_id, bugs.groupset, date_format(bugs.delta_ts,'Y-m-d'),
substring(bugs.bug_status,1,4),
substring(bugs.resolution,1,4), substring(bugs.product, 1, 8), bugs.votes,
bugs.target_milestone,
substring(bugs.short_desc, 1, 60) from bugs left join cc on bugs.bug_id =
cc.bug_id left join profiles ccname
on cc.who = ccname.userid, 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 & 0 = bugs.groupset
and keywords.bug_id = bugs.bug_id and (keywords.keywordid = 2) group by
bugs.bug_id : at globals.pl line 69.

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

Comment 1

[Terry Weissman]

Whoops!  Silly SQL.  Fixed.

Thanks for letting me know!

Comment 2

[Matthew Tuck [:CodeMachine]]

Verif.  The query works, what other bug lurks?

Comment 3

[Dave Miller [:justdave]]

Moving to Bugzilla product