https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43546 Alex Carver [Acerock7] <alex@rcls.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alex@rcls.org --- Comment #9 from Alex Carver [Acerock7] <alex@rcls.org> --- Adding this here, because I believe it's an issue with the original cart_to_shelf.pl logic and not the updated script: Because 0 is no longer an option, the smallest option is now 1. However, because it's a whole integer, an item will only ever have a timestaff difference of >1 after it's been on the cart for 2 hours. So using this updated script it's impossible to put an item back to its original location after it's been on the cart for an hour. For "TIMESTAMPDIFF(HOUR, items.timestamp, NOW() ) > 1" to be true, it'd need to have been on the cart for 2 hours or more. Updating the logic to be: "SELECT itemnumber FROM items WHERE location = 'CART' AND TIMESTAMPDIFF(HOUR, items.timestamp, NOW() ) >= ?" fixes that issue in my testing. But I'm not experienced enough to know whether there's a deeper reasoning for the original logic or if adding >= messes with anything else behind the scenes. -- You are receiving this mail because: You are watching all bug changes.