Bug 24002: Incorrect DATE value: '' in C4/Bookseller.pm
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 8 Nov 2019 13:00:43 +0000 (14:00 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 12 Nov 2019 13:50:06 +0000 (13:50 +0000)
commit508a5addf15170d32dea0f21e3acf569596db228
tree015b3848e501a041f981a692bf0c5877c79143c4
parent7e602c275b3687460c55f3f103781f2a44bdbee8
Bug 24002: Incorrect DATE value: '' in C4/Bookseller.pm

t/db_dependent/Bookseller.t .. 3/86 DBD::mysql::st execute failed: Incorrect DATE value: '' [for Statement "
        SELECT DISTINCT aqbasket.booksellerid, aqbooksellers.name
        FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno
        LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id
        WHERE
            ( datereceived = ''
            OR datereceived IS NULL
            OR aqorders.quantityreceived < aqorders.quantity
            )
            AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0
            AND aqbasket.closedate IS NOT NULL
    "] at /kohadevbox/koha/C4/Bookseller.pm line 100.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/Bookseller.pm