wp-autoresponder icon indicating copy to clipboard operation
wp-autoresponder copied to clipboard

Mail delivery failed

Open aehageman opened this issue 13 years ago • 2 comments

When a visitor enters an incorrect email address and the error 550 No such user, is returned. The address is still entered into the database. Can automation to remove these types of email address be added? Many people enter in bogus emails, to test the system response/get to the free content without a valid email addres, as some older systems still take you to the next page... Some type of email authentication is needed to handle these bad emails.. As one of my clients is receiving almost a hundred Mail delivery failed messages each day.

521 confirmed address and 2553 unconfirmed.. Most of the unconfirmed are invalid email addresses...

The database is growing quickly and no way to remove these bad emails....

Thanks

aehageman avatar Oct 10 '11 20:10 aehageman

A check can be added such that unconfirmed emails longer than, say 60 days, are automatically deleted. I'll see what I can do.

nodesman avatar Jan 24 '12 19:01 nodesman

I went to the database directly via phpMyAdmin in Hostgator control panel and deleted the records that are unconfirmed. This is the sql DELETE FROM wp_wpr_subscribers WHERE confirmed =0 AND DATE <1354320000

The date is UNIX format so I chose Dec 1 since I didn't want to delete recent subscribers who haven't confirmed. You can find your database name in the wp-config.php file in the root directory of wordpress.

willkriski avatar Dec 07 '12 12:12 willkriski