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.

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)

-- and UserID <> @UserID

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.