From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Mon, 17 Jun 2019 14:01:11 +0000 (+0100)
Subject: Bug 22563: (QA follow-up) Correction to DB update
X-Git-Tag: v19.11.00~1074
X-Git-Url: http://git.equinoxoli.org/?p=koha.git;a=commitdiff_plain;h=dd63cb6b8ee5b3324c8902b7f189b22a03b0a335

Bug 22563: (QA follow-up) Correction to DB update

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---

diff --git a/installer/data/mysql/atomicupdate/bug_22563.perl b/installer/data/mysql/atomicupdate/bug_22563.perl
index 1c27e04..e8176f7 100644
--- a/installer/data/mysql/atomicupdate/bug_22563.perl
+++ b/installer/data/mysql/atomicupdate/bug_22563.perl
@@ -51,7 +51,7 @@ if ( CheckVersion($DBversion) ) {
         UPDATE
           accountlines
         SET
-          accounttype = 'LOST',
+          accounttype = 'LOST'
         WHERE
           accounttype = 'L';
     });
@@ -60,7 +60,7 @@ if ( CheckVersion($DBversion) ) {
         UPDATE
           accountlines
         SET
-          accounttype = 'LOST_RETURNED',
+          accounttype = 'LOST_RETURNED'
         WHERE
           accounttype = 'CR';
     });