Summary: | datelastseen and datelastborrowed out of sync | ||
---|---|---|---|
Product: | Koha | Reporter: | Magnus Enger <magnus> |
Component: | Circulation | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | black23, gmcharlt, jonathan.druart, kyle.m.hall |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Magnus Enger
2018-10-01 07:57:07 UTC
What are the values? SELECT datelastborrowed, datelastseen FROM items WHERE datelastborrowed > datelastseen LIMIT 10; MariaDB [koha_bth]> SELECT datelastborrowed, datelastseen FROM items WHERE datelastborrowed > datelastseen LIMIT 10; +------------------+--------------+ | datelastborrowed | datelastseen | +------------------+--------------+ | 2018-09-13 | 2018-06-25 | | 2018-09-05 | 2015-10-09 | | 2018-09-05 | 2018-02-08 | | 2018-09-10 | 2017-12-14 | | 2018-06-08 | 2018-04-10 | | 2018-04-30 | 2016-10-20 | | 2018-07-10 | 2017-06-08 | | 2018-01-24 | 2017-01-19 | | 2018-07-31 | 2018-02-01 | | 2018-07-10 | 2018-01-16 | +------------------+--------------+ Sorry I do not have any ideas, the code looks ok. Maybe in September 2018 the Koha version was older? What is the % of items with this problem? Does it still happen? This was either an artifact of the migration to Koha, or it stopped happening in March 2018. Closing. |