Please PM FTP login credentials and will add debug code. I'm not sure if there's something wrong with the query that matches users to be emailed or if there's processing after that that could be erroring.
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.
Ok, it looks like there's a problem with the date conditions. For example one of the queries is as follows.
Code:
SELECT *
FROM `j25_cbsubs_subscriptions` AS m
WHERE (m.`expiry_date` <= '2016-02-09 16:24:11')
AND (m.`expiry_date` >= '2016-04-09 16:24:11')
AND m.`plan_id` = 2
ORDER BY m.`id` DES
Notice it's checking for expiration less than or equal to Feb 9th, but greater than or equal to April 9th. That's impossible to match. Seams maybe the operators or something are backwards.
I've reported the findings to Beat so he has a better idea of what to look for and hopefully can have a fix soon.
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.
Any movement on this? It's rather important that my client's org get the expiration mailers out.
By the way, I changed the new expiration mailer to 1 day after expiration but not after 60 days and it seemed to work but ONLY when I used both URL processing link. When I used the top link - the one that triggers the messages to the mail queue it didn't work and nothing was sent.
krileon
