https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17069 Bug ID: 17069 Summary: Can't creat news patron category on the intranet Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: Linux Status: NEW Severity: blocker Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: cyrille.duverne@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Hello, I get an error as soon as I try to create a new patrons category. Which is blocking since it's my primary one. Page : "/cgi-bin/koha/admin/categories.pl" Error message : "An error occurred when updating this patron category. Perhaps it already exists." Error in MySQL : [Sat Aug 06 19:53:54.455457 2016] [cgi:error] [pid 9145] [client 127.0.0.1:41044] AH01215: [Sat Aug 6 19:53:54 2016] categories.pl: DBD::mysql::st execute failed: Incorrect integer value: '' for column 'dateofbirthrequired' at row 1 [for Statement "UPDATE `categories` SET `dateofbirthrequired` = ?, `enrolmentfee` = ?, `enrolmentperiod` = ?, `overduenoticerequired` = ?, `reservefee` = ?, `upperagelimit` = ? WHERE ( `categorycode` = ? )" with ParamValues: 0="", 1="", 2="", 3="0", 4="", 5="", 6="LIBRA"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834.: /usr/share/koha/intranet/cgi-bin/admin/categories.pl, Looks like some mandatory values aren't passed. See a working query on the DB : INSERT INTO categories VALUES('LIBRA','Librarians','150','9999/12/31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',"S","-1","default"); -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.