Emails Have Quit Sending

Resolved wotan2525
(@wotan2525)

12 years, 4 months ago

Everything was working fine 2 weeks ago. I’ve followed the trouble-shooting steps on the plugin home page, disabled all plugins and tried with the basic theme and it still wasn’t sending.

I’ve double-checked that the “number of recipients per email” is set to 1.

I installed the email log plugin and I’m not seeing any emails being triggered by a new post.

When I send a preview email from the appearance page, I do generate emails and they arrive in my inbox as well as show up in the email log.

I’ve contacted my hosting provider and they’ve double checked everything on their end and are not filtering/restricting emails or seeing any triggers that are being tripped on their end.

Using Subscribe2 9.0 and WordPress 3.8. What’s next?

http://wordpress.org/plugins/subscribe2/

Viewing 14 replies - 1 through 14 (of 14 total)

Matt Robinson
(@mattyrob)

12 years, 4 months ago

@wotan2525,

Thanks for giving me a thorough description of the issue and everything you have tried.

Since the email log is registering nothing on a new post it seems that the emails are indeed being bypassed for some reason. Have a look in subscribe2->Settings under the “Registered Users” tab, have you got any excluded categories?

Also, have a look in the Appearance tab. Is the “Disable email notifications is checked by default on authoring pages?” option checked?

Are you using a custom post type or taxonomy or are this core WordPress posts?

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

Thanks for such a quick response!

I’ve excluded a couple of categories — one is for a flickr category which is used by a plugin to automatically generate a gallery. I’ve also excluded an “events” category that is used by “The Events Calendar” plugin to generate a calendar page.

These are core WordPress posts. Most of them are actually “uncategorized” but almost all of my members are subscribed to this category and I’ve tested with additional categories and have not seen anything send.

Matt Robinson
(@mattyrob)

12 years, 4 months ago

@wotan2525,

If you go back to the edit post screen, is there a “Subscribe2 Notification Override” meta box? Is the checkbox in there checked? (If it isn’t visible, make it show up in the Screen Options tab at the top of the screen next to help.

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

I thought I had it figured out — I created a “test” category with only two addresses on it. If I posted to the “test” category, it sent out 2 emails.

I then unsubscribed all of my users from every category and re-subscribed them to the ones I’d like to trigger emails. I also changed all of them over to “plaintext – full.”

Then I posted a new item….. No emails. 🙁

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

@mattyrob — The checkbox is visible and unchecked.

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

Have also tried 0 vs. 1 on the number of recipients field.

The more I play with this, the more I’m convinced it’s a triggering problem. Is there any kind of debug or developer log I can enable to see where there might be the problem?

If I post to my “test” category ONLY, I trigger an email. If I post to my “test” category and others, no email. I don’t really want to add all of my subscribers to the test category just to see if they’ll get an email….. So I’m stuck for now. :p

Matt Robinson
(@mattyrob)

12 years, 4 months ago

@wotan2525,

Try resetting the Subscribe2 settings, make a note of your current templates first (copy and paste them into a text editor) and also make a note of other major settings changes you’ve made. It seems to me like there might be an corruption in the excluded categories.

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

@mattyrob — I reset the settings, still no e-mails.

Thinking that maybe I had problems with my categories, I created a new category, subscribed all my users and then posted to that category — still no email.

I tried switching the author (thinking maybe there was a problem and the admin account was being excluded.) Still no emails.

Matt Robinson
(@mattyrob)

12 years, 4 months ago

@wotan2525,

If you are happy with code have a look in the publish() function if the classes/class-s2-core.php file and add some break points in there.

If you are not happy digging into code then would you be happy to share log in details so I can have a look?

Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago

Decided to go even further — uninstalled Subscribe2, reinstalled. Still not triggering emails or showing anything in email log. 🙁

I’ve checked my server logs and I believe I have found the culprit:

Tue Dec 31 14:00:56 2013] [error] [client (redacted)] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT a.user_id FROM wp_usermeta AS a INNER JOIN wp_usermeta AS b ON a.user_id = b.user_id INNER JOIN wp_usermeta AS c ON a.user_id = c.user_id INNER JOIN wp_usermeta AS d ON a.user_id = d.user_id WHERE a.meta_key='s2_subscribed' AND a.meta_value <> '' AND b.meta_key='s2_format' AND b.meta_value='html' AND (c.meta_key='s2_cat17') AND (d.meta_key='s2_authors' AND NOT FIND_IN_SET('617', d.meta_value)) made by edit_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('draft_to_publish'), call_user_func_array, s2class->publish, s2class->get_registered, referer: http://www.*******.com/wp-admin/post-new.php

Mean anything to you?

I’d be happy to share some login details for you — feel bad to be so much trouble today! Is there an email I can reach you by?
Thread Starter wotan2525
(@wotan2525)

12 years, 4 months ago
Here’s a temp workaround that I’ve verified works for me. Not sure if the error indicates that I’ve got additional problems, but the easy fix seems to be allowing big selects. I’ve only got 280 users registered on my blog so it’s weird that this kicked in…..

Adding this to my functions.php file in my theme solved the problem and emails are sending again.
```
add_action('init', 'subscribe2_allow_large_joins');
function subscribe2_allow_large_joins(){
	global $wpdb;
	$wpdb->query('SET SQL_BIG_SELECTS=1');
}
```
Matt Robinson
(@mattyrob)

12 years, 4 months ago

@wotan2525,

Great work! I hope I was of a little help. It seems to be a server side default SQL limitation but one that can be reconfigured. I guess your provider updated the SQL server recently if imposed the new restriction to ease server load.

dbreckenridge
(@dbreckenridge)

12 years, 3 months ago

I am running Subscribe2 9.0 with WordPress 3.8. Emails have been working fine for a long time. I should send 307 emails for each post. My server allows 750 emails/hour and I am the only one that can generate the email, so I’m confident that I am not exceeding the server limit. Emails are generated by an address within my domain and number of recipients per email is set to one.

About a month ago, not sure if it was just after an update or not, I started getting a “500 Server Error”. The post screen would blank out and then bring up the following error:

500 Server Error
A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again.

My host has no idea.

Using the browser refresh button would bring me back to my post, which in fact had been posted.

I knew that some of the emails were being sent because I received 2 of them to 2 different email addresses, but other users were not getting the emails. I talked to my host provider and all they could do is tell me that my email limit was indeed still set to 750/hour and that a lot of emails were being sent. They could not tell me exactly how many. I looked at your troubleshooting tips and loaded the email log plugin. I then created 2 posts (a day apart) that should have generated 307 emails each. One generated 268 and one generated 256. Both produced the blank screen followed by the error message and upon requery returned to the wordpress editor with my post displayed and posted.

A little more research and I found this thread. I may not have done this correctly, but I put this code in my themes function.php file:

add_action(‘init’, ‘subscribe2_allow_large_joins’);
function subscribe2_allow_large_joins(){
global $wpdb;
$wpdb->query(‘SET SQL_BIG_SELECTS=1’);
}

I just pasted it at the bottom. It did not work, however. I sent a post and it only generated 254 of the 307 emails.

I then ran in to this thread:
http://wordpress.org/support/topic/possibly-not-working-with-wp-38?replies=2

I think one time I got an error about losing the connection. I have not talked to my host about the database limit, yet. Do you know what limit I might ask about? Like I said, I’ve used subscribe2 for several years and only run into this issue in the last month.

Thanks,

Dan

Matt Robinson
(@mattyrob)

12 years, 3 months ago

@dan,

You really should have opened your own thread with this issue.

A 500 – Internal Server error is very non-specific and tell the user reading the message absolutely nothing other than something is wrong.

It’s ridiculous that your hosting provider can’t help, they have access to the error logs and should be able to pin point a more specific error message. Until we know what they is we are working blind. You need to get back to your host and get this issue escalated.

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘Emails Have Quit Sending’ is closed to new replies.