Help With A Problem

[lizudus]

hello friends this happens to me in the exe and do not enter people <_<

[18/04/2011 14:06:56] Deniz has logged out.
[18/04/2011 14:07:12] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'

Any Solution?

rep+

 

[mhamad]

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"