Field group error

Hello,

In a new Joomla! 3.8.11 installation, only with Community Builder package and CB Field Groups 1.0 installed. I have created two text fields cb_team and cb_score. A new group field cb_group only containing previous fields, allways return white page with "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 try to save it.

In front-end group is published and it looks work, but it crash when try to save with "1054 Unknown column 'cb_group' in 'field list' "

Some idea?

Thank you

José Martinez

Update your database version as unfortunately we've no means through Joomla API to test MariaDB version. You need MariaDB 10.2 or greater. If you're unable to update your database you will not be able to use the CB Field Groups fieldtype as it uses a json database column type to optimize the storage and since we can't test MariaDB version through Joomlas database API we're not able to fallback to text. This is not an issue for anyone using MySQL.

As an additional note Joomla does not officially support MariaDB. Reasons as for why can be found below. This means we also do not support MariaDB and will not be performing any tests with MariaDB. Use it at ones own risk.

github.com/joomla/joomla-cms/issues/14141

Thank you. Unfortunately my MariaDB version is 10.1.31-MariaDB-cll-lve. I have to wait for the hosting to improve

Through Joomla System Information, I get Database Version 5.5.5-10.2.16-MariaDB, so that should work based on your comment, even though the MySQL 5.7.8+ error is raised? I don't know where the 5.5.5 comes from. 10.2.16 is also reported in my server control panel.

MariaDB is not officially supported by Joomla. This means it is not supported by CB either. We do not test for MariaDB and Joomla API provides no means of testing for MariaDB. It is only testing for MySQL version (using Joomla database API). It may or may not work on MariaDB, but for access to the JSON storage type and functions you'll need MariaDB 10.2+. That notice will likely display regardless of MariaDB version. Note it also states to update CB as it requires latest CB nightly.