Unable to create configure flow manager fields

[jeffersonsolorzano]

When i try to add flow manager for the first time, directus sytem says:

 "type": "Error",
directus_container  |       "message": "alter table `directus_settings` add `flow_manager_categories` json null default '[]' - ER_BLOB_CANT_HAVE_DEFAULT: BLOB, TEXT, GEOMETRY or JSON column 'flow_manager_categories' can't have a default value",
directus_container  |       "stack":
directus_container  |           Error: ER_BLOB_CANT_HAVE_DEFAULT: BLOB, TEXT, GEOMETRY or JSON column 'flow_manager_categories' can't have a default value```

[baguse]

Why don't you use this Configure button to do that?

[jeffersonsolorzano]

@baguse I tried doing that, when i clicked, it showed me the error above

[baguse]

What's version of the directus do you use? @jeffersonsolorzano

[jeffersonsolorzano]

Tried 10.8.3 and 10.9.0

[baguse]

Tried 10.8.3 and 10.9.0

Ok thanks, I think the problem is coming from the mysql. I will try it

[baguse]

Hi @jeffersonsolorzano, could you tell me what version of your MySQL?

[jeffersonsolorzano]

Google cloud says mySQL 8.0

[baguse]

Thanks @jeffersonsolorzano I have already reproduced your issue. I will fix it soon

[sideshot]

Hi I'm using mysql 8 and just got the same error.

[INTERNAL_SERVER_ERROR] { "code": "ER_BLOB_CANT_HAVE_DEFAULT", "errno": 1101, "sqlMessage": "BLOB, TEXT, GEOMETRY or JSON column 'flow_manager_categories' can't have a default value", "sqlState": "42000", "index": 0, "sql": "alter table directus_settings add flow_manager_categories json null default '[]'" }

[baguse]

Hi I'm using mysql 8 and just got the same error.

[INTERNAL_SERVER_ERROR] { "code": "ER_BLOB_CANT_HAVE_DEFAULT", "errno": 1101, "sqlMessage": "BLOB, TEXT, GEOMETRY or JSON column 'flow_manager_categories' can't have a default value", "sqlState": "42000", "index": 0, "sql": "alter table directus_settings add flow_manager_categories json null default '[]'" }

Yes, I found the issue. I will release it in the next release.

[baguse]

Hello the issue closed on v.1.4.1 Release @jeffersonsolorzano @sideshot