• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Elfwar system error

Status
Not open for further replies.

vBzone

Banned User
Joined
Mar 1, 2009
Messages
119
Reaction score
0
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
and i have the table already at mysql
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;
Please Help
 
Status
Not open for further replies.
Back
Top