From 9e4e52915685589a1b3b107a8033c1ec6066693a 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 bug 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 --- .../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