Bug 7806: Fix remaining occurrences of 0000-00-00
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 18 Dec 2020 14:16:11 +0000 (15:16 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 4 Mar 2021 09:24:48 +0000 (10:24 +0100)
commitd8e3ad15b72b1847eff58b381923e438b4cc0771
tree7c2a7d4c2f6656ddb0d16f1dca7d650112145f27
parent3652f652d260bafc8669205d59866db792e56f47
Bug 7806: Fix remaining occurrences of 0000-00-00

We should remove all SQL queries that contain 0000-00-00 and finally
assume we do not longer have such value in our DB (for date type)

We already dealt with such values in previous update DB entries.
The 2 added by this one haven't been replaced already.

The code will now assume that either a valid date exist, or NULL/undef.

Test plan:
QA review is needed and test of the different places where code is
modified.

Not sure about the change from reports/issues_avg_stats.pl

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 099e2fe2b700c388e4939b2b2505773056d3383e)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
13 files changed:
C4/Letters.pm
C4/Serials.pm
C4/Suggestions.pm
cataloguing/value_builder/dateaccessioned.pl
circ/waitingreserves.pl
installer/data/mysql/atomicupdate/bug_7806.perl [new file with mode: 0644]
members/memberentry.pl
misc/cronjobs/serialsUpdate.pl
reports/issues_avg_stats.pl
reserve/request.pl
serials/subscription-add.pl
suggestion/suggestion.pl
t/db_dependent/Circulation/dateexpiry.t