Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEmail RemindersEmail Reminders
Previous
 
Next
New Post
7/30/2008 3:13 PM
 
I am having the worst time getting this module to send Email reminders. The Events.EventNotification is Enabled torun every 5 minutes. Testing SMTP Server Settings works fine & requesting forgot password works fine. Somehow I feel that this is related to a Time Zone problem. The Server is physically located in (UTC -05:00) Eastern Time (US & Canada) But I have the portal timezone as (UTC -06:00) Central Time (US & Canada) & the Event Module set as (UTC -06:00) Central Time (US & Canada) also. I just downloaded & installed 04.00.02 & I still have the same problem. Can someone point me in the right direction in getting the Events Module sending Email Reminders? Thanks, Scott
 
New Post
7/30/2008 5:25 PM
 

Hi Scott,

In theory whether there is a timezone issue or not the notifications should go in the end. In theory there may be an inaccurancy relating to DST, but shouldn't really be any more than that. The module checks over the previous 30 days (which is far larger than any DST error!!), for notifications to send, so should pick up any ion that period. So things to check:-

  • Are you sure someone has registered for a notification for the event on the detail page.
  • Have you checked the event log, it records any messages being sent

DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events 
Event Notification completed. 1 Notification(s) sent!

  • You can try running the SQL below, in the Host/SQL box. Don't tick 'Run as script'. If you don't get any rows back, there are no notifications to send. If you do, get rows back and the n.NotifyByDateTime is in the past then we have a problem

SELECT     n.NotificationID, n.EventID, n.PortalAliasID, n.UserEmail,
                      n.NotificationSent, n.NotifyByDateTime, n.EventTimeBegin, n.NotifyLanguage,
                      e.TimezoneOffset, n.ModuleID
FROM         {databaseOwner}[{objectQualifier}EventsNotification] as n INNER JOIN
                      {databaseOwner}[{objectQualifier}Events] as e ON n.EventID = e.EventID AND n.NotifyByDateTime <= DATEADD(minute, e.TimezoneOffset,
                     getutcdate())
WHERE     (n.NotificationSent = 0)
ORDER BY n.NotifyByDateTime

Hope this helps
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
7/31/2008 11:08 AM
 

Hey Roger,

Thanks for the help...    I am sure that someone has registered for a notification for the event.  This is what is in the event log:

DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events Event Notification completed.

The same message is repeated over & over. 

When I run the SQL command, I get the following:

The query did not return any data

For some reason Event Notifications are not being created. 

Scott

 
New Post
7/31/2008 11:38 AM
 

Hi Scott,

You can try this as an even simpler query, but I suspect you will get no data. By the look of it no-one has requested a reminder, have you tried yourself, by clicking on the 'Notify Me for this Event @' link?

SELECT     *
FROM         {databaseOwner}[{objectQualifier}EventsNotification]

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
7/31/2008 11:39 AM
 

As a follow on. If a notification request has been successfuly reocrded (as opposed to sent), then the Notify me link will disappear from the event detail  screen.


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEmail RemindersEmail Reminders


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out