Have you looked at who you're getting a bounce back from?
Is this from an account who has recently edited their settings for emailed post notifications turned ON?
Is this from a new account?
edit: How are your new account settings -- are they set to default all new posts/Watch Lists are emails?
I believe "user #1" is the template for which all new registration settings are based off.
Are you sure the bounce back was related to a post? Rather, It could have been a PM notification.
UPDATE `ubbt_USER_PROFILE` SET `USER_NOTIFY_ON_PM` = 'yes';
Furthering on what Gizmo posted above;
What was the result of your query when you ran it?
0 row(s) affected by your query.
Did you run your query from the Database Tools > SQL Command screen within UBB.threads
, or from an external SQL tool?
Your external tool may require also specifying a database name prior to the table name,
Did you take care in using the correct letter CASE of the tables which are in your database? They are case sensitive.
update ubbt_user_profile set user_email_watchlists = 0;
IS NOT THE SAME AS THIS:
UPDATE `ubbt_USER_PROFILE` SET `USER_EMAIL_WATCHLISTS` = '1';
Further reading at:https://www.ubbcentral.com/forums/ubbthreads.php/topics/196068/re-couple-of-questions#Post196068
Blacklisting is mail provider specific. For example, emails to @aol.com and @hotmail.com addresses may always get sent to the recipient, @gmail.com may put you on to a blacklist. In addition, if you are not clear in your email footer about how to unsubscribe, a email host may automatically stick you on their blacklist, regardless if you only ever send a few items a day/week.
Some final words on emails / bounces / blacklisting...
Is the email server your' sending from using any type of security or encoding the messages before being sent? Or are you sending them from a plain text mailer?
How about your mail server; are you the only person sending from it? or are you on a shared mail server IP address, where others from the same hosting company are sending out emails from. It could be that those others are getting your addresses blacklisted as a spammer.
This could also be true for if you're on shared hosting and are placed on a box with 2,000 other accounts. Of which, a few accounts offer adult related content or "medications." You'd be classified in that same set also -- and possibly blacklisted. All because of the few accounts shared on the same box as you. Similar blacklisting could happen if the topics on your forums are of the "sensitive topics" categories.