]> git.koha-community.org Git - koha.git/commit
Bug 17257: Fix add/edit patrons under MySQL 5.7
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 6 Sep 2016 09:12:20 +0000 (10:12 +0100)
committerMason James <mtj@kohaaloha.com>
Wed, 24 May 2017 02:26:24 +0000 (14:26 +1200)
commitc1227d9d786a648cb190a83cb0ff85f067f808b6
tree7be4481231ffb13bc871fa8644ac6061e8415fe7
parent9b37ca8cadfcc2b5ed838a87711a3b7f58abeac8
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>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 720071004516ec4e119dc5ec7f9538b56313b186)
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
C4/Members.pm