Hi all, We are getting closer. When we checkin an item in the staff interface ... the current location is also empty. So it's not SIP that causes this problem ... What should we do to make sure a 'item checkin' will get a current location; now it's empty and that causes the SIP server to crash at a 'check-out'. Best regards, Jan From: Nijnatten, Jan van Sent: Monday 2 November 2009 17:01 To: koha@lists.katipo.co.nz Subject: RE: SIP server error: losing current location 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@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@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@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.