I have Migrated website Magento 18.104.22.168 to Magento 2.2.4 successfully by Using Magento Data Migration Tool. My Old Magento Website was multi-store/website. Everything is working fine but when I am going to create an account then I am getting below errors
No such entity test with email = firstname.lastname@example.org, websiteId = 1
I have tried to some fixes by running below command but this is already updated
SET FOREIGN_KEY_CHECKS=0; UPDATE store SET store_id = 0 WHERE code='admin'; UPDATE store_group SET group_id = 0 WHERE name='Default'; UPDATE store_website SET website_id = 0 WHERE code='admin'; UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN'; SET FOREIGN_KEY_CHECKS=1;
While I have tried to create account programatically,its creating successfully but email id is not inserting in customer_entity table while it inserting in customer_entity_varchar table.
After migrating data ,website id and store id are same for both Magento and Magento2.I am also able to create product as well as place order is also working.
Is there is any option to check which entity id is missing when save customer?
I have a lot of research but nothing found to resolve this issue. Please help me.