I have a query that looks for all the bugs I'm CCed on, which I use to keep track of Mozilla development. Today, possibly due to the voting landing, I get this: 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.rep_platform, 1, 3), assign.login_name, substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4), substring(bugs.component, 1, 8), substring(bugs.short_desc, 1, 60) from bugs left join votes using(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 & 0 = bugs.groupset and ( instr(assign.login_name, 'matty@box.net.au') or instr(report.login_name, 'matty@box.net.au') or instr(ccname.login_name, 'matty@box.net.au') or instr(qacont.login_name, 'matty@box.net.au') ) group by bugs.bug_id order by bugs.delta_ts, bugs.priority, bugs.bug_severity: at globals.pl line 45. Please send mail to this site's webmaster for help. --- As there is no webmaster listed (which is probably a bug in itself), I'm submitting this here.

Here's a reduced test case: http://bugzilla.mozilla.org/buglist.cgi?email1=a&emailcc1=1 which gives: 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.rep_platform, 1, 3), assign.login_name, substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4), substring(bugs.component, 1, 8), sum(votes.count) as votesum, substring(bugs.short_desc, 1, 60) from bugs left join votes using(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 & 0 = bugs.groupset and ( instr(ccname.login_name, 'a') ) group by bugs.bug_id : at globals.pl line 45. Please send mail to this site's webmaster for help. I get the error off both my old bookmark and entering a new query.

Whoops! Thanks for reporting this; it is now fixed.

Verify query is fine, victory is mine!

Moving to Bugzilla product