When I try to generate configurable products from Magento dashboard, I am getting the sql error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (admin_raba.catalog_product_website, CONSTRAINT CATALOG_PRODUCT_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID FOREIGN KEY (website_id) REFERENCES store_website (website_id) ON DE), query was: INSERT INTO catalog_product_website (product_id,website_id) VALUES (?, ?) tried checking the catalog_product_website table. seems no problem. any help would be appreciated.

  • I am in the same boat. Everything I am seeing is related to not having a Store with id 0.
    – Samyer
    Aug 24, 2022 at 21:59


Your Answer

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

Browse other questions tagged or ask your own question.