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!

Errors in query field SQL causes PHP crash

  • bascherz
  • bascherz
  • OFFLINE
  • Posts: 228
  • Thanks: 29
  • Karma: 11
6 years 8 months ago #302751 by bascherz
I just bought a professional license and was creating a test query field on a live site. I unwittingly made a typo in the query and when I opened my test profile the page errored out. This should never happen. The CB code that handles these user-defined queries should catch and handle exceptions. It's really something a user should not have to point out. It's one thing for the field not to render and display something like "Error in field definition" but yet another for the whole page to crash. Not good.

Bruce S - Vienna, VA

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48560
  • Thanks: 8292
  • Karma: 1445
6 years 8 months ago #302775 by krileon
Replied by krileon on topic Errors in query field SQL causes PHP crash
You supplied a invalid query causing SQL to fail. They are not user defined queries, but admin defined queries as part of the admin setting up their site. We do not suppress SQL errors.


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.

  • bascherz
  • bascherz
  • OFFLINE
  • Posts: 228
  • Thanks: 29
  • Karma: 11
6 years 8 months ago #302778 by bascherz
Replied by bascherz on topic Errors in query field SQL causes PHP crash
Yes, I did write a bad query. And humans are going to do that. I've written bad queries for Auto Actions and those don't crash the CB code. I've also written my own modules that do queries and use try/catch to handle query errors. That works quite well.

This is user feedback. Just recommending an improvement.

Have a good day. :-)

Bruce S - Vienna, VA

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48560
  • Thanks: 8292
  • Karma: 1445
6 years 8 months ago #302779 by krileon
Replied by krileon on topic Errors in query field SQL causes PHP crash
I'm aware we can trycatch the query errors. I choose not to for all admin supplied configuration for easier debugging of configuration issues. All user supplied configuration will properly suppress/catch errors as needed. CB Auto Actions does not catch query errors either and any fatal query errors thrown will prevent subsequent code from executing.


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