From 7a288e93d95c4f950c331a9919c7e7647dc559d2 Mon Sep 17 00:00:00 2001 From: "terry%mozilla.org" <> Date: Tue, 11 Jan 2000 05:24:18 +0000 Subject: [PATCH] Asking for both keywords and CC info was creating corrupted SQL. --- buglist.cgi | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/buglist.cgi b/buglist.cgi index 7ae3f066c9..c3887b6edc 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -308,7 +308,7 @@ if ($::FORM{'keywords'}) { } } if (@list) { - $query =~ s/bugs,/bugs, keywords,/; + $query =~ s/where/, keywords where/; $query .= "and keywords.bug_id = bugs.bug_id and (" . join(" $::FORM{'keywords_type'} ", @list) . ")\n"; } @@ -435,7 +435,7 @@ if (defined $ref) { if (defined $ref && 0 < @$ref) { # Do surgery on the query to tell it to patch in the bugs_activity # table. - $query =~ s/bugs,/bugs, bugs_activity,/; + $query =~ s/where/, bugs_activity where/; my @list; foreach my $f (@$ref) { -- 2.47.3