Bug 14637: Fix add patron category under MySQL 5.7
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 6 Sep 2016 09:40:46 +0000 (10:40 +0100)
committerMason James <mtj@kohaaloha.com>
Tue, 24 Jan 2017 23:43:16 +0000 (12:43 +1300)
commit047c31b4246bb5eb0f20238355190f9535dc4721
tree267f1d6be770b5b957ab6614846e0e5db4452aab
parentf75437546fcfbbd931e9577dc428f9c52ed13beb
Bug 14637: Fix add patron category under MySQL 5.7

If no dateofbirthrequired or upperagelimit is set on the interface, the
->store method will receive an empty string defined for these values.
For INT field, we must explicitely set these empty value to undef
instead to avoid MySQL 5.7 (and strict mode) to raise:
  DBD::mysql::st execute failed: Incorrect integer value: ' for column
'dateofbirthrequired''

Test plan:
Using MySQL 5.7 (and/or sql_mode=STRICT_TRANS_TABLES)
Create a patron category without specifying upperagelimit or
dateofbirthrequired

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Mason James <mtj@kohaaloha.com>
Koha/Patron/Category.pm