summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--Bugzilla/User.pm4
1 files changed, 2 insertions, 2 deletions
diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm
index 8df1316c5..d6c1f1225 100644
--- a/Bugzilla/User.pm
+++ b/Bugzilla/User.pm
@@ -1431,10 +1431,10 @@ sub get_enterable_products {
WHERE ' . $dbh->sql_in('products.id', $enterable_ids) .
' AND products.id IN (SELECT DISTINCT components.product_id
FROM components
- WHERE components.isactive = 1)
+ WHERE components.isactive = 1 AND products.id = components.product_id)
AND products.id IN (SELECT DISTINCT versions.product_id
FROM versions
- WHERE versions.isactive = 1)');
+ WHERE versions.isactive = 1 AND products.id = versions.product_id)');
}
$self->{enterable_products} =