Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: [forum] Subscriptions not working for me
What Uli said about online users does play apart in email delivery. I took a quick look in the source code, and this is the query PunBB uses for selecting addresses it sends email notifications to:
SELECT u.id, u.email, u.notify_with_post, u.language
FROM '.$db->prefix.'users AS u
INNER JOIN '.$db->prefix.'topic_subscriptions AS s ON u.id=s.user_id
LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id='.$cur_posting['id'].' AND fp.group_id=u.group_id)
LEFT JOIN '.$db->prefix.'online AS o ON u.id=o.user_id
LEFT JOIN '.$db->prefix.'bans AS b ON u.username=b.username
WHERE b.username IS NULL AND COALESCE(o.logged, u.last_visit)>'.$previous_post_time.' AND (fp.read_forum IS NULL OR fp.read_forum=1) AND s.topic_id='.$tid.' AND u.id!='.$pun_user['id'])The $previous_post_time variable in the above query is populated with a timestamp that is result of:
SELECT posted FROM '.$db->prefix.'posts WHERE topic_id='.$tid.' ORDER BY id DESC LIMIT 1, 1It’s the second to last post’s date in the current topic.
All emails for a topic are always sent right away when a new reply is posted. There is no queue system involved, or anything of that kind. You will not get emails you’ve missed since your last login.
In short, this means that you will only get one notification per topic until you re-log in. This system tries to prevent you getting massive number emails. You will not get any new notifications after the second to last post in the topic you are subscribed to exceeds your last login/visit date.
Last edited by Gocom (2013-03-11 23:22:30)
Offline
Re: [forum] Subscriptions not working for me
OK, that’s interesting, but I am subscribed to this topic, I last visited the forum at 08:28:57 yesterday (11/03/2013) according to the report at the top of the page.
I’m now looking at this page at 10:32 on 12/03/2013 and, as you can see, there have been several posts since my last visit and I have not received any emails from the forum in the intervening period.
After my visit yesterday, I quit my web browser (Safari 5.1.7) without clicking the logout link on the forum. When I visited again this morning I was already logged in and didn’t need to enter username/password.
My domain is hosted on Textdrive and I use their standard email, using either Apple Mail on my Mac or Mail on my iPhone to check email. I use SpamSieve on my Mac to filter out spam and just live with it on my iPhone. I have checked and there are no forum notifications in the Spam folder on my Mac.
Forum notifications used to work fine for me, but they haven’t done so for the last few months. I’m wondering now if it is related to when I migrated from Joyent to TextDrive II, but I can’t be certain and I;m not sure why they would have suddenly stopped working then as all my other email appears to be coming through without a problem.
Offline
#18 2013-03-12 15:05:03
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,316
Re: [forum] Subscriptions not working for me
springworks wrote:
all my other email appears to be coming through without a problem.
That sounds quite similar to my forum email experiences from last November, it’s only been this forum that didn’t come through. I then changed the email address in my forum profile to a completely different email service, and received forum emails as ever before.
Choose one that you know sends you each and every garbage, but choose another one than your current. Don’t let Spam Sieve filter that account, if possible. And wait what happens.
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline