@@ -, +, @@ --------- $ ./installer/data/mysql/updatedatabase.pl -- This should run without error -- This should fail, because the transfer function is still not 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 --- a/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql +++ a/installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql @@ -0,0 +1,3 @@ +UPDATE aqorders SET orderstatus='cancelled' + WHERE (datecancellationprinted IS NOT NULL OR + datecancellationprinted<>'0000-00-00'); --