[Bug 3289] New: News items do not appear on current date, must be backdated.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 Summary: News items do not appear on current date, must be backdated. Product: Koha Version: rel_3_0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Tools AssignedTo: galen.charlton@liblime.com ReportedBy: wizzyrea@gmail.com Estimated Hours: 0.0 Change sponsored?: --- News items in the staff interface currently must be dated the day before the present day to appear on the present day. example: The current date is June 3. I am posting a news item to appear June 3. I have to pick June 2 on the calendar to make it show up. /example -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 --- Comment #1 from Liz Rea <wizzyrea@gmail.com> 2009-06-04 16:36:48 --- Patch sent. -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 Galen Charlton <galen.charlton@liblime.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |galen.charlton@liblime.com AssignedTo|galen.charlton@liblime.com |wizzyrea@gmail.com -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 Galen Charlton <galen.charlton@liblime.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #2 from Galen Charlton <galen.charlton@liblime.com> 2009-06-05 21:59:02 --- Patch pushed. Please test and close. -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED --- Comment #3 from Liz Rea <wizzyrea@gmail.com> 2009-06-08 13:44:04 --- Fixed in my dev install from the submitted patch. -- 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.
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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3289 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |paul.poulain@biblibre.com --- Comment #5 from Liz Rea <wizzyrea@gmail.com> 2010-05-04 16:00:30 --- *** Bug 3685 has been marked as a duplicate of this bug. *** -- 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.
participants (2)
-
bugzilla-daemon@kohaorg.ec2.liblime.com -
bugzilla-daemon@liblime.com