From d6a99db8228a3bee2ee1771fd37e7b45521a6310 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Tue, 30 Aug 2005 23:32:05 +0000 Subject: Bug 306364: SQL crash when moving a bug to another product (regression) - Patch by Frédéric Buclin r=joel a=myk MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- process_bug.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/process_bug.cgi b/process_bug.cgi index 8f325dd61..e64a8692d 100755 --- a/process_bug.cgi +++ b/process_bug.cgi @@ -1649,7 +1649,7 @@ foreach my $id (@idlist) { # - Is the bug in this group? SendSQL("SELECT DISTINCT groups.id, isactive, " . "oldcontrolmap.membercontrol, newcontrolmap.membercontrol, " . - "CASE WHEN groups_id IN ($grouplist) THEN 1 ELSE 0 END, " . + "CASE WHEN groups.id IN ($grouplist) THEN 1 ELSE 0 END, " . "bug_group_map.group_id IS NOT NULL " . "FROM groups " . "LEFT JOIN group_control_map AS oldcontrolmap " . -- cgit v1.2.3-24-g4f1b