[Koha-bugs] [Bug 17069] New: Can't creat news patron category on the intranet

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Sat Aug 6 19:59:22 CEST 2016


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 at lists.koha-community.org
          Reporter: cyrille.duverne at gmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at 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.


More information about the Koha-bugs mailing list