summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--CGI.pl2
-rwxr-xr-xeditproducts.cgi2
2 files changed, 2 insertions, 2 deletions
diff --git a/CGI.pl b/CGI.pl
index 8d42eb4cc..31ed48e3d 100644
--- a/CGI.pl
+++ b/CGI.pl
@@ -304,7 +304,7 @@ sub GetBugActivity {
if (Param("insidergroup") && !UserInGroup(Param('insidergroup'))) {
$suppjoins = "LEFT JOIN attachments
ON attachments.attach_id = bugs_activity.attach_id";
- $suppwhere = "AND NOT(COALESCE(attachments.isprivate,0))";
+ $suppwhere = "AND COALESCE(attachments.isprivate, 0) = 0";
}
my $query = "
SELECT COALESCE(fielddefs.description, bugs_activity.fieldid),
diff --git a/editproducts.cgi b/editproducts.cgi
index db391228b..ea4bc5e5b 100755
--- a/editproducts.cgi
+++ b/editproducts.cgi
@@ -339,7 +339,7 @@ unless ($action) {
my $query = "SELECT products.name,
COALESCE(products.description,'') AS description,
- NOT(disallownew) AS status,
+ disallownew = 0 AS status,
votesperuser, maxvotesperbug, votestoconfirm,
COUNT(bug_id) AS bug_count
FROM products";