INSERT query error: "Cannot add or update a child row: a foreign key constraint fails"

Question

I am getting this error while inserting in my table:

A Database Error Occurred
Error Number: 1452

Cannot add or update a child row: a foreign key constraint fails (`giftme`.`giftme_shop`, CONSTRAINT `shop_ibfk_2` FOREIGN KEY (`sh_cid`) REFERENCES `giftme_shop_category` (`sc_cid`) ON DELETE CASCADE)

INSERT INTO `giftme_shop` (`sh_uid`, `sh_shop_name`, `sh_cid`) VALUES ('79', 'Naveen Reddys shop', 1)

Filename: /var/www/apps/helpers/sessions_helper.php

Line Number: 55

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

there is foreign key reference

parent : `giftme_shop_category`.`sc_cid`
child : `giftme_shop`.sh_cid

there is no value of sc_cid=1 in parent table

Remove Foreign Key constraint

ALTER TABLE giftme_shop DROP FOREIGN KEY shop_ibfk_2;

read here

http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

 ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 8, 2011 at 12:58

xkeshav

54.2k47 gold badges183 silver badges256 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

INSERT query error: "Cannot add or update a child row: a foreign key constraint fails"

1 Answer 1

http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related