Attachment 104777 Details for Bug 25389 – Bug 25389: Catch LOST_RETURNED in DB update 19.12.00.021

[patch] Bug 25389: Catch LOST_RETURNED in DB update 19.12.00.021

Bug-25389-Catch-LOSTRETURNED-in-DB-update-19120002.patch (text/plain), 1.47 KB, created by Jonathan Druart on 2020-05-12 13:25:17 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-05-12 13:25:17 UTC

Size: 1.47 KB

patch

obsolete

>From ad5998185af6d154a52f60c32b6b5284aec63881 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Mon, 11 May 2020 11:33:32 +0100
>Subject: [PATCH] Bug 25389: Catch LOST_RETURNED in DB update 19.12.00.021
>
>An errant update from bug 22563 could lead to cases of LOST_RETURNED as
>aposed to LOST_RETURN as an account_credit_type. This patch adds code to
>deal with those cases to the update for bug 24592
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> installer/data/mysql/updatedatabase.pl | 7 +++++++
> 1 file changed, 7 insertions(+)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index e12471c6a7..5bbef648d2 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -20755,6 +20755,8 @@ if( CheckVersion( $DBversion ) ) {
>           credit_type_code = 'LOST_FOUND'
>         WHERE
>           credit_type_code = 'LOST_RETURN'
>+        OR
>+          credit_type_code = 'LOST_RETURNED'
>     });
> 
>     # Migrate LOST + RETURNED to LOST + FOUND
>@@ -20770,6 +20772,11 @@ if( CheckVersion( $DBversion ) ) {
>     });
> 
>     # Drop LOST_RETURNED credit type
>+    $dbh->do(qq{
>+        DELETE FROM account_credit_types WHERE code = 'LOST_RETURNED'
>+    });
>+
>+    # Drop LOST_RETURN credit type
>     $dbh->do(qq{
>         DELETE FROM account_credit_types WHERE code = 'LOST_RETURN'
>     });
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

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