TransWikia.com

Magento 2: After migration, I get "No such entity with cartId" on old orders

Magento Asked on November 17, 2021

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

One Answer

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

Answered by Jigs Parmar on November 17, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP