Magento Cannot products to related,upsell,crossell. showing error

0
votes

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (cl55-m755.catalog_product_link, CONSTRAINT FK_CAT_PRD_LNK_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID FOREIGN KEY (link_type_id) REFERENCES catalog_product_link_type (link_type_id) ON),

query was:

INSERT INTOcatalog_product_link(product_id,linked_product_id,link_type_id) VALUES (?, ?, ?)

While selecting products for related/upsell/crossell shows this error.

1
mysqlmagentomagento-1.9
I'm voting to close this question as off-topic because Stack Overflow is a programming-related Q&A site. Your question is not about programming. Perhaps you should post it on magento.stackexchange.com instead? - Enigmativity

1 Answers

3
votes

INSERT INTO catalog_product_link_type (link_type_id, code) VALUES (1, 'relation'), (3, 'super'), (4, 'up_sell'), (5, 'cross_sell');

This solved the issue.