Commerce Product Variation migration: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''

Created on 12 July 2024, 4 months ago

When trying to run migration on Commerce Product Variations I get this error

Setup migration as per docs and run
drush migrate:duplicate-file-detection my_migration_name

I am not sure exactly what the logic should be here but I am guessing that because product variations do not have revisions we can't load them with

$entitites = $this->entityTypeManager->getStorage($this->configuration['entity_type'])->loadMultipleRevisions($results);

line 294 in /src/Plugin/migrate/source/MediaEntityGenerator.php

However loading with just loadMultiple() works

To test this locally I have added a check for entity type and use the different methods based on that and my migration works.

Again not sure what the best solution is here but if someone could point me in the right direction I would be happy to try and help create a patch.

🐛 Bug report

Status

Active

Version

2.0

Component

Code

Created by

🇬🇧United Kingdom chrisscrumping

Live updates comments and jobs are added and updated live.

Merge Requests

Issue created by @chrisscrumping
Merge request !413461018: Check if entity is revisionable before loading entities → (Open) created by chrisscrumping
Comment 4 months ago →
🇬🇧United Kingdom chrisscrumping
Found out I can use the isRevisionable method so have created a PR.
Status changed to Fixed 5 days ago7:24pm 16 November 2024
Comment 5 days ago →
🇺🇦Ukraine HitchShock Ukraine
@chrisscrumping Thanks for the patch.
Even though the bug was fixed in the context of 📌 Automated Drupal 11 compatibility fixes for migrate_file_to_media Needs review I would prefer to give you credit for your activities

Production build 0.71.5 2024