0

I am getting some errors while importing products in admin

Error code is (attached screen-shot)

 General system exception happened
    Additional data:
    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`dbname`.`email_catalog`, CONSTRAINT `EMAIL_CATALOG_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE), query was: INSERT INTO `email_catalog` (`product_id`,`processed`,`created_at`) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?)

As we can see there is one table "email_catalog" creating the problem while inserting the data.

If anybody have know about that table then please let me know what is the purpose of that table.

Where "email_catalog" table is used.

enter image description here

Improve this question

1 Answer 1

Reset to default
1

This tables is create from Dotdigitalgroup_Emailmodule.If you are not using dotdigital for email and marketing then You Need to disable this extension and it will resolved this issue

Improve this answer
2
  • thanks @amit , its working fine after disabling module. One thing more suppose in future if we enable module, what will impact.Will module work or not since entry will not go that table.Please give your opinion.
    – akgola
    Commented Jul 20, 2021 at 12:43
  • If you will enable this extension in future then same error is happen
    – Amit Bera ♦
    Commented Jul 20, 2021 at 13:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.