Bugzilla – Attachment 63382 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]
Bug 17257: Fix add/edit patrons under MySQL 5.7
Bug-17257-Fix-addedit-patrons-under-MySQL-57.patch (text/plain), 1.25 KB, created by
Julian Maurice
on 2017-05-11 11:09:56 UTC
(
hide
)
Description:
Bug 17257: Fix add/edit patrons under MySQL 5.7
Filename:
MIME Type:
Creator:
Julian Maurice
Created:
2017-05-11 11:09:56 UTC
Size:
1.25 KB
patch
obsolete
>From a93f1b71c7d6606ac31a3fdc5d97e13fdd69a66d 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] 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> > >Tested with MariaDB 10.0.30 (sql_mode='STRICT_TRANS_TABLES') >Signed-off-by: Julian Maurice <julian.maurice@biblibre.com> >--- > C4/Members.pm | 1 + > 1 file changed, 1 insertion(+) > >diff --git a/C4/Members.pm b/C4/Members.pm >index 3e37aa4214..cf7ea7cc22 100644 >--- a/C4/Members.pm >+++ b/C4/Members.pm >@@ -494,6 +494,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.11.0
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