[Koha-bugs] [Bug 17069] Can't create new patron category on the intranet

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Aug 8 09:23:01 CEST 2016


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

Marc Véron <veron at veron.ch> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |veron at veron.ch

--- Comment #2 from Marc Véron <veron at veron.ch> ---
Confirmed.

That's what I get in plack-error.log when adding a new patron category:

DBD::mysql::st execute failed: Column 'checkprevcheckout' cannot be null [for
Statement "INSERT INTO `categories` ( `BlockExpiredPatronOpacActions`,
`category_type`, `categorycode`, `checkprevcheckout`, `dateofbirthrequired`,
`default_privacy`, `description`, `enrolmentfee`, `enrolmentperiod`,
`enrolmentperioddate`, `hidelostitems`, `overduenoticerequired`, `reservefee`,
`upperagelimit`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with
ParamValues: 0="-1", 1="A", 2="B17069A", 3=undef, 4="", 5="default", 6="Bug
17069 A", 7="0.00", 8="12", 9=undef, 10="0", 11="0", 12="0.00", 13=""] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`borrower_message_preferences`, CONSTRAINT
`borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`) ON DELETE CASCADE ON UPDAT) [for Statement
"INSERT INTO borrower_message_preferences
(borrower_message_preference_id, borrowernumber, categorycode,
message_attribute_id, days_in_advance, wants_digest)
VALUES
(NULL, ?, ?, ?, ?, ?)
" with ParamValues: 0=undef, 1="B17069A", 2=1, 3=undef, 4=0] at
/home/marc/koha/C4/Members/Messaging.pm line 164.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`borrower_message_preferences`, CONSTRAINT
`borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`) ON DELETE CASCADE ON UPDAT) [for Statement
"INSERT INTO borrower_message_preferences
(borrower_message_preference_id, borrowernumber, categorycode,
message_attribute_id, days_in_advance, wants_digest)
VALUES
(NULL, ?, ?, ?, ?, ?)
" with ParamValues: 0=undef, 1="B17069A", 2=2, 3="0", 4=0] at
/home/marc/koha/C4/Members/Messaging.pm line 164.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`borrower_message_preferences`, CONSTRAINT
`borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`) ON DELETE CASCADE ON UPDAT) [for Statement
"INSERT INTO borrower_message_preferences
(borrower_message_preference_id, borrowernumber, categorycode,
message_attribute_id, days_in_advance, wants_digest)
VALUES
(NULL, ?, ?, ?, ?, ?)
" with ParamValues: 0=undef, 1="B17069A", 2=4, 3=undef, 4=0] at
/home/marc/koha/C4/Members/Messaging.pm line 164.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`borrower_message_preferences`, CONSTRAINT
`borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`) ON DELETE CASCADE ON UPDAT) [for Statement
"INSERT INTO borrower_message_preferences
(borrower_message_preference_id, borrowernumber, categorycode,
message_attribute_id, days_in_advance, wants_digest)
VALUES
(NULL, ?, ?, ?, ?, ?)
" with ParamValues: 0=undef, 1="B17069A", 2=5, 3=undef, 4=0] at
/home/marc/koha/C4/Members/Messaging.pm line 164.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`borrower_message_preferences`, CONSTRAINT
`borrower_message_preferences_ibfk_3` FOREIGN KEY (`categorycode`) REFERENCES
`categories` (`categorycode`) ON DELETE CASCADE ON UPDAT) [for Statement
"INSERT INTO borrower_message_preferences
(borrower_message_preference_id, borrowernumber, categorycode,
message_attribute_id, days_in_advance, wants_digest)
VALUES
(NULL, ?, ?, ?, ?, ?)
" with ParamValues: 0=undef, 1="B17069A", 2=6, 3=undef, 4=0] at
/home/marc/koha/C4/Members/Messaging.pm line 164.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list