Solved TFS 0.4 Database Error on Player's Logins

[rogerthat]

Hail OTLand! I just started to create my own OTServer for Tibia 8.6, and right now I really need your help to solve a problem, please.

So, well. I'm having this error messages everytime someone logs in the game:

.................................everything is loaded perfectly..........................................
[28/5/2014 14:42:26] > Total loading time: 1.5 seconds.

[28/5/2014 14:42:27] >> MyTibiaServer Online! //The server starts up with no error messages

[28/5/2014 14:42:37] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (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" = 3 AND "k"."unjustified" = 1 AND "pd"."date" >= 1400694157 AND "k"."war" = 0)

[28/5/2014 14:42:37] Sematico has logged in.

[28/5/2014 14:43:2] Sematico has logged out.

[28/5/2014 14:43:7] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (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" = 2 AND "k"."unjustified" = 1 AND "pd"."date" >= 1400694187 AND "k"."war" = 0)

[28/5/2014 14:43:7] GOD Kronos has logged in.

[28/5/2014 14:43:11] GOD Kronos has logged out.

Everytime someone logins, no matter who it is, this error message appears... I did some research and apparently this is a database error (but I can be wrong too).

I'm using the TFS 0.4 Rev 3777 on Windows 7 Ultimate 64 bits. The tool I use to work with database is the SQLite Studios. If you need to know anything else: scripts, my config.lua, or anything else to help, please ask for it on the comments.

I'm really in need of your help to solve this ASAP! Any help will be greatly appreciated.

 

[Ninja]

ALTER TABLE killers ADD war INTEGER NOT NULL DEFAULT 0;

 

[rogerthat]

ALTER TABLE killers ADD war INTEGER NOT NULL DEFAULT 0;

That worked perfectly! Thank you very much, did not expect to have such a fast and simple answer! Thanks!