From b0f29bcb2d55dc5e9a329b66d580f6e4eabbfb53 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
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 <koha.aixmarseille@gmail.com>
---
 C4/Members.pm |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index c1b4b1e..23b489f 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -2126,7 +2126,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;
-- 
1.7.10.4