Attachment 98811 Details for Bug 24532 – Bug 24532: Fix original DB update for bug 23049

[patch] Bug 24532: Fix original DB update for bug 23049

Bug-24532-Fix-original-DB-update-for-bug-23049.patch (text/plain), 1.28 KB, created by Kyle M Hall (khall) on 2020-02-13 11:18:51 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-02-13 11:18:51 UTC

Size: 1.28 KB

patch

obsolete

>From bf4cb94ff1ab2567649a686577c550fd3f6e8da2 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 30 Jan 2020 13:19:37 +0000
>Subject: [PATCH] Bug 24532: Fix original DB update for bug 23049
>
>Pathalogical cases of Payments and Writeoffs being converted to debits
>are identified during the DB update for bug 23049, but we are not
>correctly limiting to those types accountlines when subsequently
>populating the debit_type field.
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> installer/data/mysql/updatedatabase.pl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 84b30326c5..a7af84bbbc 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -19919,7 +19919,7 @@ if ( CheckVersion($DBversion) ) {
>     # Populating debit_type_code
>     $dbh->do(
>         qq{
>-        UPDATE accountlines SET debit_type_code = accounttype, accounttype = NULL WHERE accounttype IN (SELECT code from account_debit_types)
>+        UPDATE accountlines SET debit_type_code = accounttype, accounttype = NULL WHERE accounttype IN (SELECT code from account_debit_types) AND amount >= 0
>         }
>     );
> 
>-- 
>2.21.1 (Apple Git-122.3)

Actions: View | Diff | Splinter Review

Attachments on bug 24532: 98161 | 98162 | 98811 | 98812