Xenoriano
New Member
- Joined
- May 9, 2018
- Messages
- 19
- Reaction score
- 0
Hi guys, as the title says, I am getting two errors on my database:
1- [22:37:40.737] sqlite3_step(): SQLITE ERROR: guilds.checkdata may not be NULL
This appears when I try to create a guild
2- [22:47:12.160] 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" >= 1523306832 AND "k"."war" = 0)
[22:47:12.175] 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))
This one appears when I kill a player taking skull and unjustified frag. The second one, may be the script that I use on talkactions/scripts, frags.lua is wrong?. Anyone have any idea how to fix it?
Note that I'm using Sqlite studio, TFS 0.4 for client 8.60.
Kind Regards.
Someone help?
1- [22:37:40.737] sqlite3_step(): SQLITE ERROR: guilds.checkdata may not be NULL
This appears when I try to create a guild
2- [22:47:12.160] 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" >= 1523306832 AND "k"."war" = 0)
[22:47:12.175] 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))
This one appears when I kill a player taking skull and unjustified frag. The second one, may be the script that I use on talkactions/scripts, frags.lua is wrong?. Anyone have any idea how to fix it?
Note that I'm using Sqlite studio, TFS 0.4 for client 8.60.
Kind Regards.
Someone help?
Last edited by a moderator: