Cannot migrate book nodes d7->D9

Created on 8 July 2023, 12 months ago

Problem/Motivation

In migrating from D7 to D9.5.9 I have several node types, including book nodes In migrating the node types, the D9 field "field_file" was replaced with "field_files" on several node types, including book. When I use Drush to import d7_node_complete:, all goes well, except when I try to import book nodes. Then I get this error:

 Migration failed with source plugin exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dcappeals.field_revision_field_file' doesn't exist: SELECT "t".*
FROM
"field_revision_field_file" "t"
WHERE ("entity_type" = :db_condition_placeholder_0) AND ("entity_id" = :db_condition_placeholder_1) AND ("deleted" = :db_condition_placeholder_2) AND ("revision_id" = :db_condition_placeholder_3)
ORDER BY "delta" ASC; Array
(
    [:db_condition_placeholder_0] => node
    [:db_condition_placeholder_1] => 44
    [:db_condition_placeholder_2] => 0
    [:db_condition_placeholder_3] => 624
)
 in /home/dcappeals/public_html/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php line 53 

I cannot find anything in the migration config.yml files that handles the file field differently for book nods than for any of the others.

Steps to reproduce

1. Clean install D9.
2. Import all necessary settings, node types, etc.
3. Import nodes with Drush.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

πŸ’¬ Support request
Status

Active

Version

6.0

Component

Plugins

Created by

πŸ‡ΊπŸ‡ΈUnited States rsbecker

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @rsbecker
  • πŸ‡ΊπŸ‡ΈUnited States rsbecker

    I found the problem. There were some artifacts in the D7 site's conig table that didn't get cleaned out after an earlier migration from D6. Once I removed those, the book migration worked properly.

Production build 0.69.0 2024