[Koha-bugs] [Bug 18745] Serial claims: save supplier info on serial-level

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

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

Victor Grousset/tuxayo <victor.grousset at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |victor.grousset at biblibre.co
                   |                            |m

--- Comment #6 from Victor Grousset/tuxayo <victor.grousset at biblibre.com> ---
Hi, when creating a serial without a vendor, there is an internal server error.

logs:

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha`.`serial`, CONSTRAINT `serial_aqbooksellerid_fk`
FOREIGN KEY (`aqbooksellerid`) REFERENCES `aqbooksellers` (`id`)) [for
Statement "INSERT INTO `serial` ( `aqbooksellerid`, `biblionumber`,
`planneddate`, `publisheddate`, `serialseq`, `serialseq_x`, `serialseq_y`,
`serialseq_z`, `status`, `subscriptionid`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?,
? )" with ParamValues: 0='0', 1="12345", 2='2019-01-01', 3='2019-01-01', 4='Vol
145, No 1,2019', 5='145', 6='1', 7='2019', 8=1, 9='123'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834.
DBIx::Class::Storage::DBI::_dbh_execute(): Cannot add or update a child row: a
foreign key constraint fails (`koha`.`serial`, CONSTRAINT
`serial_aqbooksellerid_fk` FOREIGN KEY (`aqbooksellerid`) REFERENCES
`aqbooksellers` (`id`)) at /home/koha/src/Koha/Object.pm line 121

It seems that the issue is that 0 is trying to get in "aqbooksellerid".

And there is no aqbooksellers.aqbooksellerid egal to 0

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