[SOLVED] Mailers stopped working after upgrade

Looks like it's date ranges in our case...

SELECT * FROM `xxx_cbsubs_subscriptions` AS m WHERE (m.`expiry_date` <= '2016-02-13 14:51:18') AND (m.`expiry_date` >= '2016-02-28 14:51:18') AND m.`plan_id` = 3 AND m.`status` = 'A' ORDER BY m.`id` DESC

Expiry date can't be both on or before 13th February AND on or after 28th February

Not sure if this is connected to the issue of the mailers or not in this thread but I did just process some notifications manually using the link to process mailer rules (116 identified, all but 57 were left in the mail queue after I also then processed the queue using the 2nd link. It looks like the other mailers (I have 4 total) were queued but not mailed.

When I try to send those 57 (all are reminders of a future expiration) I get a message that says there is no mail to be sent.

So all mailers are being processed (as far as I can tell) but only one mailer (Expiration) is sent from the mailer queue. All the emails not being processed are from currently Active subscriptions.

Please see screenshots.

Thanks,
Mark

Has this been addressed? Is there a solution?

Thanks,
Mark

marse7 wrote: Not sure if this is connected to the issue of the mailers or not in this thread but I did just process some notifications manually using the link to process mailer rules (116 identified, all but 57 were left in the mail queue after I also then processed the queue using the 2nd link. It looks like the other mailers (I have 4 total) were queued but not mailed.

When I try to send those 57 (all are reminders of a future expiration) I get a message that says there is no mail to be sent.

So all mailers are being processed (as far as I can tell) but only one mailer (Expiration) is sent from the mailer queue. All the emails not being processed are from currently Active subscriptions.

Please see screenshots.

Thanks,
Mark

I have spent some time to look a bit deeper into your issue. The issue is your mail server.

When trying to process the 63 mailers that were in the queue, I got following result:

"Sent 49 messages successfully but failed sending 14 messages."

Then the 14 unsuccessful messages have stayed in the mail queue, and have been re-scheduled to be retried to be sent in around 8 hours automatically by CBSubs when the send mail URL is used.

I have also checked all queries, and none of them is illogical anymore. This might have been due to a wrong setting that got fixed in the mean time.

You may need to check with your mail provider what mails sending rates your are allowed to.

autobahn wrote: Looks like it's date ranges in our case...

SELECT * FROM `xxx_cbsubs_subscriptions` AS m WHERE (m.`expiry_date` <= '2016-02-13 14:51:18') AND (m.`expiry_date` >= '2016-02-28 14:51:18') AND m.`plan_id` = 3 AND m.`status` = 'A' ORDER BY m.`id` DESC

Expiry date can't be both on or before 13th February AND on or after 28th February

@autobahn, you probably have a setting in your corresponding mailer that is impossible, or do not have the latest nightly of CBSubs and CBSubs integration plugins.

The mailer is 'Send automatically one month before expiry date but not if it is less than two weeks before expiry date'. This mailer has been in place a long time, is unchanged and no longer works.

Where do I find the nightly build?