[Koha] Issue with the Issues Table
Shar Shar
disharum at yahoo.com
Wed Mar 18 15:54:08 NZDT 2009
I have a problem charging items to patrons. While the items table is updated properly when items are checkedout, the issues table is not affected. It seems to be a foreign key issue. This is on Koha 3.0.1. Here is the error message:
[error] [client 99.87.456.1] [Tue Mar 17 22:39:58 2009] circulation.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha/issues`, CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items~` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL) at /usr/share/koha/lib/C4/Circulation.pm line 967., referer: http://mysite.blabla.org:8080/cgi-bin/koha/circ/circulation.pl
Has anybody encountered this? Is it a bug? Thanks.
Shar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090317/3332452e/attachment.htm
More information about the Koha
mailing list