AAC I need help in Fatal Error

[Godz4t4n1c]

I installed a new administrator and when a player connects I see this on the console !!
I already import the guild_wars table, but the error continues when I connect to a player

[14/1/2018 1:27:56] > Bound ports: 7171 7172
[14/1/2018 1:27:56] >> Everything smells good, server is starting up...
[14/1/2018 1:27:56] > Total loading time: 3.854 seconds.
[14/1/2018 1:27:57] >> Selvatid oT Online!
[14/1/2018 1:28:20] mysql_real_query(): SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 7 AND `k`.`unjustified` = 1 AND `pd`.`date` >= 1515284900 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)
[14/1/2018 1:28:20] ADM Jean has logged in.

please I need help!

 

[Itutorial]

Check in your guild wars table do you see a column named war?

 

[Godz4t4n1c]

Check in your guild wars table do you see a column named war?

xdxa10.png - Click to see more photos on ServImg

i need clumn??

 

[Itutorial]

You need add `war`

ALTER TABLE `player_killers` ADD `war` INT(11) NOT NULL DEFAULT 0;

 

[Godz4t4n1c]

You need add `war`

ALTER TABLE `player_killers` ADD `war` INT(11) NOT NULL DEFAULT 0;

How do I add it ?, where should I write that commands?

 

[Itutorial]

In your database, execute that.

 

[Godz4t4n1c]

I'm sorry, here?

xcxcxc12.png - Click to see more photos on ServImg

 

[Itutorial]

Yes

 

[Godz4t4n1c]

Yes

brother, now this error appears ... .

[15/1/2018 3:54:4] mysql_real_query(): SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 8 AND `k`.`unjustified` = 1 AND `pd`.`date` >= 1515380044 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)

 

[Itutorial]

ALTER TABLE `player_deaths` ADD `war` INT(11) NOT NULL DEFAULT 0;

try this one. Delete the war column from your player_kills table.

 

[Godz4t4n1c]

nothing, this error appears

mysql_real_query(): SELECT `pk`.`player_id`, `pd`.`date` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` WHERE `pd`.`player_id` = 8 AND `k`.`unjustified` = 1 AND `pd`.`date` >= 1515382742 AND `k`.`war` = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)

 

[Webtimize]

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

 

[Godz4t4n1c]

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

THANKS.... <3