magento / magento/data-migration-tool
Unable to migrate magento1.9.3.2 into magento 2.4.3 #35251
- Dominant language
- PHP
- Stars
- 339
- Forks
- 195
- PR merge metrics
- No merged PRs in 30d
Description
Magento 1.9.3.2
Magento 2.4.3
Data migation tool installed on magento 2.3.4
All configuration are good, when i am run migration:data command it will working and around 53% it stucked and say that
In Mysql.php line 599:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sales_flat_qoute' doesn't exist, query was: SELECT DISTINCT
child.quote_id FROM justselling_projectrequest AS child
LEFT JOIN sales_flat_qoute AS parent ON child.quote_id = parent.entity_id WHERE (child.quote_id IS NOT NULL) AND (parent.e
ntity_id IS NULL)
In Mysql.php line 91:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sales_flat_qoute' doesn't exist
Result:
unable to migrate data
Excepted
data migrated succssfully
Contributor guide
Research direction
Start with the migration:data command and inspect Mysql.php at lines 599 and 91, using the reported query against sales_flat_qoute and justselling_projectrequest as the reproduction. Trace why the migration expects sales_flat_qoute, then verify that the Magento 1.9.3.2 to Magento 2.4.3 migration completes beyond 53% without the missing-table error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100