From d89ab1202b5e50913b8a861e9d0ec9d384af06fc Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sun, 18 Mar 2007 04:45:39 +0000 Subject: [PATCH] r1492: Apparently MySQL doesn't think that NULL values should be included in !parentid which causes not all the products to be displayed in the product-level permissions --- admin/permission.php | 2 +- docs/changes.txt | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/admin/permission.php b/admin/permission.php index 780a11a..0b40160 100755 --- a/admin/permission.php +++ b/admin/permission.php @@ -199,7 +199,7 @@ if ($_REQUEST['do'] == 'modify') $permissions["$permission[productid]"] = $permission['mask']; } - $products_fetch = $db->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE !parentid ORDER BY displayorder ASC"); + $products_fetch = $db->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE !parentid OR parentid IS NULL ORDER BY displayorder ASC"); while ($product = $db->fetch_array($products_fetch)) { $groupid = $group['usergroupid']; diff --git a/docs/changes.txt b/docs/changes.txt index 1e464f7..4805c1c 100644 --- a/docs/changes.txt +++ b/docs/changes.txt @@ -10,6 +10,7 @@ - Fixed: Automations wouldn't properly save custom field changes in the admin section - Fixed: Automations would have no effect on custom fields when running them from the edit screen - Fixed: A SQL error would occur when saving creating a new usergroup +- Fixed: In the product-level permissions screens, not all the products would always show up 1.2.0 Beta 1 =============================== -- 2.43.5