[Koha-bugs] [Bug 17257] Cannot create a patron under MySQL 5.7

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu May 11 13:09:56 CEST 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17257

--- Comment #10 from Julian Maurice <julian.maurice at biblibre.com> ---
Created attachment 63382
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=63382&action=edit
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 at catalyst.net.nz>

Tested with MariaDB 10.0.30 (sql_mode='STRICT_TRANS_TABLES')
Signed-off-by: Julian Maurice <julian.maurice at biblibre.com>

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list