|

»

SIP server and losing current location

View: New views

5 Messages — Rating Filter: Alert me

	SIP server and losing current location by Nijnatten, Jan van :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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. _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha
	Re: SIP server error: losing current location by Nijnatten, Jan van :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. 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@... 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. _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha
	Re: losing current location (NOT a SIP problem) by Nijnatten, Jan van :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. 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@... 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@... 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. _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha
	Re: losing current location (NOT a SIP problem) by Chris Cormack-6 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/11/3 Nijnatten, Jan van <jan.v.nijnatten@...>: > Hi all, > > > > We are getting closer. When we checkin an item in the staff interface … the > current location is also empty. > What branch do you have selected? Chris _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha
	Re: losing current location (NOT a SIP problem) by Nijnatten, Jan van :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi Chris, Do you mean HomeOrHoldingBranch? We've set that to holdingbranch. In the upper right corner of the staff interface we've set the library to our default library (we only have one). Please tell me if you need more info to solve this one.... Best regards, Jan -----Original Message----- From: Chris Cormack [mailto:chris@...] Sent: Tuesday 3 November 2009 10:52 To: Nijnatten, Jan van Cc: koha@... Subject: Re: [Koha] losing current location (NOT a SIP problem) 2009/11/3 Nijnatten, Jan van <jan.v.nijnatten@...>: > Hi all, > > > > We are getting closer. When we checkin an item in the staff interface ... the > current location is also empty. > What branch do you have selected? Chris 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. _______________________________________________ Koha mailing list Koha@... http://lists.katipo.co.nz/mailman/listinfo/koha