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

t/db_dependent/Biblio.t .. 2/12 DBD::mysql::st execute failed: Incorrect DATE value: '00-00-0000' [for Statement "
  SELECT    serial.serialid,
            serial.serialseq,
            serial.planneddate,
            serial.publisheddate,
            serial.publisheddatetext,
            serial.status,
            serial.notes as notes,
            year(IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate)) as year,
            biblio.title as bibliotitle,
            subscription.branchcode AS branchcode,
            subscription.subscriptionid AS subscriptionid
  FROM      serial
  LEFT JOIN subscription ON
          (serial.subscriptionid=subscription.subscriptionid)
  LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id
  LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber
  WHERE     subscription.biblionumber = ?
  ORDER BY year DESC,
          IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate) DESC,
          serial.subscriptionid
          " with ParamValues: 0='446'] at /kohadevbox/koha/C4/Serials.pm line 482.

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