From 469c4b32c78338e0c6f06d9c66ccef74fccd9453 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 13 May 2020 10:54:12 +0100 Subject: [PATCH] Bug 25478: (25389 backport) 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 (cherry picked from commit 483e40d2236bbb584022846bd1c85d62f149f096) Signed-off-by: Kyle M Hall Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize --- 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 46dbf63d06..8b950c77a9 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -19998,6 +19998,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' + }); + # Adding credit_type_code to accountlines unless ( column_exists('accountlines', 'credit_type_code') ) { $dbh->do( -- 2.20.1