Home
The Toolkit for Online Communities
15888 Community Members, 0 members online, 2020 visitors today
Log In Register

Forum OpenACS Development: Re: News package notification bug

OpenACS Home : Forums : OpenACS Development : Re: News package notification bug : One Message

+
Posted by Dave Bauer on
Aha.

Ok so if someone requests notification for News at 10am on May 2 2012 then a new news item is created at 12pm on May 2 2012 the notification time is set to 12AM (00:00) on May 2, 2012 or time traveling back 12 hours to before the users subscribed.

OK, so the notification date for immediate publishing needs to be the creation timestamp correct?

This is the time that news should send to notifications pacakge.

+
Posted by Ryan Gallimore on
Correct. My snippet above should fix it. It's a corner case since it only applies when you subscribe and an item is created on the same day. If the item is created in the future, you don't have to worry.
+
Posted by Don Baccus on
Can't use the creation_date as the notification shouldn't go out until the news item is actually published.
+
Posted by Don Baccus on
So publish_date should be a timestamp, how hard is it to fix that?

I wouldn't worry about Oracle ...

+
Posted by Ryan Gallimore on
It's the creation date of the notification request acs_object, not the news item creation date.