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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 1 Mar 2021 10:16:42 +0000 (11:16 +0100)
commit099e2fe2b700c388e4939b2b2505773056d3383e
tree97204cd75b7d227479d8f52b47f6d75ea0ea4b63
parent3e3803ee20dc3dfc3d21e5cafa7a76159c8d4aba
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>
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