[SOLVED] SQL error in Field Groups

2 weeks 4 days ago - 1 day 14 hours ago #315033 by billraydrums
When I attempt to create anything regarding Field Groups, I get the message:
"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json' at line 2".

When I check to see if the changes "took" after the seemingly failed update, they appear to function. However, when I fill in the fields with data they do not get saved on the profile page.
2 weeks 1 day ago #315046 by krileon
MariaDB is not supported. We're not able to properly detect SQL support for JSON columns in MariaDB either. MySQL 5.7.8+ is recommended to properly fully support JSON columns otherwise it will fallback to using a TEXT column. I've no idea how this behavior will work on MariaDB since again it's not supported.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
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 EST to 4:00 PM EST. 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.
2 days 14 hours ago #315216 by billraydrums
I changed hosts to a non-MariaDB MySQL build and the problem was solved. Thanks!
The following user(s) said Thank You: krileon
Moderators: beatnantkrileon
Time to create page: 0.400 seconds
Facebook Twitter Google LinkedIn