Crashing when product type table isn't found.

Created on 5 January 2022, over 2 years ago

Updated 31 December 2023, 6 months ago

Problem/Motivation

When trying to migrate a Drupal Commerce installation on Drupal 7.84 to Drupal 9.3.2, I got this error:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'temp-xxx.commerce_product_type' doesn't exist: SELECT "pt"."type" AS "type" FROM "commerce_product_type" "pt"; Array ( ) in _commerce_migrate_commerce_get_product_node_types() (line 268 of /var/www/html/xxx/web/modules/contrib/commerce_migrate/modules/commerce/commerce_migrate_commerce.module).

This is after creating a clean version of Drupal commerce with this command:

composer create-project drupalcommerce/project-base mystore --stability dev

And then installing

composer require drupal/commerce_migrate

Thanks for any suggestions or help on how to push this migration through.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report

Status

Active

Version

3.2

Component

Code

Created by

🇺🇸United States bogdog400

Live updates comments and jobs are added and updated live.

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 10 months ago →
🇫🇷France jeanpierre
I have the same problem. Did you find any solution ? Thanks
Comment 10 months ago →
🇺🇸United States bogdog400
I didn't find a solution. I ended up just doing some things by hand.
Comment 10 months ago →
🇺🇸United States bogdog400
I found this elsewhere. Apparently you need to have the "commerce store" module enabled too. Even if the Drupal 7 version didn't use Commerce Store.

See more here:

https://www.drupal.org/project/commerce_migrate/issues/2839224 →
Comment 6 months ago →
🇺🇸United States bogdog400
BTW, I was doing this again and I figured out that my original Drupal 7 site was running Ubercart, not Drupal Commerce. Yet I had the Commerce Migrate Commerce enabled. When I turned off Commerce Migrate Commerce and enabled Commerce Migrate Ubercart, it stopped looking for that table that wasn't there.

contrib.social Blog FAQ Discussions

Production build 0.69.0 2024