From 2fcda64855c89846c502e0c18c377359e981509f Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 19 Feb 2021 12:14:55 +0000 Subject: [PATCH] Bug 26997: (QA follow-up) Fix Typo Feel free to squash this ;) Signed-off-by: Martin Renvoize Signed-off-by: Jonathan Druart (cherry picked from commit 63e3311b109797a60bf6dcaf34e16abb8e3f9fda) Signed-off-by: Fridolin Somers (cherry picked from commit faec602d3ecf6379519a9499dea94a642cc7940b) Signed-off-by: Andrew Fuerste-Henry --- installer/data/mysql/updatedatabase.pl | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7353fbf69c..81dfd42093 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -151,7 +151,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.00.00.006"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - sanitize_zeo_date('issues', 'issuedate'); + sanitize_zero_date('issues', 'issuedate'); print "Upgrade to $DBversion done (filled issues.issuedate with timestamp)\n"; SetVersion ($DBversion); } @@ -1950,7 +1950,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { print "Upgrade to $DBversion done (remove default '0000-00-00' in subscriptionhistory.enddate field)\n"; $dbh->do("ALTER TABLE `subscriptionhistory` CHANGE `enddate` `enddate` DATE NULL DEFAULT NULL "); - sanitize_zeo_date('subscriptionhistory', 'enddate'); + sanitize_zero_date('subscriptionhistory', 'enddate'); SetVersion ($DBversion); } @@ -2905,7 +2905,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { # match the new type of the corresponding field $dbh->do('ALTER TABLE fundmapping modify column bookfundid varchar(30)'); # System did not ensure budgetdate was valid historically - sanitize_zeo_date('fundmapping', 'budgetdate'); + sanitize_zero_date('fundmapping', 'budgetdate'); $dbh->do(q|UPDATE fundmapping SET budgetdate = entrydate WHERE budgetdate IS NULL|); # We save the map in fundmapping in case you need later processing $dbh->do(q|ALTER TABLE fundmapping add column aqbudgetid integer|); @@ -7607,7 +7607,7 @@ if ( CheckVersion($DBversion) ) { WHERE subscriptionid = ? |); - sanitize_zeo_date('subscription', 'firstacquidate'); + sanitize_zero_date('subscription', 'firstacquidate'); my $get_subscriptions_sth = $dbh->prepare(qq| SELECT subscriptionid, startdate FROM subscription @@ -10641,7 +10641,7 @@ if ( CheckVersion($DBversion) ) { $DBversion = "3.21.00.009"; if ( CheckVersion($DBversion) ) { - sanitize_zeo_date('aqorders', 'datecancellationprinted'); + sanitize_zero_date('aqorders', 'datecancellationprinted'); $dbh->do(q| UPDATE aqorders SET orderstatus='cancelled' @@ -10879,10 +10879,10 @@ if ( CheckVersion($DBversion) ) { $DBversion = "3.21.00.023"; if ( CheckVersion($DBversion) ) { - sanitize_zeo_date('borrowers', 'debarred'); - sanitize_zeo_date('borrowers', 'dateexpiry'); - sanitize_zeo_date('borrowers', 'dateofbirth'); - sanitize_zeo_date('borrowers', 'dateenrolled'); + sanitize_zero_date('borrowers', 'debarred'); + sanitize_zero_date('borrowers', 'dateexpiry'); + sanitize_zero_date('borrowers', 'dateofbirth'); + sanitize_zero_date('borrowers', 'dateenrolled'); print "Upgrade to $DBversion done (Bug 14717: Prevent 0000-00-00 dates in patron data)\n"; SetVersion($DBversion); @@ -21690,9 +21690,9 @@ $DBversion = '19.12.00.076'; if( CheckVersion( $DBversion ) ) { my @warnings; - sanitize_zeo_date('serial', 'planneddate'); - sanitize_zeo_date('serial', 'publisheddate'); - sanitize_zeo_date('serial', 'claimdate'); + sanitize_zero_date('serial', 'planneddate'); + sanitize_zero_date('serial', 'publisheddate'); + sanitize_zero_date('serial', 'claimdate'); $dbh->do(q| ALTER TABLE serial -- 2.39.5