I think that something is wrong in my database
I'm getting this error:
[17:26:19.076] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (SELECT "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 "pk"."player_id" = 3 AND "k"."unjustified" = 1 AND "pd"."date" >= 1523287579 AND "k"."war" = 0) [17:26:19.100] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: table killers has no column named war (INSERT INTO "killers" ("death_id", "final_hit", "unjustified", "war") VALUES (1, 1, 1, 0))
Anyone know how to solve it by the easy way? I'm starting on this =D
Note that I'm using Sqlite Studio
I'm getting this error:
[17:26:19.076] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (SELECT "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 "pk"."player_id" = 3 AND "k"."unjustified" = 1 AND "pd"."date" >= 1523287579 AND "k"."war" = 0) [17:26:19.100] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: table killers has no column named war (INSERT INTO "killers" ("death_id", "final_hit", "unjustified", "war") VALUES (1, 1, 1, 0))
Anyone know how to solve it by the easy way? I'm starting on this =D
Note that I'm using Sqlite Studio