@@ -, +, @@ preference --- .../data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql +++ a/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) ) { --