Data-migration-tool: Table 'customer_entity' doesn't exist

Created on 24 May 2017  路  7Comments  路  Source: magento/data-migration-tool

Hi,

I'm getting the following errors when I migrate and the destination database has a prefix

[Zend_Db_Statement_Exception]                                                                                                           
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbtest.customer_entity' doesn't exist, query was: DESCRIBE `customer_entity`  
  [PDOException]                                                                                   
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbtest.customer_entity' doesn't exist 

It looks like it's ignoring the prefix.
Without prefix the migration is working with no problem.

acknowledged bug

Most helpful comment

All 7 comments

Hi @Croxarens

Try adding
$destinationDocName = $this->destination->addDocumentPrefix($destinationDocName);
into the beginning of \Migration\Step\Customer\Helper::getFieldsWithDefaultValues() Here

internal ticket to fix MAGETWO-69465

@victor-v-rad I'll try as soon as I'll complete the delta migration (see issue #307)

Had the same error when migrating to a fresh install with a prefix. Can confirm that adding $destinationDocName = $this->destination->addDocumentPrefix($destinationDocName); did the trick and fixed the issue.

confirming just for completeness that the commit fixes the issue

Fixed

Was this page helpful?
0 / 5 - 0 ratings