From d7c2faa795af0604bf0830534f1a37a2676e1d7b 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 Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- C4/NewsChannels.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 47772efc89..8694c1b964 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 -- 2.11.0