• 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!

Elf war system problem

nemezis

# Lazybones #
Joined
Jan 1, 2011
Messages
152
Reaction score
5
Location
Hole in Poland
Hi i have errors
Code:
[23:23:10.350] mysql_real_query(): INSERT INTO `guild_kills` (`guild_id`, `war_id`, `death_id`) VALUES (0, 320, 46594); - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`ots/guild_kills`, CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE) (1452)

Where is bug? how fix it?
 
PHP:
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 ;
 
Back
Top