Bug 7806: [20.05] 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)
committerAndrew Fuerste-Henry <andrew@bywatersolutions.com>
Mon, 8 Mar 2021 14:26:22 +0000 (14:26 +0000)
commit56a9dcd48b6e272273eb2df629275ada56c85b00
tree3727a95344648ed5288b6055d399afb3c7994199
parent42b1b1cd2beb4cf6ecc47831f68e8b6f1d9d3b78
Bug 7806: [20.05] 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: Andrew Fuerste-Henry <andrew@bywatersolutions.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