From 5db684e772ce05f1daaaf56b46b095d269379d7b 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 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 --- .../atomicupdate/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 0000000..b1c957d --- /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'; -- 1.9.1