Mailer not finding data

Folks,

I'm having an issue with Mailer extracting data. This has been working fine until I upgraded to Joomla 5. I was previously on Joomla 3. I setup an SQL with the same parameters as my mailer and it finds 30 rows. I have no conditions on the mailer. It looks at 5 pay plans, account must be active and needs to be after 8 months from the subscription expiry date and does not send if it is later than 9 months.

Does the mailer check any other tables that may be causing the data extraction to fail? I attached the SQL script I used to pull the data.

Please let me know your guidance on resolving this issue.

Thanks!
Joe

The mailer takes into account whether they've already been emailed or not as well based off your configuration. The way it works is it first finds applicable users to email, pushes them into the queue, then processes the queue. Now how it processes the queue also depends on how you're running things. Have you tried clicking the URL to process the queue directly in CBSubs > Mailer > Automation Settings? It's possible the URL isn't accessible anymore and that's the reason for the problem, which can happen since Joomla 4 and 5 are a lot more strict about menu access now.

Kyle,

Thanks! I do all my sending of emails manually through Automation settings. I first click the first URL which processes the data and places the emails in the queue. I then click on the second URL to send the emails in the queue. The problem right now is the first URL is not generating the data. 

First URL (Process Mailer):
[REMOVED]/index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&cbpact=cbsubsclass&cbpclass=mailer&cbpmailerdo=processmailerrules&user=62&Itemid=937&format=raw

Second URL (Process MailQueue):
[REMOVED]/index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&cbpact=cbsubsclass&cbpclass=mailer&cbpmailerdo=sendmailqueue&user=62&Itemid=937&format=raw

I am sending invoices. All of the folks on the list have been sent this invoice email. We send the invoices monthly until they pay. This has never been a problem before.

Where should I start looking for the problem?

Thanks,
Joe

What do you see when you navigate to that URL? Try removing "&format=raw" from it and retry. It's possible Joomla is blocking access to it due to the menu item associated with the menu id of 937.

Kyle,

I removed the &format=raw. Same result. 1 record processed. I don't think Joomla is blocking the request since it does find 1 record. Menu item 937 is a menu item for Pay Dues which is using this link:

index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&do=display_subscriptions

What database tables does Mailer check when it runs "Url of cron task to process mailers rules"? 

Not sure what to do next.

Thanks,
Joe

So it found 1 record and added them to the queue, but it's not sending the email or it's not actually adding them to the queue? Was it supposed to add more than 1 record? It accesses several database tables. I don't think there's a problem with the database, but possibly a problem with the mailer configuration.