Migration doesn't work on relational fields

[muratgozel]

Describe the Bug

I'm running the migration script as described in the docs to apply the schema in localhost to server. All models with all of their fields have applied successfully except relational fields. They look like as the following:

I tried restarting the server and even tried on fresh server install. Both of parties is using the same version of directus.

To Reproduce

• Two fresh directus apps, one with some models in it.
• Try to migrate one to the other based on the migration script described in the docs.
• You will see that relational fields doesn't work in the target app.

Directus Version

v10.13

Hosting Strategy

Self-Hosted (Docker Image)

Database

postgres:16.2

[bernatvadell]

Normally I use this command to create the snapshot:

npx directus schema snapshot -y --format yaml snapshot.yaml

Then in the target directus I do the command:

npx directus schema apply snapshot.yaml

In this last command, the differences appear, and if everything is correct, I accept them.

[muratgozel]

hey @bernatvadell Just tried this, translations field is broken this time.

and here is the log of the apply command (i emptied the target before applying):

? The following changes will be applied:

Collections:
  - Create business
  - Create component_downloads
  - Create component_downloads_files
  - Create component_dual_text
  - Create component_dual_text_translations
  - Create component_event
  - Create component_event_translations
  - Create component_news_article
  - Create component_news_article_translations
  - Create component_photo_gallery
  - Create component_photo_gallery_files
  - Create component_qa
  - Create component_qa_translations
  - Create component_single_text
  - Create component_single_text_translations
  - Create component_text_image
  - Create component_text_image_translations
  - Create component_youtube_video
  - Create components
  - Create custom_texts
  - Create custom_texts_translations
  - Create deploy_settings
  - Create geo_regions
  - Create languages
  - Create pages
  - Create pages_components
  - Create pages_translations
  - Create website
  - Create website_settings

Fields:
  - Create business.id
  - Create business.legal_name
  - Create business.address
  - Create business.coordinates
  - Create business.phone_num
  - Create business.email
  - Create business.social_media_profiles
  - Create business.brand_colors
  - Create component_downloads.id
  - Create component_downloads.status
  - Create component_downloads.files
  - Create component_downloads_files.id
  - Create component_downloads_files.component_downloads_id
  - Create component_downloads_files.directus_files_id
  - Create component_downloads_files.sort
  - Create component_dual_text.id
  - Create component_dual_text.status
  - Create component_dual_text.translations
  - Create component_dual_text_translations.id
  - Create component_dual_text_translations.component_dual_text_id
  - Create component_dual_text_translations.languages_code
  - Create component_dual_text_translations.left_text_html
  - Create component_dual_text_translations.right_text_html
  - Create component_event.id
  - Create component_event.status
  - Create component_event.start_date
  - Create component_event.end_date
  - Create component_event.translations
  - Create component_event_translations.id
  - Create component_event_translations.component_event_id
  - Create component_event_translations.languages_code
  - Create component_event_translations.text_html
  - Create component_news_article.id
  - Create component_news_article.status
  - Create component_news_article.date
  - Create component_news_article.translations
  - Create component_news_article_translations.id
  - Create component_news_article_translations.component_news_article_id
  - Create component_news_article_translations.languages_code
  - Create component_news_article_translations.text_html
  - Create component_photo_gallery.id
  - Create component_photo_gallery.status
  - Create component_photo_gallery.photos
  - Create component_photo_gallery_files.id
  - Create component_photo_gallery_files.component_photo_gallery_id
  - Create component_photo_gallery_files.directus_files_id
  - Create component_photo_gallery_files.sort
  - Create component_qa.id
  - Create component_qa.status
  - Create component_qa.translations
  - Create component_qa_translations.id
  - Create component_qa_translations.component_qa_id
  - Create component_qa_translations.languages_code
  - Create component_qa_translations.items
  - Create component_single_text.id
  - Create component_single_text.status
  - Create component_single_text.translations
  - Create component_single_text_translations.id
  - Create component_single_text_translations.component_single_text_id
  - Create component_single_text_translations.languages_code
  - Create component_single_text_translations.text_html
  - Create component_text_image.id
  - Create component_text_image.status
  - Create component_text_image.translations
  - Create component_text_image.image
  - Create component_text_image_translations.id
  - Create component_text_image_translations.component_text_image_id
  - Create component_text_image_translations.languages_code
  - Create component_text_image_translations.text_html
  - Create component_youtube_video.id
  - Create component_youtube_video.status
  - Create component_youtube_video.url
  - Create component_youtube_video.background_video
  - Create custom_texts.id
  - Create custom_texts.key
  - Create custom_texts.translations
  - Create custom_texts_translations.id
  - Create custom_texts_translations.custom_texts_id
  - Create custom_texts_translations.languages_code
  - Create custom_texts_translations.text
  - Create deploy_settings.id
  - Create deploy_settings.directus_uploads_public_folder
  - Create deploy_settings.media_manifest_dir
  - Create deploy_settings.source_public_dir
  - Create deploy_settings.collections
  - Create deploy_settings.source_svelte_routes_filepath
  - Create deploy_settings.source_robotstxt_config_filepath
  - Create deploy_settings.custom_resolvers
  - Create geo_regions.id
  - Create geo_regions.status
  - Create geo_regions.type
  - Create geo_regions.code
  - Create geo_regions.english_name
  - Create geo_regions.native_name
  - Create geo_regions.parent
  - Create languages.code
  - Create languages.status
  - Create languages.sort
  - Create languages.name
  - Create languages.direction
  - Create languages.is_default
  - Create pages.id
  - Create pages.status
  - Create pages.sort
  - Create pages.user_created
  - Create pages.date_created
  - Create pages.user_updated
  - Create pages.date_updated
  - Create pages.navigation_parent
  - Create pages.translations
  - Create pages.head_image
  - Create pages.components
  - Create pages.seo_robots_directive
  - Create pages.seo_canonical_url
  - Create pages.svelte_component
  - Create pages.identifiers
  - Create pages_components.id
  - Create pages_components.pages_id
  - Create pages_components.item
  - Create pages_components.collection
  - Create pages_components.components_sort
  - Create pages_translations.id
  - Create pages_translations.pages_id
  - Create pages_translations.languages_code
  - Create pages_translations.title
  - Create pages_translations.slug
  - Create website_settings.id
  - Create website_settings.maintenance_mode

Relations:
  - Create component_downloads_files.directus_files_id → directus_files
  - Create component_downloads_files.component_downloads_id → component_downloads
  - Create component_dual_text_translations.languages_code → languages
  - Create component_dual_text_translations.component_dual_text_id → component_dual_text
  - Create component_event_translations.languages_code → languages
  - Create component_event_translations.component_event_id → component_event
  - Create component_news_article_translations.languages_code → languages
  - Create component_news_article_translations.component_news_article_id → component_news_article
  - Create component_photo_gallery_files.directus_files_id → directus_files
  - Create component_photo_gallery_files.component_photo_gallery_id → component_photo_gallery
  - Create component_qa_translations.languages_code → languages
  - Create component_qa_translations.component_qa_id → component_qa
  - Create component_single_text_translations.languages_code → languages
  - Create component_single_text_translations.component_single_text_id → component_single_text
  - Create component_text_image.image → directus_files
  - Create component_text_image_translations.languages_code → languages
  - Create component_text_image_translations.component_text_image_id → component_text_image
  - Create custom_texts_translations.languages_code → languages
  - Create custom_texts_translations.custom_texts_id → custom_texts
  - Create geo_regions.parent → geo_regions
  - Create pages.user_created → directus_users
  - Create pages.user_updated → directus_users
  - Create pages.navigation_parent → pages
  - Create pages.head_image → directus_files
  - Create pages_components.item
  - Create pages_components.pages_id → pages
  - Create pages_translations.languages_code → languages
  - Create pages_translations.pages_id → pages

Would you like to continue? Yes
[17:17:01.880] INFO: Snapshot applied successfully

The field looks fine in the Data Model, maybe something wrong with the interface? Nothing wrong in visible though.

[muratgozel]

I can confirm that the reason of broken translations interface is because of no records in the languages table. So it's not relevant the migration. Still, when migration run within the sdk, I don't get the result I showed above. FYI.

[linear]

EDU-367 Migration doesn't work on relational fields