I want to insert into a table called Festivals that has two foreign keys (venueID & ticketID).
$addFestivalSql = "INSERT INTO festivals VALUES(DEFAULT, :festivalName, :festivalDescription, :festivalImage, :festivalLineup, :musicTypeId, DEFAULT, DEFAULT)";
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails
The Festivals Table:
The Festivals Table
I've created the two foreign key constraints with venueID and ticketID relating to the two primary keys.
Why do you think I'm getting this error?