[Koha-bugs] [Bug 23397] Order lines can be duplicated in acqui scripts spent.pl and ordered.pl

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Aug 23 09:01:31 CEST 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23397

--- Comment #4 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
BTW While testing:
DBD::mysql::st execute failed: Incorrect double value: '' for column
`koha_master`.`aqorders`.`discount` at row 1 [for Statement "UPDATE aqorders
SET basketno=?, biblionumber=?, quantity=?, budget_id=?, currency=?,
listprice=?, discount=?, rrp=?, replacementprice=?, ecost=?, unitprice=?,
order_internalnote=?, order_vendornote=?, sort1=?, sort2=?, subscriptionid=?,
uncertainprice=?, tax_rate_on_ordering=?, rrp_tax_excluded=?,
rrp_tax_included=?, ecost_tax_excluded=?, ecost_tax_included=?,
tax_value_on_ordering=?, timestamp=NOW()  WHERE  ordernumber=?" with
ParamValues: 0="67", 1="2578", 2="2", 3="123", 4="USD", 5="10", 6="",
7="10.00", 8="10.00", 9="10.00", 10="0.00", 11="", 12="", 13="", 14="",
15=undef, 16="0", 17="0", 18="10.00", 19="10", 20="10", 21="10", 22="0",
23="15"] at /usr/share/koha/C4/Acquisition.pm line 1358.

With strict SQL saving the order failed invisibly..

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


More information about the Koha-bugs mailing list