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.
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.
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.
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.