From d7c8fac5ecb747c0da75f3c8471c2f368bc75f54 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 31 Jul 2014 11:28:44 -0400 Subject: [PATCH] Bug 12507 - News does not always display in staff or OPAC News will not display on the last day of each month due to the way the date is calculated in the SQL code for grabbing news. Test Plan: 1) Create a news item that should display 2) Change your server's date to the last day of the month 3) Note you can no longer see that news item 4) Apply this patch 5) Note you can now see your news item again --- C4/NewsChannels.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 47772ef..8694c1b 100644 --- a/C4/NewsChannels.pm +++ b/C4/NewsChannels.pm @@ -197,7 +197,7 @@ sub GetNewsToDisplay { OR expirationdate IS NULL OR expirationdate = '00-00-0000' ) - AND `timestamp` < CURRENT_DATE()+1 + AND DATE(timestamp) < DATE_ADD(CURDATE(), INTERVAL 1 DAY) AND (lang = '' OR lang = ?) AND (branchcode IS NULL OR branchcode = ?) ORDER BY number -- 1.7.2.5