Using UB Data Migration Pro -- 3.0.4 module, I tried to migrate data, however i got an error at step 4 -- Migrate Categories
http://prntscr.com/e3zb84
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_set_id’ cannot be null
Error by running command form CLI
Processing in step #4….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_set_id’ cannot be null. The SQL statement executed was: UPDATE `catalog_category_entity` SET `attribute_set_id`=:yp0, `parent_id`=:yp1, `level`=:yp2, `entity_id`=:yp3, `created_at`=:yp4, `updated_at`=:yp5, `path`=:yp6, `position`=:yp7, `children_count`=:yp8 WHERE `catalog_category_entity`.`entity_id`=’343′
I looked into database table catalog_category_entity and column attribute_set_id
SELECT GROUP_CONCAT(`attribute_set_id`) FROM `catalog_category_entity` ORDER BY `attribute_set_id` DESC LIMIT 500
0,3,0,0,3,3,0,0,0,3,3,3,3,0,0,0,0,0,0,0,0,0,3,3,3,0,0,0,0,0,0,3,3,3,0,0,0,3,3,0,0,0,0,0,0,0,0,0,3,3,3,3,3,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,0,3,0,3,3,3,0,0,0,3,0,0,0,3,3,0,3,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3
None of all entities has null
I can send you any of db dump or database structure.
Or if it is exist some logs form UB Data Migration module. (I did not find any)
Thank you for help.
1 answer
Hi Filip Krejci,
That is a strangle issue. I seem comes from bad data of your categories in Magento1’s database.
Let’s provide me the admin and root ssh credentials of your Magento2. I will check further and help you out.
Regards,
Mall.