[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