From 36303e71f60f6ba21b7349b37682db202e93e329 Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Tue, 17 May 2016 14:44:45 +0300 Subject: [PATCH] Bug 16200: Convert all existing expired holds accounttype to HE MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Before Bug 16200 expired holds have used accounttype F which is also used by other type of fines. This patch updates all existing expired holds to new accounttype HE (Hold Expired). To test: -1. Make sure you translated the string in previous patch of this buug 1. Find a Patron with "Hold waiting too long" fines and go to his Fines tab 2. Change Koha's language to some other than English 3. Observe that "Hold waiting too long" is still in English 4. Apply patch and run database update 5. Go back to Patron's Fines tab 6. Observe that "Hold waiting too long" is now translated Signed-off-by: Olli-Antti Kivilahti Signed-off-by: Katrin Fischer Signed-off-by: Brendan Gallagher (cherry picked from commit 09de19c427c1e99d7e921210ed39cb6a19737317) Signed-off-by: Frédéric Demians (cherry picked from commit d80368370258432aab4d4171b886af26442d08c1) Signed-off-by: Julian Maurice --- .../Bug_16200_Convert_expired_holds_to_accounttype_HE.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql diff --git a/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql b/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql new file mode 100644 index 0000000000..b1c957db31 --- /dev/null +++ b/installer/data/mysql/atomicupdate/Bug_16200_Convert_expired_holds_to_accounttype_HE.sql @@ -0,0 +1 @@ +UPDATE accountlines SET accounttype='HE', description=itemnumber WHERE (description REGEXP '^Hold waiting too long [0-9]+') AND accounttype='F'; -- 2.39.5