Bugzilla – Attachment 95216 Details for
Bug 24002
Test suite is failing on MySQL 8
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24002: Incorrect DATE value: '' in C4/Bookseller.pm
Bug-24002-Incorrect-DATE-value--in-C4Booksellerpm.patch (text/plain), 1.58 KB, created by
Jonathan Druart
on 2019-11-08 13:53:19 UTC
(
hide
)
Description:
Bug 24002: Incorrect DATE value: '' in C4/Bookseller.pm
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2019-11-08 13:53:19 UTC
Size:
1.58 KB
patch
obsolete
>From dd2008636149abbc1b31eb95c703da023264292c Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 8 Nov 2019 14:00:43 +0100 >Subject: [PATCH] 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. >--- > C4/Bookseller.pm | 3 +-- > 1 file changed, 1 insertion(+), 2 deletions(-) > >diff --git a/C4/Bookseller.pm b/C4/Bookseller.pm >index dff325ef1f..e5f37f1889 100644 >--- a/C4/Bookseller.pm >+++ b/C4/Bookseller.pm >@@ -66,8 +66,7 @@ sub GetBooksellersWithLateOrders { > FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno > LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id > WHERE >- ( datereceived = '' >- OR datereceived IS NULL >+ ( datereceived IS NULL > OR aqorders.quantityreceived < aqorders.quantity > ) > AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 24002
:
95215
|
95216
|
95217
|
95218
|
95219
|
95220
|
95221
|
95222
|
95223
|
95224
|
95225
|
95226
|
95227
|
99118