Pb with product save

Hi
I just install Data Migration Pro and make a migration from 1.8 to 2.3
Every thing seem to run ok (all green) and I can see all data in 2.3
Problem it seem that products are not activate or linked to websie (that I can check why) but the wired pb is on any save in product I got
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’71-93′ for key ‘PRIMARY’, query was: INSERT INTO `temp_catalog_category_tree_index_4abdaa58` (`parent_id`,`child_id`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?),
But this table doesn(t exist
Any idea?
 
Thanks

16 answers

Profile photo of Mall Staff 184060.00 $tone March 21, 2019
Public

Hi there,

temp_catalog_category_tree_index_4abdaa58

That is a to temporary  table only. 

Any idea?

Lets try reindex the data by run below CLI command:
php -f bin/magento indexer:reindex
Once done, re-check the issues you mentioned. And tell em know how it goes.
Regards,
Mall.

#1
Profile photo of ubdev Staff 98030.00 $tone March 22, 2019
Public

Hi there, 
You can share your site info here in this thread. Please make sure:

  • You mark this ticket private (by navigating to the top of this ticket, right below the ticket subject, and switching to the ‘private’ ticket). Or,
  • Simply post a private reply (you will see the ticket option ‘Public’ and ‘Private’ at the bottom of the text editor).

Then only you and our technical team can access that private reply. 
Regards,
Ubertheme team

#6
Profile photo of Mall Staff 184060.00 $tone March 22, 2019
Public

Hi there,

I have checked your instance and noticed that you haven’t assigned the Root category to the default Store of the current default website in your M2 site yet: http://i.prntscr.com/_bEEiIsaSx2QNjML9pPJtg.png

So, please assign the Root category to your Store. Then, reindex the data by CLI again and clean M2 cache.
Hope that helps. 
Regards,
Mall.

#8
Profile photo of jj nini 430.00 $tone March 23, 2019
Public

Hi
No it didn’t
I’ve assigned the root category but still I got the same error
How can I solve this issue because I’m blocked now
 
Regards

#9
Profile photo of Mall Staff 184060.00 $tone March 23, 2019
Public

Hi there,

I’ve assigned the root category but still I got the same error
How can I solve this issue because I’m blocked now

I helped to check further in your instance and I saw a strange that:
You have finished data migration in the step #4, #5 but all your migrated products hasn’t linked to your migrated categories: https://prnt.sc/n1wb4a
Lets try run delta with update mode by run below CLI command:
php -f bin/ubdatamigration run --mode=update
And recheck the issue you mentioned and tell me know how it goes.
Regards,
Mall.

#10
Profile photo of jj nini 430.00 $tone March 24, 2019
Public

hi
As per your request I did the update
Now I see product on category but not in front
As well I still can’t reindex categories I got the same error during reindex
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’71-93′ for key ‘PRIMARY’, query was: INSERT INTO `temp_catalog_category_tree_index_4abdaa58` (`parent_id`,`child_id`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?),
Is there a way to fix this?
 
Thanks

#11
Profile photo of Mall Staff 184060.00 $tone March 24, 2019
Public

Hi there,

Is there a way to fix this?

Could you disable all third-party extensions installed in your M2 instance to test migrated data first?
Regards,
Mall.
 

#12
Profile photo of jj nini 430.00 $tone April 18, 2019
Public

Hello UB team
we have used your module for magento 1 to magento 2 data migration.
while migration we got issues in store wise product attribute value migration in products.
we have 2 store one English and french on both magento 1 and magento 2.
for e.g we have have different product description as per store wise but after migrate we got only English description we didn’t get french description.
so product migration store wise not working.
Also do we migrate static bloc and page while migrating?

please can you help us on that.
Thank you

#13
Profile photo of Mall Staff 184060.00 $tone April 18, 2019
Public

Hi there,

Also do we migrate static bloc and page while migrating?

It’s pity that our migration tool doesn’t support to migrate CMS static blocks at present.

for e.g we have have different product description as per store wise but after migrate we got only English description we didn’t get french description.

That is a strange issue. Did you select the ‘French’ store view to migrate in the Step 2 settings of our migration tool?

Regards,
Mall.
 

#14
Profile photo of Mall Staff 184060.00 $tone April 18, 2019
Public

Hi there,

can we reset data and revert to no data and do again?

Yes, you could reset all steps of our migration tool and re-proceed data migration in all steps from the ground up.

Regards,
Mall.

#16

Please login or Register to Submit Answer

Written By

Comments