Solved Localhost (mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `guild_id`)

[Celsish]

mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `guild_id`) VALUES (34, 6) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`OTmap`.`guild_invites`, CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (1452)


How do I fix??

 

[AchTung]

CREATE TABLE `guild_invites`
(
	`player_id` INT NOT NULL DEFAULT 0,
	`guild_id` INT NOT NULL DEFAULT 0,
	UNIQUE (`player_id`, `guild_id`),
	FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
	FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Celsish]

awesome dude, rep!

 

[Zoriax_]

rep++

 

[cykor119]

Thanks xd