search

firebearstudio / importexportfree

Improve default Magento 2 Import / Export features - cron jobs, CSV , XML , JSON , Excel , mapping of any format, Google Sheet, data and price modification, improved speed and a lot more!
https://firebearstudio.com/the-improved-import.html
Open Software License 3.0
180 stars 68 forks source link

Import product having integrity constraint error #8

Closed nagrgk closed 7 years ago

nagrgk commented 7 years ago

Hi,

Can you please let us know if you have any fix for error, attached. normally product update never works on enterprise version. update_product_error

thanks

biotech commented 7 years ago

Recent version of extension (both paid and free) should works correctly on last version of M2 CE and EE. Please try again and let us know if you still have issues

lburgosDO commented 7 years ago

Hello,

I have tried 3 different versions 1.2.0, 1.3.0 and the free version on Magento 2 EE 2.1.2. I receive the same error every time I try to update/add attributes to products. If I disable the module, it works fine.

General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (cmc_sandbox_magento.catalog_product_entity, CONSTRAINT CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID FOREIGN KEY (attribute_set_id) REFERENCES eav_attribute_set (attribute_set_i), query was: INSERT INTOcatalog_product_entity(updated_at,entity_id) VALUES (?, ?) ON DUPLICATE KEY UPDATEupdated_at= VALUES(updated_at`)

Can you verify this works for my version? I have spent countless hours trying to troubleshoot and fix it.

biotech commented 7 years ago

@lburgosDO have you contact our support service? can you please update your ticket and we will help you with debug and fix asap!

biotech commented 7 years ago

Fixed with last update