Multiple source IDs error I'm getting error 

Drupal\Core\Database\DatabaseExceptionWrapper&lt;/em&gt;: SQLSTATE[42S22]: Column not found: 1054 Unknown column &amp;#039;map.sourceid2&amp;#039; in &amp;#039;field list&amp;#039;: SELECT map.sourceid1 AS sourceid1, map.sourceid2 AS sourceid2, map.destid1 AS destid1


when trying to use two value ids in migrate yml file:

id: recipe_daily
label: Recipes
migration_group: recipe
status: true

source:
  plugin: url
  data_fetcher_plugin: http
  data_parser_plugin: xml
  urls:
    - http://mysource.com/data
  item_selector: /recipes/recipe

  fields:
    -
      name: text
      label: 'Text'
      selector: text
    -
      name: title
      label: 'Title'
      selector: title
    -
      name: recipe_day
      label: 'Day'
      selector: '@day'
    -
      name: recipe_id
      label: 'Recipe id'
      selector: 'detail/@id'

  ids:
    title:
      type: string
    recipe_id:
      type: string

destination:
  plugin: entity:node

process:

  type:
    plugin: default_value
    default_value: recipe_daily

  title: title
  text: text

dependencies:
  enforced:
    module:
      - recipe


Since it's called ids I assume it takes multiple values but cannot find any examples anywhere. Any ideas much appreciated
I think you used to have 1 ID before and that you added the second ID after you ran the migrations?

If your migrations aren't in prod, you can simply delete these tables and try again:


migrate_map_recipe_daily
migrate_message_recipe_daily


I think it should work.

If your migration is in prod, you might have to:


Create a sourceid2 column matching with your ID type
Update the table keys to consider sourceid1 and sourceid2 as composite keys


I have tried the first one many times.