daedalus

Postgres does not specify the field that caused the error in this case and it looks like our guess attempt fails if more than one field is present. Sample DB...

Interesting. May be worth appending the machine id to prevent this?

### To Reproduce - Create collection A with versioning enabled - Create collection B with optional fields `date_updated` - Add a field in A named `relation` that is a relational...

Interesting. Handling this condition during `POST schema/diff` should ensure it’s correctly reflected during the apply step

> Does this imply that using snapshots between environments with new tables isn't possible unless you downgrade or click on each table in the admin UI first? New tables can...

Interesting. Looks like this might be happening because [`ip: null` is set in the accountability](https://github.com/directus/directus/blob/39ece1521a5ca026134f01cc6699fdf131b5938e/api/src/services/comments.ts#L86), which [auto denies access by default](https://github.com/directus/directus/blob/main/api/src/permissions/utils/filter-policies-by-ip.ts#L13) for security reasons.

> Is it possible to check a user's access to an item without checking the IP rules? Currently we do not support an ip skip check for access. > The...

I can confirm that the default charset value for `DB_CHARSET` is correctly set as specified in our documentation. The [mysql2 driver enforces stricter charset comparison](https://directus.io/docs/releases/breaking-changes/version-11#replaced-mysql-with-mysql2) rules, meaning the `DB_CHARSET` must...

This is expected behavior. When you remove the read permission to the field it results in the minimum access `Item Rule` to be applied which restricts access to your user...

Disregard the above, this is indeed a bug. We should be showing both users as we currently have the Item Rule set to all. The minimum access permissions should not...