Created attachment 45410 [details] KOHA_SIP2_Checkout I am using KOHA version 3.20 and I am able to check out the item, but the item status is always showing Available. 1) This is my checkout message: 11NN20151202 08062920151227 030629AOmylib|AAthida|ABB1246857|AC| 2) This is my institution policy in SIPconfig.xml. <institution id="mylib" implementation="ILS" parms=""> <policy checkin="true" renewal="true" checkout="true" status_update="true" offline="false" timeout="100" retries="5"/> </institution> 3) The first item is checked out by using SIP2 in the following screenshot.
Comment on attachment 45410 [details] KOHA_SIP2_Checkout It looks like this issue is caused by the fact that the items.onloan is not updated correctly with the due date, while the entry in the issues table is correct.
(In reply to Katrin Fischer from comment #1) > Comment on attachment 45410 [details] > KOHA_SIP2_Checkout > > It looks like this issue is caused by the fact that the items.onloan is not > updated correctly with the due date, while the entry in the issues table is > correct. How can I solve to update the item.onloan correctly?
(In reply to Katrin Fischer from comment #1) > Comment on attachment 45410 [details] > KOHA_SIP2_Checkout > > It looks like this issue is caused by the fact that the items.onloan is not > updated correctly with the due date, while the entry in the issues table is > correct. hi Katrin, did you confirm this bug, yourself?
Sorry, I didn't confirm via SIP - should have been more clear in my comment. We discussed it on IRC and came to the conclusion that this would cause the display we can see at the detail page - checked out and available at the same time. I think you will see the same as the screenshot, if you check out an item and then reset the items.onloan to null/empty. We definitely still need to test and confirm this with SIP.
I got this error for SIP checkout although the item has been successfully checked out and display available status at the detail page. DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at C4/Items.pm line 2384. ERROR in _koha_modify_item UPDATE items SET issues=?,datelastborrowed=?,holdingbranch=?,itemlost_on=?,itemlost=?,onloan=? WHERE itemnumber=?: Cannot add or update a child row: a foreign key constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at C4/Items.pm line 2387.
> We definitely still need to test and confirm this with SIP. some good news... I issued an item via SIP, and the incorrect 'available' text was not shown. so 'works for me' on Koha-3.20.6 also, items.onloan column was correctly populated too
(In reply to june from comment #5) > I got this error for SIP checkout although the item has been successfully > checked out and display available status at the detail page. > > DBD::mysql::st execute failed: Cannot add or update a child row: a foreign > key constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3` > FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE > CASCADE) at C4/Items.pm line 2384. > ERROR in _koha_modify_item UPDATE items SET > issues=?,datelastborrowed=?,holdingbranch=?,itemlost_on=?,itemlost=?, > onloan=? WHERE itemnumber=?: Cannot add or update a child row: a foreign key > constraint fails (`koha_dev_koha`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN > KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE > CASCADE) at C4/Items.pm line 2387. ^... i think that error is caused by your item having a $branchcode that does not exist in the 'branches' table?
It has branchecode.This are items and branches tables screenshot: https://goo.gl/jFpnHz https://goo.gl/GZOsFw
Hi Mason, thx for testing! I was worried about this one. June, could you check 2 things in your installation? - Make sure there is no space/whitespace after your branchcodes. It's a bit hard to see, but I had that happen and it was no fun :) - Check your SIP configuration carefully - I think <institution id="mylib" should actually be your branchcode - <institution id="MK">.
Hi Katrin, I have checked 2 things. There is no whitespace in branchcodes. And , I have already changed <institution id="MK">. But, It is still showing available status for checked out item.
Is the error still shown when you check out an item now? The one you copied from the log?
related to Bug 14673?
(possibly a red herring)
June, Which minor version of Koha are you on (that's the 3rd number)? Liz
Hi Katrin and Mason, Thanks. It has been solved after changing institution id and restart the server and SIP. Hi Liz, My KOHA version is 3.20.05.000
Hi June, thank you for the feedback, glad it works now. :)
Yay! Glad you're sorted. :)