Issue Generating Mailer

Folks,

I have a Mailer that I've been running for years. I recently upgraded to Joomla 5.3.3. I'm running the latest versions of CB AND CBSUBS. I have a mailer that simply sends an invoice to some of our membership. The mailer is based off of the subscriptions expiry date. The criteria for the mailer is it has to be in one of 5 plans, is after 8 months of the subscription expiry date and not after 9 months. When I run the mailer, no records are found. I've run MS-SQL scripts to confirm all records have a subscription expiry date of 1/1/2025 and are in the problem plans. 

How to I determine the SQL that is running for the Mailer so I can see what the issue is with not pulling the records?

Thanks,
Joe Rebele
NPHIC

Do you have a CRON task setup with your host to run the mailer processing URL? If not that is necessary. It's possible this got messed up during the migration is maybe the URL isn't accessible anymore so you'll want to try running the URL manually to make sure you can still access it. You can find the URLs in CBSubs > Mailer > Automation settings.

Kyle,

Thanks! I found the problem. Thanks for the tip. It turns out the cron executed and ran the invoices. I've been running manually so don't need the cron. All the data I need to send needs to be deleted from the sent mails table and I'll be good to go. thanks for the help.

Please close this request.

Thanks,
Joe