[Koha-bugs] [Bug 17865] If a subscription has no history end date, it shows as expired today in OPAC

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Feb 13 03:34:59 CET 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17865

--- Comment #14 from M. Tompsett <mtompset at hotmail.com> ---
Comment on attachment 59199
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=59199
Bug 17865 'If a subscription has no history end date, it shows as expired today
in OPAC'

Review of attachment 59199:
 --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=17865&attachment=59199)
-----------------------------------------------------------------

My concern with the conditions modified is the poor date handling of MySQL.
Sometimes unset dates were 0000-00-00, sometimes they were null. When and how
aren't the issue, but for those still using MySQL 5.5 in less than strict mode,
defined might not be sufficient. In MySQL 5.7 or strict mode, defined is
perfectly okay.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list