0

I migrated from Magento 1 to Magento 2.3

My site has multiple websites and stores.

But now when I go to old orders in the admin panel and want to add a note to an order I get the error:

No such entity with cartId = XXXX

This is regarding whether I chose the option Notify Customer by Email or not. But if I click on send email, the email is not sent and gives me the same error anyways.

I don't have anything on my logs so I am not sure what is happening.

Note: If I do the same process but for newer orders (orders that were made after the migration), there is no error at all. All running fine.

Any ideas? Thank you in advance

enter image description here

4
  • check the store table and see which store_id for admin store – Jigs Parmar Jul 22 '20 at 4:19
  • Hi @JigsParmar , store_id is 0 for admin store. Does this have anything to do with that? Thanks – Paloma Martinez Jul 22 '20 at 4:21
  • which magento2 version are you using? – Jigs Parmar Jul 22 '20 at 4:29
  • @JigsParmar Magento ver. 2.3.5-p1 – Paloma Martinez Jul 22 '20 at 4:30
0

take db backup and run the following sql queries

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;

DONT forgot to take DB backup

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.