wotan2525

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');
}

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: https://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?

@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.

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

@mattyrob — The checkbox is visible and unchecked.

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. ??

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.

thematic looks cool…. I’ve never seen that before. I’ll do some playing in a sandbox tonight and see what I can come up with. I appreciate it. I’m not going to wholesale lift from notcot.org…. I just want to use a similar grid system for my posts.

is notcot.org using a custom cms?

there is some problem with the link…. if you look at the URL it says “/wp-admin/edit-comments.php?page=akismet-admin?page=akismet-admin”

For some reason the link is generating “page=” two times…. knock off the last “?page=akismet-admin” and it will work fine.