[Koha-bugs] [Bug 3289] News items do not appear on current date, must be backdated.

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289





--- Comment #4 from Liz Rea <wizzyrea at 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.