summaryrefslogtreecommitdiffstats
path: root/sanitycheck.cgi
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2005-06-30 07:03:47 +0200
committerlpsolit%gmail.com <>2005-06-30 07:03:47 +0200
commitde1f3fe949ff898bb9c26994be8e7a56968e3a9a (patch)
tree754c79c0f5b53586ddac75ca9ec7a9729a8ebd43 /sanitycheck.cgi
parent3277ac732e00522fbe403350b24054361413aca1 (diff)
downloadbugzilla-de1f3fe949ff898bb9c26994be8e7a56968e3a9a.tar.gz
bugzilla-de1f3fe949ff898bb9c26994be8e7a56968e3a9a.tar.xz
Bug 298024: Incorrect group control check in sanitycheck.cgi - Patch by Frédéric Buclin <LpSolit@gmail.com> r=joel a=myk
Diffstat (limited to 'sanitycheck.cgi')
-rwxr-xr-xsanitycheck.cgi19
1 files changed, 9 insertions, 10 deletions
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 <code>SHOWN</code>)');
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");