From 03395fd33a2305d94cc4cc936e381229b030366c Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 31 Jul 2014 11:28:44 -0400 Subject: [PATCH] [SIGNED-OFF] Bug 12507 - News does not always display in staff or OPAC Content-Type: text/plain; charset="utf-8" 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 --- 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.7.9.5