From f3505ef121d5430bbace328f2d74b120da3a8a6f Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Thu, 16 Apr 2015 09:14:54 -0400 Subject: [PATCH] Bug 13993 - Correct poorly transferred orders Added Atomic Update to fix poorly transferred orders TEST PLAN --------- 1) Do an order transfer 2) Confirm the bad transfer in sql 3) Apply this patch 4) Run the updatedatabase.pl script 5) Confirm the bad transfer is fixed --- .../Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql diff --git a/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql new file mode 100644 index 0000000..00e2874 --- /dev/null +++ b/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql @@ -0,0 +1,3 @@ +UPDATE aqorders SET orderstatus='cancelled' + WHERE (NOT datecancellationprinted IS NULL OR + datecancellationprinted<>'0000-00-00'); -- 1.9.1