Bugzilla – Attachment 61425 Details for
Bug 17257
Cannot create a patron under MySQL 5.7
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 17257: Fix add/edit patrons under MySQL 5.7
SIGNED-OFF-Bug-17257-Fix-addedit-patrons-under-MyS.patch (text/plain), 1.13 KB, created by
Srdjan Jankovic
on 2017-03-22 01:40:05 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 17257: Fix add/edit patrons under MySQL 5.7
Filename:
MIME Type:
Creator:
Srdjan Jankovic
Created:
2017-03-22 01:40:05 UTC
Size:
1.13 KB
patch
obsolete
>From 13ab122438d8a473751bc23914d788717c0f95b8 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Tue, 6 Sep 2016 10:12:20 +0100 >Subject: [PATCH] [SIGNED-OFF] Bug 17257: Fix add/edit patrons under MySQL 5.7 > >If no guarantor is defined the patron won't be added/modified and an >error will be raised: > >DBD::mysql::st execute failed: Incorrect integer value: '' for column >'guarantorid' > >Test plan: >Using MySQL 5.7 (and/or sql_mode=STRICT_TRANS_TABLES) >Create a patron without guarantor > >Signed-off-by: Srdjan <srdjan@catalyst.net.nz> >--- > C4/Members.pm | 1 + > 1 file changed, 1 insertion(+) > >diff --git a/C4/Members.pm b/C4/Members.pm >index 8e73872..95e306c 100644 >--- a/C4/Members.pm >+++ b/C4/Members.pm >@@ -478,6 +478,7 @@ sub AddMember { > $data{'dateofbirth'} = undef if ( not $data{'dateofbirth'} ); > $data{'debarred'} = undef if ( not $data{'debarred'} ); > $data{'sms_provider_id'} = undef if ( not $data{'sms_provider_id'} ); >+ $data{'guarantorid'} = undef if ( not $data{'guarantorid'} ); > > # get only the columns of Borrower > # FIXME Do we really need this check? >-- >2.7.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 17257
:
55231
|
61425
|
63382