[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