PHP:
[4:29:58.749] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `gui
ld_id`) VALUES (560, 410) - MYSQL ERROR: Cannot add or update a child row: a for
eign key constraint fails (`tibia`.`guild_invites`, CONSTRAINT `guild_invites_ib
fk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (14
52)
[4:29:58.816] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `gui
ld_id`) VALUES (560, 410) - MYSQL ERROR: Cannot add or update a child row: a for
eign key constraint fails (`tibia`.`guild_invites`, CONSTRAINT `guild_invites_ib
fk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (14
52)
[4:29:58.863] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `gui
ld_id`) VALUES (560, 410) - MYSQL ERROR: Cannot add or update a child row: a for
eign key constraint fails (`tibia`.`guild_invites`, CONSTRAINT `guild_invites_ib
fk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (14
PHP:
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;