SOME ERRORS ON MY DATABASE

[Xenoriano]

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?

 

[WibbenZ]

Either wrong database or query
The error says it all: SQLITE ERROR: table killers has no column named war

The table killers in your database does not have a column named war.
You might solve the issue by adding that column but there might be other things you need to fix aswell.

Since it's 0.4 you most likely are using a script for a later / earlier version of 0.4 or 0.3.

 

[Xenoriano]

Where can I find well script for this? I've been searching for it, I tried to download different scripts but I'm getting the same problem

 

[WibbenZ]

Where can I find well script for this? I've been searching for it, I tried to download different scripts but I'm getting the same problem

Ex Insert new column into table in sqlite?
But I have no clue why you wanna use SQLite over MySQL

 

[Xenoriano]

Fixed, thanks

 

[Xenoriano]

[16:29:18.669] mysql_real_query(): INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `skull`, `skulltime`, `save`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `online`) VALUES (NULL, 'Zurdoo', 0, 1, 2, 20, 1, 245, 245, 98800, 68, 76, 78, 39, 128, 0, 0, 395, 395, 0, 100, 5, 32369, 32241, 7, 0, 555, 1, 0, 0, 0, 0, 1, 0, '', 0, 0, 0) - MYSQL ERROR: Thread stack overrun: 8688 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. (1436)


I was following Znote tutorial, but I'm getting this error. Any idea?

 

[theru]

[16:29:18.669] mysql_real_query(): INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `skull`, `skulltime`, `save`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `online`) VALUES (NULL, 'Zurdoo', 0, 1, 2, 20, 1, 245, 245, 98800, 68, 76, 78, 39, 128, 0, 0, 395, 395, 0, 100, 5, 32369, 32241, 7, 0, 555, 1, 0, 0, 0, 0, 1, 0, '', 0, 0, 0) - MYSQL ERROR: Thread stack overrun: 8688 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. (1436)


I was following Znote tutorial, but I'm getting this error. Any idea?

long answer....MySQL error 1436: Thread stack overrun, with simple query
short answer
prolly mysql(conf.file)
a quick fix could be to increase the thread_stack size by incrementing it in your .cnf:

thread_stack = 256K

 

[theru]

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?

missing column war in table killers

 

[Xenoriano]

Fixed, thanks to @MaR0 , he helped me with this