XF 2.3 Convert soft bounce to hard bounce

[kailew]

Hello everyone,
I have a lot of users who have received a soft bounce in the mail log. Unfortunately, this information cannot be found in the user status. It mainly affects Yahoo addresses where the mailbox is disabled. Is there a way to assign these users the status “Email invalid (rejected)”? Probably via MySQL ... but I wouldn't know how to do that either.

 

[MySiteGuy]

1. Enable bounce processing.
2. Set the number of soft bounces allowed to one.

This will make soft bounces behave like hard bounces.

 

[kailew]

also the old ones? I've tried it ...

 

[MySiteGuy]

No, not previous bounces. Only going forward.

 

[kailew]

okay, then again: I have a lot of users who have received a soft bounce in the mail log. Unfortunately, this information cannot be found in the user status. It mainly affects Yahoo addresses where the mailbox is disabled. Is there a way to assign these users the status “Email invalid (rejected)”? Probably via MySQL ... but I wouldn't know how to do that either.

 

[kailew]

no one?

 

[Opus X]

do not worry about old ones.
if you have soft bounces set low enough if they process again it will change it.
my site was set by the previous owner to allow 2 soft bounces.
he said since he ran ses he would rather force the user to reconfirm their address.

 

[kailew]

What so you mean with process again? I can no longer send mails to participants with a soft bounce and I don't want to. There are a lot of Yahoo addresses with deactivated mailboxes. I know that they will generate a bounce if I send another mail. And that's why I don't want that. Because I get problems with my mail provider if I generate so many bounces. That's why I want to filter out these mails and then delete the subscribers.

 

[Kirby]

Untested
UPDATE xf_user SET user_state = 'email_bounce' WHERE email IN (SELECT recipient FROM xf_email_bounce_log)

 

[Opus X]

What so you mean with process again? I can no longer send mails to participants with a soft bounce and I don't want to. There are a lot of Yahoo addresses with deactivated mailboxes. I know that they will generate a bounce if I send another mail. And that's why I don't want that. Because I get problems with my mail provider if I generate so many bounces. That's why I want to filter out these mails and then delete the subscribers.

soft bounce is sent until turned to hard bounce.
set soft bounce 1 or 2.
after that they are hard bounce and send no more.
and xenforo should make account require email validation again.
that is why there is setting to fix number of soft bounces before action.
for long term you will need to know who they are and run sql for it.
but to prevent more do what i talked about.

 

[kailew]

after that they are hard bounce and send no more.
and xenforo should make account require email validation again

as I wrote: It's not possible to send mails to the bounced adresses for various reasons. So it's not possible to start a new validation round to get the status hard bounce. That's why I've asked for a SQL solution.