rajasekharan/WP-Autoresponder — Issue #76: autoresponder mailings not being sent since update
Author: vicmich
Created: 2012-02-08 02:36:54+00:00
State: open

Well, I'm at my wits end.

I'm using wpr on www.myoldworkshop.com, and I'm able to subscribe and confirm people, but blog post mailings and autoresponders are not going out.

I first downloaded wpr in November, and quickly found it to be a great solution. I set up subscription forms for blog posts, for blog posts and an autoresponder, and for blog posts and an autoresponder (with a checkbox to opt out of the blog posts. They all worked great through numerous tests over the last couple of months.

Simultaneous with finally going live with my site on Friday, I updated from wpr 5.1.1 to 5.2.6. After restoring my templates to customize landing pages, and modifying confirm.php to forgo the second confirmation email (confirmed), I tested all my forms and things seemed to be working fine.

But one test subscriber received more than a dozen copies of the first autoresponder on Friday night, and then again on Saturday. Then they stopped. He didn't get number 2 or 3 in the series. The other subscribers that should have got the autoresponder didn't. Nor did anyone get blog posts.

My attempts to fix this

1. I restored the earlier version of wpr, leaving the tables in place. (I had about 120 records in the _wpr_queue table at that point.)
With this I managed to get a couple autoresponders queued up at one point, but mostly not. (And if I recall correctly, when I finally saw these guys they were subs I'd actually deleted!) To get them out, I had to manually release them using the technique outlined in Background Procs. But those were the only ones ever sent. So now, I didn't have to worry about numerous duplicate emails, but no one's getting anything.

2. I went back to the new version of wpr, without modifying the database. Same deal, except now, nothing ever made it into the queue. New subscribers were shown as confirmed, with 0 messages received under autoresponder progress.

3. I saw the note about existing installations and queues and emptied my _wpr_queue and tried again. No luck. Also various deactivations and activations of wpr, numerous subscriber deletions and resubs.

4. I deactivated wpr 5.2.6. I dropped all the wpr tables. I reactivated, and repopulated these four tables from the previous version.
wp_wpr_autoresponders
wp_wpr_autoresponder_messages
wp_wpr_newsletters
wp_wpr_subscription_form

I left the other tables empty.

Still nothing. People can subscribe and confirm and they show up correctly in the subscriber list, but they're not getting anything. Nothing gets queued.

5. Finally, I deactivated and deleted wpr. I dropped all the tables. I downloaded a fresh version of 5.2.6 and uploaded it manually. I activated it, and *manually* began to re-enter everything via wpr. Nothing's changed. I can subscribe, but they don't get anything.

The only other thing I can note is that around the same time I updated to 5.2.6 the first time, I edited a couple of dates for scheduled posts via WP admin, and since then I'm getting the "missed schedule" error. I temporarily activated a plug-in to try and fix this today, and it did the trick. But didn't change anything with wpr.

At least I'm still in the first few days of being live, so it's not like I'm getting swamped with traffic and subscribers…. but I wish I had just stayed with 5.1.1.!!!