Bugzilla – Attachment 104833 Details for
Bug 25478
Inconsistent naming of account_credit_type for lost and returned items [19.11 Version]
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25478: (25389 backport) Correct stray cases of LOST_RETURNED
Bug-25478-25389-backport-Correct-stray-cases-of-LO.patch (text/plain), 1.42 KB, created by
Martin Renvoize (ashimema)
on 2020-05-13 10:02:34 UTC
(
hide
)
Description:
Bug 25478: (25389 backport) Correct stray cases of LOST_RETURNED
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2020-05-13 10:02:34 UTC
Size:
1.42 KB
patch
obsolete
>From 469c4b32c78338e0c6f06d9c66ccef74fccd9453 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >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 <kyle@bywatersolutions.com> >Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 25478
:
104832
| 104833 |
104834