https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 --- Comment #12 from Josef Moravec <josef.moravec@gmail.com> --- (In reply to Jonathan Druart from comment #11)

(In reply to Josef Moravec from comment #10)

...

So it looks like this kind of issue could be in more places, is it true?

I agree with you, that it would be better to fix it generally, but I have no idea, how to do it...

But if we'd go with this solution, I am adding sign-off as it works as described.

Could you prove the tests from this bug without the changes to Koha::Patron::Category->store and apply bug 17080 and see if they pass with MySQL5.7?

I tried, but unfortunately, the test failed with this error message: t/db_dependent/Koha/Patron/Categories.t .. 1/8 DBD::mysql::st execute failed: Incorrect integer value: '' for column 'dateofbirthrequired' at row 1 [for Statement "INSERT INTO `categories` ( `category_type`, `categorycode`, `dateofbirthrequired`, `description`, `upperagelimit`) VALUES ( ?, ?, ?, ?, ? )" with ParamValues: 0='A', 1='mycatcodeW', 2='', 3='mycatdescW', 4=''] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'dateofbirthrequired' at row 1 at /home/vagrant/kohaclone/Koha/Object.pm line 119 # Looks like your test exited with 255 just after 8. t/db_dependent/Koha/Patron/Categories.t .. Dubious, test returned 255 (wstat 65280, 0xff00) All 8 subtests passed Test Summary Report ------------------- t/db_dependent/Koha/Patron/Categories.t (Wstat: 65280 Tests: 8 Failed: 0) Non-zero exit status: 255 Files=1, Tests=8, 1 wallclock secs ( 0.01 usr 0.00 sys + 0.51 cusr 0.27 csys = 0.79 CPU) Result: FAIL Maybe I unterstand it wrong but 17080 handles NOT NULL columns and upperagelimit and dateofbirthrequired are nullable... -- You are receiving this mail because: You are watching all bug changes.