The issue is that when users choose to subsribe to a forum, the emails are not arriving almost 80% of the time. I have checked that is this is not a junk mail issue. It is also not a mail server setup issue since I get emails sometimes...Can you please give me some clues where to look to even begin troubleshooting.
BTW, I have heard there is a mail-queue table...What is it called?
Running into the same issue here as well.. Users who are subscribed to a topic/forum don't always get a notification email when new messages are posted.
Any info would be greatly appreciated!
For mryechkin: take a look at your yaf_Mail table and your event log. Any information that could help?
I have been "watching" several of the forums here now for a few months and I definitely have not received a notification for all of the new topics started.
For example, I am subscribed to watch the "YAF Community Mods, Patches, Themes and Languages" forum.
I looked today and I did not receive a notification for any of the 14 topics that are displayed.
I'm also running SQL 2005, Win2K3.
I have not had a chance to troubleshoot this yet, so any help would be appreciated. I'll start looking through the event log.
The M&R Companies
BTW, the yaf_mail table is always empty. When a user posts a new topic, I see that yaf_watchforum table, the lastmail flag is updated for the users who are subscribed to that forum. But there is nothing in the yaf_mail table.
When I commented out these lines from the yaf_mail_createwatch stored proc, the emails appear to be flowing reliably now.
-- update [dbo].[yaf_WatchTopic] set LastMail = getdate()
-- where TopicID = @TopicID
-- and UserID <> @UserID
-- update [dbo].[yaf_WatchForum] set LastMail = getdate()
-- where ForumID = (select ForumID from [dbo].[yaf_Topic] where TopicID = @TopicID)
BTW, I have a funny feeling about the implementation of the YafInitModule that sends mail. On shared environments like Godaddy where app_pool recycle is probably happening way more often than we would like to imagine, this code will not work reliably.