From 6c0b6e11bf1e302320bebe0ce9545eff924ab124 Mon Sep 17 00:00:00 2001
From: "jouni%heikniemi.net" <>
Date: Tue, 6 Jul 2004 14:08:02 +0000
Subject: Bug 223878: Flag system dies when changing a deleted flag. r=joel,
 justdave a=justdave

---
 Bugzilla/Search.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/Search.pm')

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 2f92131fc..0ebf1e070 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -586,7 +586,8 @@ sub init {
              # negative conditions (f.e. "flag isn't review+").
              my $flags = "flags_$chartid";
              push(@supptables, "LEFT JOIN flags $flags " . 
-                               "ON bugs.bug_id = $flags.bug_id");
+                               "ON bugs.bug_id = $flags.bug_id " .
+                               "AND $flags.is_active = 1");
              my $flagtypes = "flagtypes_$chartid";
              push(@supptables, "LEFT JOIN flagtypes $flagtypes " . 
                                "ON $flags.type_id = $flagtypes.id");
-- 
cgit v1.2.3-24-g4f1b