Migration error list

d6_file migration bug

There is a bug in migrate_upgrade https://www.drupal.org/node/2826204 that incorrectly sets the migration id for files

So as a workaround we need to manually replace the 

1
2
3
4
5
6
<?
    $migration_plugin_configuration = $configuration + [
      'migration' => 'd6_file',
      'source' => ['fid'],
    ];
?>
with

1
2
3
4
5
6
<?
    $migration_plugin_configuration = $configuration + [
      'migration' => 'upgrade_d6_file',
      'source' => ['fid'],
    ];
?>

in core/modules/file/src/Plugin/migrate/process/d6/FieldFile.php

Field name errors

  1. Machine name errors, regarding capitals letters present on D6 😢

    1
2
3
      *fieldname* with invalid characters. Only lowercase alphanumeric characters and underscores are allowed, [error]
  and only lowercase letters and underscore are allowed as the first character
  (/home/eu/git-mbm/acvo_d8/docroot/core/modules/field/src/Entity/FieldStorageConfig.php:249)
    Fields:

     1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
    field_exam_app_SD_admin_notes_ad
field_exam_app_SD_admin_notes_co
field_exam_app_SD_decline_reason
field_exam_app_SD_decline_yes_no
field_exam_app_SD_first_name
field_exam_app_SD_instruct_sig
field_exam_app_SD_last_name
field_exam_app_SD_prior_name
field_exam_app_SD_prior_name_yes
field_exam_app_SD_prior_test_yea
field_exam_app_SD_prior_test_yes
field_exam_app_SD_res_comp_date
field_exam_app_SD_signature
    • Re-map fields with correct lower-case machine names.
    • For some reason I’m not able to map the ‘old’ broken machine names in the node yml file. Ask to Miles or Cameron maybe they can help.

  2. Node/User Reference field. Field:

    • field_backref_9ee7122ec40e290a7f
    1
2
3
4
5
6
7
8
9
      Migration failed with source plugin exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;field_backref_9ee7122ec40e290a7f_&#039; in          [error]
  &#039;where clause&#039;: SELECT 0 AS delta
  FROM 
  {content_type_member_information} t
  WHERE (field_backref_9ee7122ec40e290a7f_ IS NOT NULL) AND (nid = :db_condition_placeholder_0) AND (vid = :db_condition_placeholder_1); Array
  (
      [:db_condition_placeholder_0] =&gt; 1478
      [:db_condition_placeholder_1] =&gt; 1478
  )

    NOTE: This is probably related to the migration order? I think migrate is not finding the field because is a node reference to a node that is not yet imported.

Taxonomy Term errors

Errors

Errors like:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
  SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'langcode' cannot be null: UPDATE {taxonomy_term_data} SET tid=:db_update_placeholder_0,           [error]
  vid=:db_update_placeholder_1, uuid=:db_update_placeholder_2, langcode=:db_update_placeholder_3
  WHERE tid = :db_condition_placeholder_0; Array
  (
      [:db_update_placeholder_0] => 10902
      [:db_update_placeholder_1] => states
      [:db_update_placeholder_2] => fa12d47f-b86f-4f51-8811-3446c8b16c75
      [:db_update_placeholder_3] => 
      [:db_condition_placeholder_0] => 10902
  )
  in Drupal\Core\Database\Connection->handleQueryException() (line 683 of /home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Core/Database/Connection.php).
  [...]

Info

Above patch will be included in Drupal 8.5.

Node ids duplicated entries

Errors

Errors like:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
  Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6' for key 'node__vid':      [error]
  INSERT INTO {node} (nid, vid, type, uuid, langcode) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2,
  :db_insert_placeholder_3, :db_insert_placeholder_4); Array
  (
      [:db_insert_placeholder_0] => 6
      [:db_insert_placeholder_1] => 6
      [:db_insert_placeholder_2] => page
      [:db_insert_placeholder_3] => a194b5c6-e3fc-4dc1-9005-ec0ad576fe49
      [:db_insert_placeholder_4] => und
  )
  in Drupal\Core\Database\Connection->handleQueryException() (line 683 of /home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Core/Database/Connection.php).
  • Duplicated vid’s: 8, 7, 6

Info

No idea where this error comes from! Doesn’t seem to be crucial as those nodes are imported OK.

Revisions errors

Errors

Four errors like:

1
2
3
  Drupal\Core\Entity\EntityStorageException: Update existing 'node' entity revision while changing the revision ID is not supported. in                           [error]
  Drupal\Core\Entity\ContentEntityStorageBase->doPreSave() (line 303 of
  /home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Core/Entity/ContentEntityStorageBase.php).

Info

Revisions are not being used in D6 site, so I’m ignoring this one.

langcode errors

Errors

Tons of these:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
  Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'langcode' cannot be null: UPDATE      [error]
  {taxonomy_term_data} SET tid=:db_update_placeholder_0, vid=:db_update_placeholder_1, uuid=:db_update_placeholder_2, langcode=:db_update_placeholder_3
  WHERE tid = :db_condition_placeholder_0; Array
  (
      [:db_update_placeholder_0] => 306
      [:db_update_placeholder_1] => states
      [:db_update_placeholder_2] => 93320e2f-190c-4c90-97a0-97bbfb30e9b8
      [:db_update_placeholder_3] => 
      [:db_condition_placeholder_0] => 306
  )
  in Drupal\Core\Database\Connection->handleQueryException() (line 683 of /home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Core/Database/Connection.php).

Warning

These are related to:

  • acvo_search
  • The fact that the field_state is a free text field.

Plugins missing

Probably due to missing dependencies as these modules don’t have a D8 port nor a migration path.

Errors

1
2
3
4
5
6
7
  The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
  The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
  The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
  The "autocomplete_widgets_flddata" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)   [error]
  The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
  The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
  The "multiselect_select" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)             [error]

1
2
3
4
5
6
7
The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
The "nodereference_url" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)              [error]
The "autocomplete_widgets_flddata" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)   [error]
The "multiselect_select" plugin does not exist. (/home/eu/git-mbm/acvo_d8/docroot/core/lib/Drupal/Component/Plugin/Discovery/DiscoveryTrait.php:52)             [error]
Processed 441 items (435 created, 0 updated, 5 failed, 1 ignored) - done with 'upgrade_d6_field_instance_widget_settings'                                       [status]
upgrade_d6_field_instance_widget_settings Migration - 5 failed.

Modules

nodereference_url

No idea what to do with these :(

Fields using nodereference_url widget per Content Type

six_month_diplomate_1 six_month_resident_1
field_auto_email_ref field_auto_email_ref
field_auto_lastnamesd_ref field_member_id
field_auto_fnamesd_ref

Warning

This might be a roadblock for this CT migration!

UPDATE: My approach would be: Drop those widgets from those 5 fields. Manually recreate once we are ready in D8 with a better functionality, ie: Use some autocomplete widget that takes the user data from the loggedin user.

UPDATE 2: I’ve investigated this a bit deeper for the six_month_diplomate_1 and:

  • field_auto_email_ref (nodereference Field | “reference from URL” widget) is used to autopopulate the user (in this case Supervising Diplomate) email address when Creating new nodes. I will check if the field Value is migrated ok and if thats the case, for the New nodes in D8 we can use another approach.

  • field_auto_fnamesd_ref and field_auto_lastnamesd_ref (nodereference Field | “reference from URL” widget), are plain text fields, the Supervising Diplomate enter those manually, BUT once the node is saved the Widget working togheter with a View displays the ‘original’ Supervising Diplomate First Name and Last from its User Information.

Views:

screenshot

autocomplete_widgets

Its only used in Content Type ‘six_month_resident_1’ for the field_home and its functionality is wrong: When users starts typing in the field the module matches the input numbers with other users telephones and offers those to current user!! The horror.

Info

We are dropping this functionality.

UPDATE: Done. Widget changed to “plain text” in D6.

multiselect

Multiselect has a port to D8! So, I probably missed it on the module review, etc… 😬

UPDATE: Done. Module added an enabled.

Errors

1
upgrade_d6_menu_links Migration - 82 failed.

Fields

1
2
3
4
5
6
7
8
9
Migration failed with source plugin exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;t.field_sd_signature_value&#039; in &#039;field     [error]
list&#039;: SELECT t.field_sd_signature_value AS value, 0 AS delta
FROM 
{content_type_exam_application_sd} t
WHERE (field_sd_signature_value IS NOT NULL) AND (nid = :db_condition_placeholder_0) AND (vid = :db_condition_placeholder_1); Array
(
    [:db_condition_placeholder_0] =&gt; 4764
    [:db_condition_placeholder_1] =&gt; 4764
)

Fields Formatter

Errors

1
2
Processed 2643 items (2637 created, 0 updated, 6 failed, 0 ignored) - done with 'upgrade_d6_field_formatter_settings'                                           [status]
upgrade_d6_field_formatter_settings Migration - 6 failed.                                                                                                       [error]

Files

Errors

1
2
Missing file with ID 21. ImageItem.php:327 [warning]
Missing file with ID 23. ImageItem.php:327 [warning]

Table not found errors

Errors

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
Migration failed with source plugin exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;t.field_sd_signature_value&#039; in &#039;field     [error]
list&#039;: SELECT t.field_sd_signature_value AS value, 0 AS delta
FROM 
{content_type_exam_application_sd} t
WHERE (field_sd_signature_value IS NOT NULL) AND (nid = :db_condition_placeholder_0) AND (vid = :db_condition_placeholder_1); Array
(
    [:db_condition_placeholder_0] =&gt; 4764
    [:db_condition_placeholder_1] =&gt; 4764
)

Migration failed with source plugin exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;field_backref_9ee7122ec40e290a7f_&#039; in          [error]
&#039;where clause&#039;: SELECT 0 AS delta
FROM 
{content_type_member_information} t
WHERE (field_backref_9ee7122ec40e290a7f_ IS NOT NULL) AND (nid = :db_condition_placeholder_0) AND (vid = :db_condition_placeholder_1); Array
(
    [:db_condition_placeholder_0] =&gt; 1478
    [:db_condition_placeholder_1] =&gt; 1478
)