[Koha-bugs] [Bug 24002] Test suite is failing on MySQL 8
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Nov 8 15:46:09 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24002
Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #95220|0 |1
is obsolete| |
--- Comment #13 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 95227
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=95227&action=edit
Bug 24002: Incorrect DATE value: '' in C4/Acquisition.pm
DBD::mysql::st execute failed: Incorrect DATE value: '' [for Statement "
SELECT aqbasket.basketno,
aqorders.ordernumber,
DATE(aqbasket.closedate) AS orderdate,
aqbasket.basketname AS basketname,
aqbasket.basketgroupid AS basketgroupid,
aqbasketgroups.name AS basketgroupname,
aqorders.rrp AS unitpricesupplier,
aqorders.ecost AS unitpricelib,
aqorders.claims_count AS claims_count,
aqorders.claimed_date AS claimed_date,
aqbudgets.budget_name AS budget,
borrowers.branchcode AS branch,
aqbooksellers.name AS supplier,
aqbooksellers.id AS supplierid,
biblio.author, biblio.title,
biblioitems.publishercode AS publisher,
biblioitems.publicationyear,
ADDDATE(aqbasket.closedate, INTERVAL aqbooksellers.deliverytime DAY) AS
estimateddeliverydate,
aqorders.quantity - COALESCE(aqorders.quantityreceived,0)
AS quantity,
(aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) *
aqorders.rrp AS subtotal,
DATEDIFF(CAST(now() AS date),closedate) AS latesince
FROM
aqorders LEFT JOIN biblio ON biblio.biblionumber =
aqorders.biblionumber
LEFT JOIN biblioitems ON biblioitems.biblionumber =
biblio.biblionumber
LEFT JOIN aqbudgets ON aqorders.budget_id =
aqbudgets.budget_id,
aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby =
borrowers.borrowernumber
LEFT JOIN aqbooksellers ON aqbasket.booksellerid =
aqbooksellers.id
LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid =
aqbasketgroups.id
WHERE aqorders.basketno = aqbasket.basketno
AND ( datereceived = ''
OR datereceived IS NULL
OR aqorders.quantityreceived < aqorders.quantity
)
AND aqbasket.closedate IS NOT NULL
AND aqorders.datecancellationprinted IS NULL
AND (closedate <= DATE_SUB(CAST(now() AS date),INTERVAL ? DAY)) AND
aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 AND orderstatus
<> 'cancelled'
ORDER BY latesince, basketno, borrowers.branchcode, supplier" with ParamValues:
0=0] at /kohadevbox/koha/C4/Acquisition.pm line 2248.
Signed-off-by: Martin Renvoize <martin.renvoize at ptfs-europe.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list