Mail delivery failed: returning message to sender

[Panzer Max]

So, I have about 30 of these a day, letting me know members are subscribed to a post somewhere or have a PM and the forum is trying to send them an email, but their email is invalid. I like to see these one by one and check the member profile, what do I need to do to disable them from all future emailings?

Send Notification Email When a Private Message is Received: No
Automatic Thread Subscription Mode: Do not subscribe

What else?

thanks

[kh99]

You could remove all the user's subscriptions by going to the user's page in the admincp and selecting "Delete Subscriptions" from the Quick User Links menu. Also you could set "Receive Admin Emails" to No on that same page.

[Panzer Max]

Oh nice! I never noticed that before.

That does not affect paid subscriptions, just post subscriptions?

Cool! Thanks! Thanks! Thanks!

[kh99]

Originally Posted by Panzer Max

That does not affect paid subscriptions, just post subscriptions?

I believe that's true, yes. Looking at the code, it removes subscriptions to forums, threads, groups, discussions, and events.

[Panzer Max]

While on the subject, I wonder if there is a way to update the db and select members who have not had activity since 2011 and change their subscriptions' Notification Type to No Email Notification.

Anyone know which field and table this would be in? There is a field in USER called AUTOSCUBSCRIBE, is that it?

[kh99]

I think that might be the default for new subscriptions, but each subscription can have a different type, so I think you'd need to update the various subscription tables and change the type (looks like the field is 'emailupdate' in most of them).

Someone else was asking the other day about a similar issue (disabling emails that bounced) and came up with the idea of simply deleting the email from the user table. I can't say exactly what would happen if you did that, but it does look like the emailing function won't try to send out an email if the "to" address is blank.

[Panzer Max]

That's a good idea. I am also thinking about creating a deademail account, or some thing to change the email to and have it go away.

Checking the failed emails helps me weed out new registrations that are not legit, and also to alert older active members who need to update their email.

I wonder, if I uncheck Receive emails from Admim on a user, will that stop the Happy Birthday emails?

[kh99]

Originally Posted by Panzer Max

I wonder, if I uncheck Receive emails from Admim on a user, will that stop the Happy Birthday emails?

Yes. I haven't tried it, but looking at the code, the birthday email code seems to check the "Receive emails from Admim" option.

[Panzer Max]

Super, thanks! I will start working on an sql statement that will uncheck that and delete subscriptions for members with less than X posts and have last activity is older than 1 year.