[Bug 15305] New: KOHA SIP2 checkout doesn't update of the item holding status
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Bug ID: 15305 Summary: KOHA SIP2 checkout doesn't update of the item holding status Change sponsored?: --- Product: Koha Version: 3.20 Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: SIP2 Assignee: koha-bugs@lists.koha-community.org Reporter: fridayjune@gmail.com QA Contact: testopia@bugs.koha-community.org CC: colin.campbell@ptfs-europe.com Created attachment 45410 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=45410&action=edit 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Comment on attachment 45410 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=45410 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 june <fridayjune@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion --- Comment #2 from june <fridayjune@gmail.com> --- (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? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Bob Birchall <bob@calyx.net.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bob@calyx.net.au -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj@kohaaloha.com --- Comment #3 from Mason James <mtj@kohaaloha.com> --- (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? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #5 from june <fridayjune@gmail.com> --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #6 from Mason James <mtj@kohaaloha.com> ---
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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #7 from Mason James <mtj@kohaaloha.com> --- (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? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #8 from june <fridayjune@gmail.com> --- It has branchecode.This are items and branches tables screenshot: https://goo.gl/jFpnHz https://goo.gl/GZOsFw -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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">. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #10 from june <fridayjune@gmail.com> --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #11 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Is the error still shown when you check out an item now? The one you copied from the log? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Liz Rea <liz@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |liz@catalyst.net.nz --- Comment #12 from Liz Rea <liz@catalyst.net.nz> --- related to Bug 14673? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #13 from Liz Rea <liz@catalyst.net.nz> --- (possibly a red herring) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #14 from Liz Rea <liz@catalyst.net.nz> --- June, Which minor version of Koha are you on (that's the 3rd number)? Liz -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #15 from june <fridayjune@gmail.com> --- 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |RESOLVED Resolution|--- |INVALID --- Comment #16 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi June, thank you for the feedback, glad it works now. :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305 --- Comment #17 from Liz Rea <liz@catalyst.net.nz> --- Yay! Glad you're sorted. :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org