diff options
-rw-r--r-- | CGI.pl | 2 | ||||
-rwxr-xr-x | editproducts.cgi | 2 |
2 files changed, 2 insertions, 2 deletions
@@ -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"; |