Solved Sqlite Problem!

[delton]

When players login:

[22/07/2010 19:05:54] > Saving server...
[22/07/2010 19:05:54] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (DELETE FROM "account_viplist" WHERE "account_id" = 3 AND "world_id" = 0)
[22/07/2010 18:59:45] Error while saving player: Dellton.

Help Plx

 

[freaked1]

Okey, it clearly says that you don't have a table named account_viplist.
Execute this in Phpmyadmin:

CREATE TABLE "account_viplist" (
	"account_id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"player_id" INTEGER NOT NULL,
	UNIQUE ("account_id", "player_id"),
	FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);

 

[delton]

Alrady Fixed with Sqlite editor

UP

Thanks for help, but i was needed in SQLITE.