Adding collections with fields doesn't work directus dashbaord

Help
,
1

Version: directus 11.13.2

Goal:
Trying to add a collection via directus dashboard however the fields do not appear and confirming in directus_fields the fields for the existing table does not exist.

Tried:
Checking the fields to see if eg. primary key constraint not set or incorrect. The primary key is fine it’s an int type with primary key constraint.
Deleting the table in directus_collections, restarting directus instance and then re clicking on the collection.

Still the collection is added into directus collections and the fields remain empty.

image
image1468×933 45.9 KB

There's not enough information here to reproduce the issue or even offer debugging steps. What database are you using? How is this Directus instance hosted?

 –

Hi sorry about that. I am running it on mssql. Microsoft SQL Azure (RTM) - 12.0.2000.8 It is hosted in azure container apps as docker container.

 –

example DDL: CREATE TABLE tbl_priceagetypes ( priceagetype_id int IDENTITY(1,1) NOT NULL, priceagetype_name nvarchar(50), CONSTRAINT PK_tbl_priceagetypes PRIMARY KEY (priceagetype_id) );

 –

when running directus locally using docker compose i can see [11:21:42.357] WARN: Collection "tbl_priceagetypes" doesn't have a primary key column and will be ignored which makes not sense as it does have a primary key.

 –