https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24677
Bug ID: 24677
Summary: wrong year picked in serials
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Serials
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
From bug 24002:
commit 3d3336ed6607d80b72502075ebf9567cf48e1709
Bug 24002: Incorrect DATE value: '00-00-0000' in C4/Serials.pm
The changes from this patch are like:
-
year(IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate))
as year,
+ year(IF(serial.publisheddate IS
NULL,serial.publisheddate,serial.planneddate)) as year,
This is stilly, if publisheddate is null we do not want to return it.
It comes from a wrong copy/paste from the other commits:
- ORDER BY
IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC";
+ ORDER BY IF(publisheddate IS
NULL,planneddate,publisheddate) DESC";
="00-00-0000" vs <>"0000-00-00"
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://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/
