YAFLogo

jbliss1234
  • jbliss1234
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
We are running yaf version 1.9.3 on SQL Server 2005.

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?

Sponsor

mryechkin
12 years ago
+1

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!

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
12 years ago
I tried to discuss directly with the above user (not mryechkin), but he did not get back to me. I was curious how he arrived at the 80% figure.

For mryechkin: take a look at your yaf_Mail table and your event log. Any information that could help?

chriscoe71
12 years ago
I'm having the same problems. I don't know what the actual % is.

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.


jbliss1234
  • jbliss1234
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
I am still experiencing this issue.

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.

jbliss1234
  • jbliss1234
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
I think I have figured out the mystery. The issue appears to be that watch email records are not getting inserted into 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.