From 316485b1c4bb1cfa4c0de19e857e692d34351234 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 25 Feb 2015 10:44:00 +0100 Subject: [PATCH] Bug 13740: Fix null vs not null in the query The previous patch did not work, only patrons *with* guanrantees were deleted! Signed-off-by: Koha Team AMU Signed-off-by: Kyle M Hall Signed-off-by: Tomas Cohen Arazi --- C4/Members.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Members.pm b/C4/Members.pm index 7c3f9f6772..4ca83b9b2b 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -2124,7 +2124,7 @@ sub GetBorrowersToExpunge { LEFT JOIN old_issues USING (borrowernumber) LEFT JOIN issues USING (borrowernumber) WHERE category_type <> 'S' - AND tmp.guarantorid IS NOT NULL + AND tmp.guarantorid IS NULL |; my @query_params; -- 2.39.5