Hello
Trying to use mailer with subscription's subscription date gives the following error when automation settings is used to process (for tests purposes) whatever the time setting used :
1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'R 'X' ORDER BY m.`id` DESC' at line 5 SQL=SELECT * FROM `_cbsubs_subscriptions` AS m WHERE (m.`subscription_date` <= '2015-12-29 08:59:35') AND (m.`subscription_date` >= '2014-12-29 08:59:35') AND m.`plan_id` = 6 AND m.`status` R 'X' ORDER BY m.`id` DESC
Please provide a screenshot of your exact mailer configuration. Please also ensure you've latest CB 2.x nightly and latest CBSubs 4.x nightly installed.
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.
Was able to confirm your issue. Appears to be due to "Must be in state". Once set to "--- Not relevant ---" it'll work fine, but then it won't apply to your usage exactly anymore. I've created a urgent priority bug ticket for Beat to look into. Unsure what was changed to break this.
#5693
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, will try to test the auto action mailing function to see if it fits our needs.
Provided we have access to all substitution strings from CBsubs and promotion it could do
krileon
