From 25d9198e0887b32ce5b156050ddb3d62605e8762 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 30 Dec 2009 16:50:46 +0100 Subject: [PATCH] [followup](bug #3667) don't delete if member is guarantor this fix cleanborrowers to don't delete guanrantors. --- C4/Members.pm | 1 + 1 file changed, 1 insertion(+) diff --git a/C4/Members.pm b/C4/Members.pm index 7644c36132..bd9e60b299 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -1878,6 +1878,7 @@ sub GetBorrowersWhoHaveNotBorrowedSince { LEFT JOIN old_issues USING (borrowernumber) LEFT JOIN issues USING (borrowernumber) WHERE category_type <> 'S' + AND borrowernumber NOT IN (SELECT guarantorid FROM borrowers WHERE guarantorid IS NOT NULL AND guarantorid <> 0) "; my @query_params; if ($filterbranch && $filterbranch ne ""){ -- 2.39.5