From 4c360a144ddcae89ca0fdb555b6725a6379b6463 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
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.1.4