category/product error: entity_id default value

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

Profile photo of ubdev Staff 71680.00 $tone October 2, 2020
Public

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
 

#1
Profile photo of ubdev Staff 71680.00 $tone October 5, 2020
Public

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

#3
Profile photo of ubdev Staff 71680.00 $tone October 5, 2020
Public

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

#5

Please login or Register to Submit Answer

Written By

Comments