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?
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 (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
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.
krileon
