| 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 |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | 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. |