Re: ERROR: Error 1452: Cannot add or update a child row: a foreign key constraint fails

[Chad Bourque]

Lee-Ann,

You have to use an existing web-cv value in the venue table. You are trying to insert a value of 0 (which apparently doesn't exist). When you insert a value of zero into an auto_increment column, it takes the next number. So, if you do a:

select * from web_cv;

You'll likely see web_cv_id values of 1, 2, & 3 rather than 0 (though they may be other values than the ones I listed). At any rate, you'll need one of those values for your insert in the venue table. The constraint is preventing you from adding a child row (venue) that doesn't have a parent row associated with it (web_cv).

HTH,
Chad