Bug 24002: Incorrect DATE value: '0000-00-00' in C4/Acquisition.pm
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 8 Nov 2019 13:46:38 +0000 (14:46 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 12 Nov 2019 13:50:20 +0000 (13:50 +0000)
commitb16c7c0615f41dde587370ba32ca5711ae8127dd
treefc530aa0884a5767c98d8294d57095c692da7a48
parent3d3336ed6607d80b72502075ebf9567cf48e1709
Bug 24002: Incorrect DATE value: '0000-00-00' in C4/Acquisition.pm

t/db_dependent/Acquisition/close_reopen_basket.t .. DBD::mysql::st execute failed: Incorrect DATE value: '0000-00-00' [for Statement "
        SELECT COUNT( DISTINCT( biblionumber ) )
        FROM   aqorders
        WHERE  basketno = ?
            AND (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00')
        " with ParamValues: 0='2'] at /kohadevbox/koha/C4/Acquisition.pm line 3012.
DBD::mysql::st execute failed: Incorrect DATE value: '0000-00-00' [for Statement "
        SELECT COUNT( DISTINCT( biblionumber ) )
        FROM   aqorders
        WHERE  basketno = ?
            AND (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00')
        " with ParamValues: 0='2'] at /kohadevbox/koha/C4/Acquisition.pm line 3012.

And anticipating other failures

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