Bugzilla – Attachment 95222 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: '00-00-0000' in NewsChannels.pm
Bug-24002-Incorrect-DATE-value-00-00-0000-in-NewsC.patch (text/plain), 1.65 KB, created by
Martin Renvoize (ashimema)
on 2019-11-08 14:45:51 UTC
(
hide
)
Description:
Bug 24002: Incorrect DATE value: '00-00-0000' in NewsChannels.pm
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-11-08 14:45:51 UTC
Size:
1.65 KB
patch
obsolete
>From 0bc7b4146886b4534972685da476bb806be2fe6b Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 8 Nov 2019 13:58:32 +0100 >Subject: [PATCH] Bug 24002: Incorrect DATE value: '00-00-0000' in > NewsChannels.pm > >% prove xt/author/valid-templates.t > >DBD::mysql::st execute failed: Incorrect DATE value: '00-00-0000' [for Statement " > SELECT opac_news.*,timestamp AS newdate, > borrowers.title AS author_title, > borrowers.firstname AS author_firstname, > borrowers.surname AS author_surname > FROM opac_news > LEFT JOIN borrowers on borrowers.borrowernumber = opac_news.borrowernumber > WHERE ( > expirationdate >= CURRENT_DATE() > OR expirationdate IS NULL > OR expirationdate = '00-00-0000' > ) > AND DATE(timestamp) < DATE_ADD(CURDATE(), INTERVAL 1 DAY) > AND (opac_news.lang = '' OR opac_news.lang = ?) > AND (opac_news.branchcode IS NULL OR opac_news.branchcode = ?) > ORDER BY number > " with ParamValues: 0='OpacNavRight_', 1=''] at /kohadevbox/koha/C4/NewsChannels.pm line 216. > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > C4/NewsChannels.pm | 1 - > 1 file changed, 1 deletion(-) > >diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm >index a01d2798ec..7ab168e171 100644 >--- a/C4/NewsChannels.pm >+++ b/C4/NewsChannels.pm >@@ -202,7 +202,6 @@ sub GetNewsToDisplay { > WHERE ( > expirationdate >= CURRENT_DATE() > OR expirationdate IS NULL >- OR expirationdate = '00-00-0000' > ) > AND DATE(timestamp) < DATE_ADD(CURDATE(), INTERVAL 1 DAY) > AND (opac_news.lang = '' OR opac_news.lang = ?) >-- >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 24002
:
95215
|
95216
|
95217
|
95218
|
95219
|
95220
|
95221
| 95222 |
95223
|
95224
|
95225
|
95226
|
95227
|
99118