Bug 24002: Incorrect DATE value: '0000-00-00' in C4/Serials.pm
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 8 Nov 2019 13:03:37 +0000 (14:03 +0100)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 12 Nov 2019 13:50:13 +0000 (13:50 +0000)
commit5e5c47ea300b7eb34cbcd3e71ff4a1ac9a3eaa38
treede2a9f24eeb3006c949f2dd0e07c5e8ab72ffa98
parent508a5addf15170d32dea0f21e3acf569596db228
Bug 24002: Incorrect DATE value: '0000-00-00' in C4/Serials.pm

DBD::mysql::st execute failed: Incorrect DATE value: '0000-00-00' [for Statement "SELECT   serialid,serialseq, status, planneddate, publisheddate,
        publisheddatetext, notes, routingnotes
       FROM     serial
       WHERE    subscriptionid = ?
       AND      status IN ( 2,4,41,42,43,44,5 )
       ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC
      " with ParamValues: 0=8] at /kohadevbox/koha/C4/Serials.pm line 688.

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