Is this on a linux localhost? Have you checked the link above for possible commands to fix this? Everything I could find points at a environment problem. Some sort of mix up with MySQL versions. There isn't anything I can do about that; you'll need to fix your environment. If you're using a web host try contacting them to see if they can re-install MySQL and PHP. I've tested your exact versions in a clean docker image and it works fine.
You can also try unpublishing all 3rd party extensions and retry to see if issue persists.
I guess as a workaround you can create the field then change its JSON type in _comprofiler to TEXT type, but if you re-save the field it will force the field type back to JSON. This would just be a bandaid for a bigger issue with your environment.
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.
Thanks for the analysis.
This is not a local machine, I am working directly on a Strato host.
The workaround works correctly for me, so for now I can go forward.
Suggest contacting your host as they may have a problem with their server environment. Prepared statements against JSON columns on your MySQL and PHP version should not be erroring like that.
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.
krileon
