Bugzilla – Attachment 117179 Details for
Bug 26997
Database Mysql Version 8.0.22 failed to Update During Upgrade
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26997: Remove 0000-00-00 from aqorders.datecancellationprinted
Bug-26997-Remove-0000-00-00-from-aqordersdatecance.patch (text/plain), 1.66 KB, created by
Martin Renvoize
on 2021-02-23 09:07:28 UTC
(
hide
)
Description:
Bug 26997: Remove 0000-00-00 from aqorders.datecancellationprinted
Filename:
MIME Type:
Creator:
Martin Renvoize
Created:
2021-02-23 09:07:28 UTC
Size:
1.66 KB
patch
obsolete
>From fe438feb69676a2404d2f2f13f447abb3b2d6ddd Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 13 Nov 2020 13:59:46 +0100 >Subject: [PATCH] Bug 26997: Remove 0000-00-00 from > aqorders.datecancellationprinted > >This patch remove the 0000-00-00 from the WHERE condition from >ordered.pl and spent.pl to prevent an error under MySQL 8 > >It also fixes the wrong values in DB (if possible, ie. under other DBMS >that MySQL 8) > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > acqui/ordered.pl | 3 +-- > acqui/spent.pl | 3 +-- > 2 files changed, 2 insertions(+), 4 deletions(-) > >diff --git a/acqui/ordered.pl b/acqui/ordered.pl >index 20be8a0462..7f17310532 100755 >--- a/acqui/ordered.pl >+++ b/acqui/ordered.pl >@@ -71,8 +71,7 @@ LEFT JOIN aqbooksellers ON > aqbasket.booksellerid = aqbooksellers.id > WHERE > budget_id=? AND >- (datecancellationprinted IS NULL OR >- datecancellationprinted='0000-00-00') AND >+ datecancellationprinted IS NULL AND > (quantity > quantityreceived OR quantityreceived IS NULL) > GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, > tleft, >diff --git a/acqui/spent.pl b/acqui/spent.pl >index 938ca90ccd..f90671b3eb 100755 >--- a/acqui/spent.pl >+++ b/acqui/spent.pl >@@ -80,8 +80,7 @@ LEFT JOIN aqbooksellers ON > WHERE > aqorders.basketno=aqbasket.basketno AND > budget_id=? AND >- (datecancellationprinted IS NULL OR >- datecancellationprinted='0000-00-00') AND >+ datecancellationprinted IS NULL AND > datereceived IS NOT NULL > GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, > tleft, >-- >2.20.1
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 26997
:
113495
|
113600
|
114526
|
114527
|
117038
|
117178
| 117179 |
117180
|
117181
|
117428