http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 --- Comment #4 from Liz Rea <wizzyrea@gmail.com> 2010-05-04 15:59:18 --- --- C4/NewsChannels.pm | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 136cc5c..8cf1ff6 100644 --- a/C4/NewsChannels.pm +++ b/C4/NewsChannels.pm @@ -328,11 +328,11 @@ sub GetNewsToDisplay { SELECT *,timestamp AS newdate FROM opac_news WHERE ( - expirationdate > CURRENT_DATE() + expirationdate >= CURRENT_DATE() OR expirationdate IS NULL OR expirationdate = '00-00-0000' ) - AND `timestamp` < CURRENT_DATE() + AND `timestamp` <= CURRENT_DATE() AND lang = ? ORDER BY number "; # expirationdate field is NOT in ISO format? -- 1.5.6.5 -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.