mysql - Innobyte插件问题: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row

Question

当我尝试在 Magento 中保存产品时，我收到此问题:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (papet_mag.innobyte_emag_marketplace_product_cat_characteristic, CONSTRAINT FK_FC8B248E7E23F0E4DAEC8D31641C9910 FOREIGN KEY (product_id) REFERENCES `innobyte_emag_marketplace_category_c)

查询是:

INSERT INTO `innobyte_emag_marketplace_product_cat_characteristic` (`product_id`,`characteristic_id`,`value`) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?)

我可以做什么来解决这个问题？这对我来说是新的。这个问题最近出现

Answer 1

这个消息对我来说似乎很清楚:

• 您正在尝试向表中插入一行 innobyte_emag_marketplace_product_cat_characteristic与 product_id引用的表 innobyte_emag_marketplace_category_c 中不存在该值.

问题是:具体是什么product_id ，它真的存在吗？