Closed Bug 960748 Opened 10 years ago Closed 10 years ago

Queries involving comment tags crash

Categories

(Bugzilla :: Query/Bug List, defect)

4.5.1
defect
Not set
normal

Tracking

()

RESOLVED FIXED
Bugzilla 5.0

People

(Reporter: LpSolit, Assigned: dkl)

References

()

Details

Attachments

(1 file, 1 obsolete file)

This query makes Bugzilla to crash:

  https://bugzilla.mozilla.org/buglist.cgi?f1=comment_tag&o1=equals&v1=foo

"DBD::mysql::db selectcol_arrayref failed: Unknown column 'bugs.comment_tag' in 'where clause'"

The same error is returned upstream. The reason is that comment tags are stored in a separate DB table, but Bugzilla/Search.pm hasn't been updated to join this table when involving comment tags in queries.
Attached patch 960748_1.patch (obsolete) — Splinter Review
Assignee: query-and-buglist → dkl
Status: NEW → ASSIGNED
Attachment #8361343 - Flags: review?(glob)
Comment on attachment 8361343 [details] [diff] [review]
960748_1.patch

Revising patch to consider private comments :(
Attachment #8361343 - Flags: review?(glob)
Attached patch 960748_2.patchSplinter Review
Attachment #8361343 - Attachment is obsolete: true
Attachment #8361356 - Flags: review?(glob)
Comment on attachment 8361356 [details] [diff] [review]
960748_2.patch

r=glob, nice
Attachment #8361356 - Flags: review?(glob) → review+
Flags: approval+
Committing to: bzr+ssh://dlawrence%40mozilla.com@bzr.mozilla.org/bugzilla/trunk
modified Bugzilla/Search.pm
Committed revision 8870.
Status: ASSIGNED → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Blocks: 960883
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: