[Koha-bugs] [Bug 13993] Transfer order from one vendor to another vendor previous orderstatus is not changed.

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Apr 29 11:47:08 CEST 2015


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13993

--- Comment #9 from Jonathan Druart <jonathan.druart at biblibre.com> ---
Comment on attachment 37978
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=37978
Bug 13993 - (2) Correct poorly transferred orders

Review of attachment 37978:
 --> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=13993&attachment=37978)
-----------------------------------------------------------------

:::
installer/data/mysql/atomicupdate/Bug-13993-Correct-OrderStatus-Of-Poorly-Transferred-Orders.sql
@@ +1,2 @@
> +UPDATE aqorders SET orderstatus='cancelled'
> +                WHERE (NOT datecancellationprinted IS NULL OR

The correct syntax is
  field is not null

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list