Skip to Content Skip to Menu

🌟 CB Editor Assistant 1.0.0 is here! Discover our new AI Joomla Plugin that wrote its story! (and this banner!)
Start at just $12.50/month* or 💸 save 30% with our 🛍️ Black Friday Intro Offer for your subscription's lifetime
🎉 Black Friday sale is here! Great savings on professional and developer memberships! Get 25% off now with code BLACK-FRIDAY-2024!

CBSubs Mailer throwing DATETIME parse error

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
1 week 1 day ago - 1 week 1 day ago #339669 by fdinkler
Running the CBSubs Mailer using the automation URL throws this error:
0   Failed to parse time string (DATETIME) at position 0 (D): The timezone could not be found in the database  
Attachments:
Last edit: 1 week 1 day ago by fdinkler. Reason: deleted unformatted stack trace data

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48560
  • Thanks: 8292
  • Karma: 1445
1 week 16 hours ago #339673 by krileon
Replied by krileon on topic CBSubs Mailer throwing DATETIME parse error
Looks like you have a condition configured to compare dates and you're supplying an invalid date. Please review the conditions on your mailer carefully.


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 or Create an account to join the conversation.

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
1 week 12 hours ago - 6 days 17 hours ago #339681 by fdinkler
Replied by fdinkler on topic CBSubs Mailer throwing DATETIME parse error
Attached a screenshot of the mailer that's been blowing up.
I've been using this value successfully, at least until now...

[cb:date format="PHP_DATE()_FORMAT" date="DATETIME" /]
 
Last edit: 6 days 17 hours ago by fdinkler. Reason: Added screenshot

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48560
  • Thanks: 8292
  • Karma: 1445
4 days 19 hours ago #339685 by krileon
Replied by krileon on topic CBSubs Mailer throwing DATETIME parse error
That isn't a valid substitution. You've just copy and pasted the structure example. Below is an example of a working date substitution.

Current Date:
[cb:date format="Y-m-d" /]
Current Date with Time:
[cb:date format="Y-m-d H:i:s" /]

Please be sure to read through the substitution tutorial below carefully as we do provide examples.

www.joomlapolis.com/documentation/127-community-builder/279-tutorials/18353-using-substitutions-throughout-cb


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 or Create an account to join the conversation.

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
4 days 18 hours ago #339690 by fdinkler
Replied by fdinkler on topic CBSubs Mailer throwing DATETIME parse error
Thanks, Kyle -
FYI the substitution I used DID work earlier, and it was copied directly from the document your referenced above.

Date - display a preformated date based off current date and time
[cb:date format="PHP_DATE()_FORMAT" date="DATETIME" /]

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48560
  • Thanks: 8292
  • Karma: 1445
4 days 18 hours ago #339691 by krileon
Replied by krileon on topic CBSubs Mailer throwing DATETIME parse error

FYI the substitution I used DID work earlier, and it was copied directly from the document your referenced above.

It absolutely could not have. That's not a valid substitution. It will pass invalid values to PHP date function causing an error to throw.

You copy and pasted the syntax. You did not copy and paste the example. The syntax is there to describe how it's used.

format = PHP date() function format
date = valid datetime value (leave empty for it to use current datetime)


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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum