[Koha-bugs] [Bug 14637] Add patron category fails with MySQL 5.6.26

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #12 from Josef Moravec <josef.moravec at 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.