Attachment 37978 Details for Bug 13993 – Bug 13993 - (2) Correct poorly transferred orders

[patch] Bug 13993 - (2) Correct poorly transferred orders

Bug-13993---2-Correct-poorly-transferred-orders.patch (text/plain), 1.31 KB, created by Mark Tompsett on 2015-04-16 16:51:05 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2015-04-16 16:51:05 UTC

Size: 1.31 KB

patch

obsolete

>From 9289753a7b36330b172da8ffc22f3ce8e1d73c45 Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Thu, 16 Apr 2015 09:14:54 -0400
>Subject: [PATCH] Bug 13993 - (2) Correct poorly transferred orders
>
>Added Atomic Update to fix poorly transferred orders
>
>TEST PLAN
>---------
>8) Apply patch (2)
>9) Run the database updates
>   $ ./installer/data/mysql/updatedatabase.pl
>   -- This should run without error
>10) prove -v t/db_dependent/Acquisition/TransferOrder.t
>    -- This should succeed now, because the update fixed it.
>---
> .../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

Actions: View | Diff | Splinter Review

Attachments on bug 13993: 37797 | 37798 | 37957 | 37958 | 37959 | 37977 | 37978 | 37979 | 38668 | 38669 | 38670 | 38674 | 38675 | 38676 | 39017 | 39018 | 39019 | 39535 | 39536 | 39537 | 39538