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.
Comments
0 comments
Please sign in to leave a comment.