[Bug 28440] New: Inventory tool tries to put a time into DateLastSeen
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Bug ID: 28440 Summary: Inventory tool tries to put a time into DateLastSeen Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org When using the inventory tool, Koha attempts to write a date and time into the datelastseen field. Since that's a date field, the update fails and the item ends up with 0000-00-00 for the date. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dstephen@dubuque.lib.ia.us -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |critical -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 --- Comment #1 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- This may be a red herring. I thought I saw this behavior on a library's site but have been unable to recreate thus far. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |normal CC| |martin.renvoize@ptfs-europe | |.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=28015 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 --- Comment #2 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Still fighting with this, but running theory is it fails in the afternoon if one is using 12-hour time. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|master |20.05 --- Comment #3 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- I've been able to recreate this behavior on 20.05, but only in the afternoon :) To recreate: - Set TimeFormat to 12 Hour - make sure cataloging log is on - wait until afternoon - have an item with barcode "TEST" and callnumber "9999" - in Inventory, upload a text file of just the barcode "TEST," limit inventory to callnumber range 9999-9999 - submit inventory, it tells you it set Date Last Seen to today for 1 item - go to item, confirm it shows a null Date Last Seen - look at the modification log, see Koha tried to put a date and time into Date Last Seen -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I've tried to replicate the issue on master, but it all seemed to work alright. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |31143 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143 [Bug 31143] We should attempt to fix/identify all cases where '0000-00-00' may still remain in the database -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28440 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org