Skip to Content Skip to Menu

🌟Discover the Joomla AI Plugin that wrote its own story! - CB Editor Assistant 1.1now for Joomla 3, 4 & 5!
✍️ 5-Day Free Trial, then 🎯 save up to 30% with our 🛍️ Intro Offer (First 50 users, ends Dec. 25th)
🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

CBSubs Mailer throwing DATETIME parse error

  • fdinkler
  • fdinkler
  • OFFLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
1 month 3 days ago - 1 month 3 days 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 month 3 days ago by fdinkler. Reason: deleted unformatted stack trace data

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48616
  • Thanks: 8302
  • Karma: 1446
1 month 2 days 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
  • OFFLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
1 month 2 days ago - 1 month 1 day 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: 1 month 1 day ago by fdinkler. Reason: Added screenshot

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48616
  • Thanks: 8302
  • Karma: 1446
4 weeks 1 day 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
  • OFFLINE
  • Posts: 217
  • Thanks: 27
  • Karma: 0
4 weeks 1 day 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: 48616
  • Thanks: 8302
  • Karma: 1446
4 weeks 1 day 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