Compiling 0.4DEV with guild bug.

[Radium]

[28/1/2011 1:15:29] mysql_real_query(): INSERT INTO `guild_invites` (`player_id`, `guild_id`) VALUES (1914, 293) - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`tfs3`.`guild_invites`, CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (1452)

I have compiled with 0.4 Dev and i am getting this error whilst people are trying to invite players to guild. Do you know what the problem is?

 

[Kippetjee]

its elfs war system?

 

[Radium]

The war system is working just fine. Its the Guild Invite that isnt working correctly. as it gives that error.

 

[Glidarn]

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;

repp if it helped

 

[Radium]

I just re-newed the table, I could still do the duping bug. :/