My English is not perfect sorry. I am using Magento 2.3.1 and I saw this issue. Admin > Reports > Customers > Login as Customer Logs

Login as Customer Logs No such entity with customerId = 1

I added a picture. Have any idea? Thank you so much. https://prnt.sc/nsza9d

enter image description here


I've seen this error before. You have some orphan data.

In our case we had to delete addresses that belonged to customers that no longer existed.

DELETE FROM `customer_address_entity` WHERE `parent_id` NOT IN (SELECT `entity_id` FROM `customer_entity`)

Yours relates to log

So try this

DELETE FROM `customer_log` WHERE `customer_id` NOT IN (SELECT `entity_id` FROM `customer_entity`)
  • Thank you for your answer. My website not published yet. I have 2 customers for trials. And I deleted now. But still the same.
    – EK.
    May 26 '19 at 18:57
  • Hi again, I found this solution. magefan.com/blog/no-such-entity-fix-for-magento-2 And I saw this issue related to mageplaza login as customer extension. I did disable. Now no issue. Thank you so much.
    – EK.
    May 26 '19 at 20:01
  • @EK. this magefan.com/blog/no-such-entity-fix-for-magento-2 looks like is not working with Magento 2.3 (magento.stackexchange.com/questions/291424/…), it's making another exception, how did you get it work?
    – SylwekFr
    Oct 2 '19 at 7:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.