Bugzilla – Attachment 36157 Details for
Bug 13740
Timeout on deleting patrons if too many patrons
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13740: Fix null vs not null in the query
Bug-13740-Fix-null-vs-not-null-in-the-query.patch (text/plain), 800 bytes, created by
Jonathan Druart
on 2015-02-25 09:55:49 UTC
(
hide
)
Description:
Bug 13740: Fix null vs not null in the query
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2015-02-25 09:55:49 UTC
Size:
800 bytes
patch
obsolete
>From f65fd7e682a58779515e9276fbb262f383c601a5 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! >--- > 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; >-- >2.1.0
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=36157">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13740
:
36096
|
36150
|
36157
|
36410
|
36411
|
36873
|
36874