From 9f2f35bcc9b243b30d72a86067b7f36355276895 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 13 Jun 2016 11:17:42 +0000 Subject: [PATCH] Bug 14048 [QA Followup] - Delete only the removed system preference --- .../data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql b/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql index 2f372fb..a046910 100644 --- a/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql +++ b/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql @@ -14,7 +14,7 @@ VALUES( 'RefundLostOnReturnControl', INSERT INTO refund_lost_item_fee_rules (branchcode,refund) SELECT '*', COALESCE(value,'1') FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn'; -DELETE IGNORE FROM systempreferences; +DELETE FROM systempreferences WHERE variable = 'RefundLostItemFeeOnReturn'; -- $DBversion = "16.06.00.XXX"; -- if ( CheckVersion($DBversion) ) { -- 2.9.0