Changing user field from M2O to User Created

[benhaynes]

From directus created by maettyhawk : directus/directus#2179

There's some weird behaviour when I change a table's field "user" from M2O (referencing Directus user table) to User Created. As seen in screenshot 3 the change causes an error when trying to add a new entry. Also the table settings show a M2O relation for the "user" field, which is not displayed if one sets the field type to User Created or Modified from the very beginning.

Version Info

• Directus version: 6.4.9
• PHP version: 7.2
• MySQL version: 5.7.21
• Web server: Apache
• OS name and version: Ubuntu

Expected Behavior

Changing a "user" field from M2O to User Modified/Created causes no error when trying to add a new entry to that table.

Actual Behavior

Changing a "user" field from M2O to User Modified/Created causes an error when trying to add a new entry to that table.

Steps to Reproduce

1. Add a new table
2. Add a new field "user" (M2O -> referencing directus_user -> id)
3. Try to add a new entry (should work)
4. Change the field type of "user" to User Modified or Created
5. Try to add a new entry (error appears)

Schema Dump, Logs, or Screenshots