Magento 2 After Migration innodb_buffer_pool_size ... - Page 2

Aveeva · ‎07-16-2020

@Nishu Jindal Shall i enable all store form Magento 1 then shall i migrate? Is it right practice?

Nishu Jindal · ‎07-16-2020

No, we need to change the group ids of stores that are present with us. So that it will not through us No such entity error in reindexing.

Currently what you can do is if you don't need these stores, then take the backup of store table and delete entries that don't have matching group_id in store_group table and check whether it helps us to resolve the issue or not.

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

Aveeva · ‎07-16-2020

@Nishu Jindal After deleting id from store table,

store group table: https://snipboard.io/XZISA7.jpg

store table: https://snipboard.io/O8fQ5Y.jpg

then run upgrade command getting following error,

[root@centos-4cpu-8gb-uk-lon1 giriusa]# php bin/magento setup:upgrade           
The store that was requested wasn't found. Verify the store and try again.
[root@centos-4cpu-8gb-uk-lon1 giriusa]#

How to solve this error?

Nishu Jindal · ‎07-16-2020

Hi @Aveeva ,

Store_id 8 is also having group id as 8 please change that id to some other Id which exists (example group_id : 9).

Hope this helps you!

problem Solved! Click Kudos & Accept as Solution!

Aveeva · ‎07-16-2020

@Nishu Jindal Yes, now i updated.

store group table: https://snipboard.io/9fValB.jpg

store table: https://snipboard.io/0HwaWO.jpg

still, upgrade issue:

https://snipboard.io/Dg2bVs.jpg

Aveeva · ‎07-16-2020

@Nishu Jindal Anything else i missed out?

Nishu Jindal · ‎07-16-2020

Hi @Aveeva,

Can you please run below commands on your database

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;