SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sma`.`episodes`, CONSTRAINT `episodes_ibfk_1` FOREIGN KEY (`show_id`) REFERENCES `shows` (`id`))SQL:
CREATE TABLE IF NOT EXISTS shows (
id int unsigned not null AUTO_INCREMENT,
tvdb_id int unsigned,
bd_id int unsigned,
name varchar(200) not null,
date_added datetime not null,
PRIMARY KEY(id),
UNIQUE KEY(tvdb_id, bd_id)
) ENGINE=INNODB;
CREATE TABLE episodes (
id bigint unsigned not null AUTO_INCREMENT,
show_id int unsigned not null,
season tinyint unsigned not null,
episode tinyint unsigned not null,
date_added datetime not null,
PRIMARY KEY(id),
INDEX(show_id),
FOREIGN KEY (show_id) REFERENCES shows (id) ON UPDATE CASCADE ON DELETE RESTRICT
) ENGINE=INNODB;
Als ik een record via phpmyadmin invoeg krijg ik geen error. Is mijn FOREIGN KEY verkeerd?
Dit is mijn PDO query:
$insertNewEpisode = 'INSERT INTO episodes (show_id, season, episode, date_added) VALUES
(:show_id, :bierdopje_season, :bierdopje_episode, now())';