Attachment 104679 Details for Bug 25389 – Bug 25389: Correct stray cases of LOST_RETURNED

[patch] Bug 25389: Correct stray cases of LOST_RETURNED

Bug-25389-Correct-stray-cases-of-LOSTRETURNED.patch (text/plain), 1.20 KB, created by Martin Renvoize (ashimema) on 2020-05-11 10:40:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2020-05-11 10:40:44 UTC

Size: 1.20 KB

patch

obsolete

>From 3135876c0875e781bc681b82b836970c085c2a19 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 25389: 104678 | 104679 | 104680 | 104681 | 104755 | 104756 | 104757 | 104758 | 104775 | 104776 | 104777 | 104778