From ef917684568fdf684cb6c703355e363c1a1a78d7 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 24 Feb 2021 15:07:38 +0000 Subject: [PATCH] Bug 7806: (follow-up) Update to use sanitize_zero_date Content-Type: text/plain; charset=utf-8 Signed-off-by: Martin Renvoize Signed-off-by: Marcel de Rooy --- installer/data/mysql/atomicupdate/bug_7806.perl | 15 ++------------- 1 file changed, 2 insertions(+), 13 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_7806.perl b/installer/data/mysql/atomicupdate/bug_7806.perl index d30776d548..c027d2f2a1 100644 --- a/installer/data/mysql/atomicupdate/bug_7806.perl +++ b/installer/data/mysql/atomicupdate/bug_7806.perl @@ -1,19 +1,8 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - eval { - local $dbh->{PrintError} = 0; - $dbh->do(q| - UPDATE aqorders - SET datecancellationprinted = NULL - WHERE datecancellationprinted = '0000-00-00' - |); - $dbh->do(q| - UPDATE old_issues - SET returndate = NULL - WHERE returndate = '0000-00-00' - |); + sanitize_zero_date('aqorders', 'datecancellationprinted'); + sanitize_zero_date('old_issues', 'returndate'); - }; NewVersion( $DBversion, 7806, "Remove remaining possible 0000-00-00 values"); } -- 2.11.0