[Koha-bugs] [Bug 15376] Edit invoices: Can not change Shipping cost.

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #9 from Marc Véron <veron at veron.ch> ---
The error no longer appears on current master.

I had a look at the database: When I filed the bug, the error occured with
records where shipmentdate = NULL.

The current behaviour is that a record with shipmentdate = NULL has now
shipmentdate = 0000-00-00 after saving with an empty field 'shipmentdate'.

More testing:
If I receive a shipment and save with an empty shipmentdate, the shipmentdate
gets a NULL in the database (and billingdate / closedate as well).

Additionally: If I edit this record and save it without changing any values
(leaving shipmentdate and billingdate empty), shipmentdate turns to 0000-00-00
but billingdate is still NULL. I would expect that both dates behave the same.

(BTW: While saving I get a log entry 'invoice.pl: Use of uninitialized value in
concatenation (.) or string at .../invoice.tt line 79)

So we have two different values for "empty date" in the table aqinvoices: NULL
and 0000-00-00.

@Jonathan: What dou you think about 0000-00-00 vs NULL? If I look at Bugzilla I
see a couple of Bugs regarding 0000-00-00.

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