[Koha] SIP server error: losing current location

[Nijnatten, Jan van]

Hi all,

Now I can be more specific; hopefully someone can help us.

I am running the C4/SIP/t/SIPtest.pm tests. The third one is testing checkout.
The test output:

koha at olympia:~/source/C4/SIP/t$ perl -I.. 03checkout.t
1..6
ok 1 - login
ok 2 - SC status
ok 3 - Checkout: valid item, valid patron
ok 4 - Checkout: cleanup: check in item
ok 5 - Checkout: valid patron, invalid item
ok 6 - Checkout: invalid patron, valid item

The SIP error logfile returns:

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`salvador/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/koha/source//C4/Items.pm line 1999.
ERROR in _koha_modify_item UPDATE items SET itemnumber=?,holdingbranch=? WHERE itemnumber=?Cannot add or update a child row: a foreign key constraint fails (`salvador/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /home/koha/source//C4/Items.pm line 2002.
DBD::mysql::st execute failed: Column 'tobranch' cannot be null at /home/koha/source//C4/Items.pm line 530.
new ILS::Item(no-barcode) : No item 'no-barcode'. at /ILS/Item.pm line 88.
read_SIP_packet ERROR: Bad file descriptor at /Sip.pm line 167, <STDIN> chunk 7.


Now, when I look in Koha to that particular item, the location is gone.
See http://www.extra.research.philips.com/LocationGone.png  for a screenshot.


When I run the test again (the location field in Koha is empty now) the tests fail (ofcourse):

koha at olympia:~/source/C4/SIP/t$ perl -I.. 03checkout.t
1..6
ok 1 - login
ok 2 - SC status
Bail out!  Read failure in Checkout: valid item, valid patron

With the SIP error logfile:

No branchcode argument to new.  Should be C4::Calendar->new(branchcode => $branchcode) at /home/koha/source//C4/Circulation.pm line 2324


So the question remains:
Why does the SIP server empty the "location" field in Koha when checking out (or check in) an item?

Please help.

Jan





-----Original Message-----
From: Nijnatten, Jan van
Sent: Thursday 29 October 2009 16:21
To: koha at lists.katipo.co.nz
Subject: SIP server and losing current location



Hi all,



We have set up Koha (latest, 3.00.04) on Debian lenny.

We are also running the SIP server.



When we connect to the SIP server (either via telnet or raw) and we checkin a book the "current location" field is set to empty. Why? How do we prevent that?

Checking out after that gives a branch error (ofcourse).



Anyone know wher to look for the cause?



best regards,

Jan



Jan van Nijnatten MSc | information architect  |  Philips Research

________________________________
The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091102/26b5f5a0/attachment-0001.htm