https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18745
Victor Grousset/tuxayo <victor.grous...@biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |victor.grous...@biblibre.co
| |m
--- Comment #6 from Victor Grousset/tuxayo <victor.grous...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
