Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
Verndale
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Events Module [...  Email Reminders
Previous Previous
 
Next Next
New Post 7/30/2008 1:13 PM
Resolved
User is offline Scott Pack
8 posts
10th Ranked


Email Reminders 
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 3:25 PM
User is offline Roger Selwyn
1042 posts
www.thedivingclub.co.uk
6th Ranked




Re: Email Reminders 

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


Events 4.0.2 - It's released !! - See the annoucement.
Requirements/Bugs - Submit them here - Gemini - Raise against project 'DNNP', and put 'Events' in the title.
 
New Post 7/31/2008 9:08 AM
User is offline Scott Pack
8 posts
10th Ranked


Re: Email Reminders 

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 9:38 AM
User is offline Roger Selwyn
1042 posts
www.thedivingclub.co.uk
6th Ranked




Re: Email Reminders 

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


Events 4.0.2 - It's released !! - See the annoucement.
Requirements/Bugs - Submit them here - Gemini - Raise against project 'DNNP', and put 'Events' in the title.
 
New Post 7/31/2008 9:39 AM
User is offline Roger Selwyn
1042 posts
www.thedivingclub.co.uk
6th Ranked




Re: Email Reminders 

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.


Events 4.0.2 - It's released !! - See the annoucement.
Requirements/Bugs - Submit them here - Gemini - Raise against project 'DNNP', and put 'Events' in the title.
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Events Module [...  Email Reminders
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Live Visitor Tracking & Live Chat For DotNetNuke
Track your visitors in real time and add live chat for sales & support. Free Trial.
www.whoson.com
SINA101
WANT A SPECial sIte iN TAIWAN?
sina101.com
Web Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP