From de1f3fe949ff898bb9c26994be8e7a56968e3a9a Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Thu, 30 Jun 2005 05:03:47 +0000 Subject: =?UTF-8?q?Bug=20298024:=20Incorrect=20group=20control=20check=20i?= =?UTF-8?q?n=20sanitycheck.cgi=20-=20Patch=20by=20Fr=C3=A9d=C3=A9ric=20Buc?= =?UTF-8?q?lin=20=20r=3Djoel=20a=3Dmyk?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- sanitycheck.cgi | 19 +++++++++---------- 1 file changed, 9 insertions(+), 10 deletions(-) (limited to 'sanitycheck.cgi') diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 79295b3c8..ae202dfe9 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -833,11 +833,9 @@ Status("Checking for bugs with groups violating their product's group controls") BugCheck("bugs INNER JOIN bug_group_map ON bugs.bug_id = bug_group_map.bug_id - INNER JOIN groups - ON bug_group_map.group_id = groups.id LEFT JOIN group_control_map ON bugs.product_id = group_control_map.product_id - AND bug_group_map.group_id = group_control_map.group_id + AND bug_group_map.group_id = group_control_map.group_id WHERE ((group_control_map.membercontrol = " . CONTROLMAPNA . ") OR (group_control_map.membercontrol IS NULL))", 'Have groups not permitted for their products', @@ -846,15 +844,16 @@ BugCheck("bugs (set member control to SHOWN)'); BugCheck("bugs - INNER JOIN bug_group_map - ON bugs.bug_id = bug_group_map.bug_id - INNER JOIN groups - ON bug_group_map.group_id = groups.id - LEFT JOIN group_control_map + INNER JOIN group_control_map ON bugs.product_id = group_control_map.product_id - AND bug_group_map.group_id = group_control_map.group_id + INNER JOIN groups + ON group_control_map.group_id = groups.id + LEFT JOIN bug_group_map + ON bugs.bug_id = bug_group_map.bug_id + AND group_control_map.group_id = bug_group_map.group_id WHERE group_control_map.membercontrol = " . CONTROLMAPMANDATORY . " - AND bug_group_map.group_id IS NULL", + AND bug_group_map.group_id IS NULL + AND groups.isactive != 0", "Are missing groups required for their products"); -- cgit v1.2.1