[#5693] Mailer bug
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 4 months ago - 8 years 3 months ago #275810
by activha
[#5693] Mailer bug was created by activha
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
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
Last edit: 8 years 3 months ago by krileon.
Please Log in to join the conversation.
krileon
Team Member- ONLINE
- Posts: 68529
- Thanks: 9093
- Karma: 1434
8 years 4 months ago #275822
by krileon
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.
Replied by krileon on topic Mailer bug
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.
Please Log in to join the conversation.
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 4 months ago #275825
by activha
Replied by activha on topic Mailer bug
Very simple mailer
Please Log in to join the conversation.
- krileon
- Team Member
- ONLINE
- Posts: 68529
- Thanks: 9093
- Karma: 1434
8 years 3 months ago #275832
by krileon
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.
Replied by krileon on topic Mailer bug
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
#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.
The following user(s) said Thank You: activha
Please Log in to join the conversation.
- activha
- OFFLINE
-
Platinum Member
- Posts: 2279
- Thanks: 113
- Karma: 13
8 years 3 months ago #275833
by activha
Replied by activha on topic Mailer bug
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
Provided we have access to all substitution strings from CBsubs and promotion it could do
Please Log in to join the conversation.
- beat
Team Member- OFFLINE
- Posts: 8175
- Thanks: 528
- Karma: 352
8 years 3 months ago #275854
by beat
Beat - Community Builder Team Member
Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
Replied by beat on topic Mailer bug
Thanks for reporting issue. Fixed for next CBSubs nightly.
Was due to more than one possible status selected in subscription status condition.
Was due to more than one possible status selected in subscription status condition.
Beat - Community Builder Team Member
Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
The following user(s) said Thank You: activha
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.237 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [#5693] Mailer bug