Windows Problem with frags

[therrax]

Hi,
TFS 0.4
when I kill somebody on my OT I got this:

[23:23:24.833] mysql_real_query(): SELECT `pd`.`date` FROM `player_killers` pk L
EFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id`LEFT JOIN `player_deaths` pd ON
`k`.`death_id` = `pd`.`id` WHERE `pk`.`player_id` = 15 AND `k`.`unjustified` =
1 AND `pd`.`date` >= 1400448204 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column
'k.war' in 'where clause' (1054)
[23:23:24.835] mysql_real_query(): INSERT INTO `killers` (`death_id`, `final_hit
`, `unjustified`, `war`) VALUES (104, 1, 1, 0) - MYSQL ERROR: Unknown column 'wa
r' in 'field list' (1054)

how to fix that? :/

 

[mariante]

insert the column war in your killers table database
@edit

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

 

[therrax]

@mariante Yes, but how? :/

 

[Limos]

ALTER TABLE `killers` ADD `war` TINYINT(1) NOT NULL DEFAULT 0;

http://otland.net/threads/mysql-how-to-run-a-query.177833/

 

[mariante]

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

 

[therrax]

I will check this Thanks to all!
__________
edit
Great! All perfect