Mailer Plugin doesn't add to queue or process queue after nightly release upgrade

IF you have latest nightly CBSubs and ALL latest CBSubs integration plugins, then it is most probably a configuration or a potential understanding issue.

Please take this step by step try to help as a guidance to find the issue that your mailer has.:

Let's tackle the potential understanding issue first, by addressing the most common misconception of CBSubs mailer:

- A mail that matched a given Main Mailer Triggering Conditions set in the Basic tab of mailer condition will be sent only once. Other tabs are just conditions that make the mail trigger happen or not, but won't count as different mails.

- The way for CBSubs to know that is that it will check if the same mail with the same triggering date is already in the Message Queue waiting to be sent (and it can stay there if the SMTP server has limitations or errors) or in the Sent mails. Both those lists are in the CBSubs Mailer control panel.

So that's the first place to check both lists to make sure that the mail hasn't been already sent.

Then there is a probability of misconfiguration... The configuration possibilities are quite extensive and there is a small risk that they can be mutually exclusive.

The easiest way to check the configuration for now is to take a look at the SQL query that CBSubs does at the time where it fills the mailing queue. For that, enable Joomla site debug, then access the URL for "Url of cron task to process mailers rules". Just remove the last parameter of the link (&format=raw), so that the debug module can display the queries. There you can find the query for finding the users to whom to mail. Inspect that query, and compare with your trigger of the "Basic" tab. Usually that helps finding configuration errors....or bugs, that are becoming more and more unlikely fortunately. That said we never exclude a bug, but that query and the corresponding query are the cornerstones to find both configuration errors and bugs.

Hope that first 2 steps will help move forward in finding and solving the issue.

Last 3 issue that we had this year with mailers in this forum were either not latest nightly installed, or a configuration issue, or an SMTP server rejecting mass mailings, but not a bug.

Thank you for the response, Beat.

I've already verified that the first two steps are not the issue. The Mail Queue and the Sent Mail lists are both empty. The Sent Mail has never worked on this site. The Mail Queue worked until I updated to the nightly build in hopes of resolving the Sent Mail issue ... now both are broken. I had emptied the Queue after upgrading, in hopes that the upgrade had resolved the issues and could then re-fill the queue and send ... but no such luck.

Also, since the same Mailers worked to fill the Mail Queue before I upgraded to the nightly build, I feel confident that the Mailers are configured correctly.

I provided site access to krileon. He was going to pass that on to you.

I believe I may have found the issue. The logic behind the setting "But do not send message if it's later than" is reversed in this version, as compared to how it worked before the upgrade.

Originally, I had to set that to 'before', such as "3 Months before" in order for mail to be added to the queue. On this latest version I have to use 'after', such as "3 Months After" for the mail to be added to the queue.

Making that modification, then running the cron added email to the queue.

3by400Inc wrote: Thank you for the response, Beat.

I've already verified that the first two steps are not the issue. The Mail Queue and the Sent Mail lists are both empty. The Sent Mail has never worked on this site. The Mail Queue worked until I updated to the nightly build in hopes of resolving the Sent Mail issue ... now both are broken. I had emptied the Queue after upgrading, in hopes that the upgrade had resolved the issues and could then re-fill the queue and send ... but no such luck.

Also, since the same Mailers worked to fill the Mail Queue before I upgraded to the nightly build, I feel confident that the Mailers are configured correctly.

I provided site access to krileon. He was going to pass that on to you.

Please check step 2 of the troubleshooting that I gave detailed instructions above.

CBSubs nightly did fix a bug that had one of the criteria wrong. It was a regression introduced by CBSubs 4.0.1 when fixing another issue.

3by400Inc wrote: I believe I may have found the issue. The logic behind the setting "But do not send message if it's later than" is reversed in this version, as compared to how it worked before the upgrade.

Originally, I had to set that to 'before', such as "3 Months before" in order for mail to be added to the queue. On this latest version I have to use 'after', such as "3 Months After" for the mail to be added to the queue.

Making that modification, then running the cron added email to the queue.

Great!

Now do your emails send clicking the sending url ?

No, nothing is being added to the Sent Mail. I did get a more detailed response from the cron which indicated there was an error in sending the messages.

Where can I go to see a log of those errors?