From 1c4ce6d4f81d2fde53eeff3f0a513fe20ab085d8 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 31 Jul 2014 11:28:44 -0400 Subject: [PATCH] [PASSED QA] 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 --- C4/NewsChannels.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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.9.1