[HELP] Error with TFS

[hardstyleftw]

After i loaded my ot, and it starts i ceeping get this error all the time:

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT
* FROM z_ots_comunication WHERE "type" = 'login'
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDA
TE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.online
time5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "on
linetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"
=players.onlinetimetoday, "onlinetimetoday"=0
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE

 

[hardstyleftw]

bump

 

[hardstyleftw]

bump

 

[hardstyleftw]

bump

 

[Cykotitan]

Why are you using SqLite? MySQL is more optimal, better supported and easier to manage

 

[hardstyleftw]

I will make MySQL later, but for now i use SqLite cuz i only test it , but the errors are pretty anoying...

 

[Cykotitan]

CREATE TABLE "z_ots_comunication" (
	"id" INTEGER NOT NULL auto_increment,
	"name" varchar(255) NOT NULL,
	"type" varchar(255) NOT NULL,
	"action" varchar(255) NOT NULL,
	"param1" varchar(255) NOT NULL,
	"param2" varchar(255) NOT NULL,
	"param3" varchar(255) NOT NULL,
	"param4" varchar(255) NOT NULL,
	"param5" varchar(255) NOT NULL,
	"param6" varchar(255) NOT NULL,
	"param7" varchar(255) NOT NULL,
	"delete_it" INTEGER NOT NULL default "1",
	PRIMARY KEY  ("id")
)

ALTER TABLE "players" ADD "exphist_lastexp" BIGINT NOT NULL DEFAULT '0',
ADD "exphist1" BIGINT NOT NULL DEFAULT '0',
ADD "exphist2" BIGINT NOT NULL DEFAULT '0',
ADD "exphist3" BIGINT NOT NULL DEFAULT '0',
ADD "exphist4" BIGINT NOT NULL DEFAULT '0',
ADD "exphist5" BIGINT NOT NULL DEFAULT '0',
ADD "exphist6" BIGINT NOT NULL DEFAULT '0',
ADD "exphist7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimetoday" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime1" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime2" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime3" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime4" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime5" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime6" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetime7" BIGINT NOT NULL DEFAULT '0',
ADD "onlinetimeall" BIGINT NOT NULL DEFAULT '0';

UPDATE "players" SET "exphist_lastexp"="players"."experience"