Bug 1472 - Foreign key constraint fails on item checkout
Summary: Foreign key constraint fails on item checkout
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: Main
Hardware: All All
: P3 blocker (vote)
Assignee: Chris Cormack
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-05 04:56 UTC by Chris Cormack
Modified: 2019-06-27 09:24 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 00:30:52 UTC


---- Reported by jmf@liblime.com 2007-10-05 16:56:01 ----

checkout a book to a patron:

[Fri Oct 05 18:54:58 2007] [error] [client 71.171.150.91] [Fri Oct  5 18:54:58 2007] circulation.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`jmf_koha/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/jmf/koha/production/intranet/modules/C4/Circulation.pm line 1013., referer: http://staff-jmf.dev.kohalibrary.com/cgi-bin/koha/circ/circulation.pl?findborrower=1



---- Additional Comments From jmf@liblime.com 2007-10-05 16:58:22 ----

this only happens for the kohaadmin user ... it's OK :-)



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:30 UTC  ---

This bug was previously known as _bug_ 1472 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=1472

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was jmf@liblime.com.