Database problem :<

[picachu]

INSERT INTO guild_kills (´guild_id´, `war_id´, ´death_id´) values (0, 2, 518); - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fials (´otdb´.guild_kills´, CONSTRAINT ´guild_kills_ibfk_3´ FOREIGN KEY (´guild_id´) REFERENCES ´guilds´ (´id´) ON DELETE CASCADE (1452)

it appears on console
help plz :<

when i kill someone in WAR, and I'M NOT IN WAR, give this error on console
how to fix? :<

 

[mhamad]

ALTER TABLE `guilds` 
ADD `invited_to` INT( 11 ) NOT NULL ,
ADD `invited_by` INT( 11 ) NOT NULL ,
ADD `in_war_with` INT( 11 ) NOT NULL ,
ADD `kills` INT( 11 ) NOT NULL ,
ADD `show` SMALLINT( 1 ) NOT NULL ,
ADD `war_time` INT( 11 ) NOT NULL ;

 CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL 
) ENGINE = MYISAM ;

UPDATE `guilds` SET `invited_to` = 0, `invited_by` = 0, `in_war_with` = 0, `kills` = 0, `show` = 0, `war_time` = 0 WHERE `id` > 0;

 

[picachu]

Problem solved. Thank yoU! REP++