[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #17 from Liz Rea  ---
Yay! Glad you're sorted. :)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #11 from Katrin Fischer  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #14 from Liz Rea  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #13 from Liz Rea  ---
(possibly a red herring)

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

Liz Rea  changed:

   What|Removed |Added

 CC||l...@catalyst.net.nz

--- Comment #12 from Liz Rea  ---
related to Bug 14673?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #15 from june  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

Katrin Fischer  changed:

   What|Removed |Added

 Status|In Discussion   |RESOLVED
 Resolution|--- |INVALID

--- Comment #16 from Katrin Fischer  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

Mason James  changed:

   What|Removed |Added

 CC||m...@kohaaloha.com

--- Comment #3 from Mason James  ---
(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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #10 from june  ---
Hi Katrin,
I have checked 2 things. There is no whitespace in branchcodes. And , I have
already changed .
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #4 from Katrin Fischer  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #8 from june  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #5 from june  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #6 from Mason James  ---
> 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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #9 from Katrin Fischer  ---
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 .

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

--- Comment #7 from Mason James  ---
(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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

june  changed:

   What|Removed |Added

 Status|NEW |In Discussion

--- Comment #2 from june  ---
(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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

Bob Birchall  changed:

   What|Removed |Added

 CC||b...@calyx.net.au

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 15305] KOHA SIP2 checkout doesn't update of the item holding status

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15305

Katrin Fischer  changed:

   What|Removed |Added

 CC||katrin.fisc...@bsz-bw.de

--- Comment #1 from Katrin Fischer  ---
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.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/