migration - Magento on Order Page: "This customer email already exists" -

migration - Magento on Order Page: "This customer email already exists" -

i imported orders magento using migration tools. when homecoming client tries place order, magento prevents them doing , says "this client email exists." despite fact logged magento.

did import/migrate magento database incorrectly? or else causing this?

any suggestions much appreciated.

the exception generated client resource model's _beforesave function, checks if client given email address exists. check's code:

$adapter = $this->_getwriteadapter(); $bind = array('email' => $customer->getemail()); $select = $adapter->select() ->from($this->getentitytable(), array($this->getentityidfield())) ->where('email = :email'); if ($customer->getsharingconfig()->iswebsitescope()) { $bind['website_id'] = (int)$customer->getwebsiteid(); $select->where('website_id = :website_id'); } if ($customer->getid()) { $bind['entity_id'] = (int)$customer->getid(); $select->where('entity_id != :entity_id'); } $result = $adapter->fetchone($select, $bind); if ($result) { throw mage::exception( 'mage_customer', mage::helper('customer')->__('this client email exists'), mage_customer_model_customer::exception_email_exists ); }

you customers logged in, means status $customer->getid() true. since exception, suggest, there duplicate client accounts same emails.

can import tool has created duplicates in client data? reason can think of. check database query:

select email, count(*) customer_entity grouping email having count(*) > 1

magento migration magento-1.6