From 3135876c0875e781bc681b82b836970c085c2a19 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Mon, 11 May 2020 11:30:35 +0100 Subject: [PATCH] Bug 25389: Correct stray cases of LOST_RETURNED The original DB update for bug 22563 incorrectly mapped CR to LOST_RETURNED as aposed to LOST_RETURN. This patch catches such cases and updates them in the update for bug 23805 --- installer/data/mysql/updatedatabase.pl | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c13fe03ec0..4b38a60862 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -20011,6 +20011,14 @@ if ( CheckVersion($DBversion) ) { ); } + # Catch LOST_RETURNED cases from original bug 22563 update + $dbh->do( + qq{ + UPDATE accountlines + SET accounttype = 'LOST_RETURN' + WHERE accounttype = 'LOST_RETURNED' + }); + # Linking credit_type_code in accountlines to code in account_credit_types unless ( foreign_key_exists( 'accountlines', 'accountlines_ibfk_credit_type' ) ) { $dbh->do( -- 2.20.1