Hi,
we get the error below when trying to import categories
2020/10/02 11:18:52 [error] [ub_data_migration] CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field ‘entity_id’ doesn’t have a default value. The SQL statement executed was: INSERT INTO `catalog_category_entity` (`attribute_set_id`, `parent_id`, `level`, `created_in`, `updated_in`, `created_at`, `updated_at`, `path`, `position`, `children_count`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp
below the error we get when trying to import products
2020/10/02 11:32:21 [error] [ub_data_migration] CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field ‘entity_id’ doesn’t have a default value. The SQL statement executed was: INSERT INTO `catalog_category_entity` (`attribute_set_id`, `parent_id`, `level`, `created_in`, `updated_in`, `created_at`, `updated_at`, `path`, `position`, `children_count`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)
5 answers
Hi Marco,
We wonder if you have another profile at Ubertheme, we could not keep track of the purchase associated with your profile though.
We’re sorry for this additional question since our technical support requires an active subscription.
PS. Our team is off at the weekend, our apology for a certain delay in response during this time.
Regards,
Ubertheme team
Hi Marco,
We’re sorry for replying to you this late as we’ve just been back from our weekend.
General error: 1364 Field ‘entity_id’ doesn’t have a default value. The SQL statement executed was: INSERT INTO `catalog_category_entity` (`attribute_set_id`, `parent_id`, `level`, `created_in`, `updated_in`, `created_at`, `updated_at`, `path`, `position`,
That is a strange issue. Please consider performing data migration with our latest UB Data Migration Pro v.3.2.4 in a new fresh M2 instance.
For your information, that issue relates to the setting of the ‘catalog_category_entity’ table in your M2 database. Please check and make sure that the ‘entity_id’ field has been marked as Auto Increment field like this screenshot https://prnt.sc/ut62me
PS. For any new questions that you might have, please submit it under your paid profile since our technical support requires an active subscription.
Regards,
Ubertheme team
Hi Marco,
Our module supports Magento CE 1.x to Magento CE 2.x only, as noted in our product page.
Some of our users did use the module to proceed with Magento EE-related data migration projects, however, they all handled the issues during the migration process.
Regards,
Ubertheme team
