http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15376
--- Comment #9 from Marc Véron <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
