Bug 23242: Fix insert of Z3950 servers with strict SQL modes
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Sun, 4 Aug 2019 17:48:07 +0000 (12:48 -0500)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 16 Aug 2019 10:39:24 +0000 (11:39 +0100)
commita9c730244768ea355004e821d5be35dc2e617840
tree5e1c98027fd6e63d45c1866b8659c57a67888b41
parentf9572dd1acd9f39229d8cd864050a536b9c2815d
Bug 23242: Fix insert of Z3950 servers with strict SQL modes

If strict SQL modes are set, the insertion of a new Z3950 server can
fail.

DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: ''
for column 'checked' at row 1 at
/home/vagrant/kohaclone/admin/z3950servers.pl line 82

Using Koha::Z3950Servers fixes the issue (handled from
Koha::Object->store)

Test plan:
- Turn the strict SQL modes on (config strict_sql_modes)
- Create a new Z3950 server filling only the mandatory fields.
=> Without this patch you will get the failure, with this patch applied
the server will be inserted sucessfully
- Delete it
=> No regression should be found
- Search for servers
=> No regression should be found (the search is a start-with, LIKE "$pattern%")

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
admin/z3950servers.pl