JDisc Connector Sync Profiles cannot be displayed or saved

Problem:

JDisc Connector is running in an i-doit installation with MySQL > 8.0.13. After installing the add-on, no profile is displayed in the Sync Profile menu and a red error message appears:

Solution:

Log in to the database via a MySQL client with:

mysql -u root -p

Now select the affected database.

USE idoit_data;

If the error occurs for multiple databases, this step must be performed for all affected databases. This may be the case if there are multiple clients.

Now execute this SQL statement:

ALTER TABLE `isys_jdisc_profile`
ADD `isys_jdisc_profile__column_settings` JSON NULL DEFAULT ('{"jdisc-os":1,"object-title-transform":1,"fqdn-addition":1,"port-filter":1,"location":1}');

The example profile is then visible and profiles can be saved.