There is a problem in my server!

[zayat]

[31/03/2010 22:26:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (SELECT "player_id" AS "vip" FROM "account_viplist" WHERE "account_id" = 1 AND "world_id" = 0)
[31/03/2010 22:26:28] Account Manager has logged in.

[31/03/2010 22:26:28] [Error - CreatureScript Interface]
[31/03/2010 22:26:28] data/creaturescripts/scripts/login.lua: onLogin
[31/03/2010 22:26:28] Description:
[31/03/2010 22:26:29] data/creaturescripts/scripts/login.lua: 32: attempt to call global 'getCreaturePosition' (a nil value)
[31/03/2010 22:26:29] stack traceback:
[31/03/2010 22:26:29] data/creaturescripts/scripts/login.lua: 32: in function <data/creaturescripts/scripts/login.lua:5>

[31/03/2010 22:26:29] [Error - CreatureScript Interface]
[31/03/2010 22:26:29] data/creaturescripts/scripts/loginserver.lua: onLogin
[31/03/2010 22:26:29] Description:
[31/03/2010 22:26:29] data/creaturescripts/scripts/loginserver.lua:2: attempt to call global 'getPlayerPosition' (a nil value)
[31/03/2010 22:26:29] stack traceback:
[31/03/2010 22:26:29] data/creaturescripts/scripts/loginserver.lua:2: in function <data/creaturescripts/scripts/loginserver.lua:1>
[31/03/2010 22:26:29] Account Manager has logged out.

can anyone tell me what to do!!! pls

 

[Cykotitan]

Server version?

 

[zayat]

8.54

 

[Cykotitan]

8.54

Not protocol version..

 

[zayat]

What should i do then, can u tell me pls!

 

[Black Pearl]

copy the first lines when you start the server.

 

[zayat]

Can i have anyone's email so he can be in contact with me. Pls.

And Here's the first lines
[01/04/2010 17:38:48] The Forgotten Server, version 0.3.6 (Crying Damson)
[01/04/2010 17:38:48] Compiled with GNU C++ version 3.4.5 (mingw special) at Dec 24 2009, 10:39:30.
[01/04/2010 17:38:48] A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
[01/04/2010 17:38:48] Visit our forum for updates, support and resources: http://otland.net.

[01/04/2010 17:38:48] >> Loading config (config.lua)
[01/04/2010 17:38:48] > Using plaintext encryption
[01/04/2010 17:38:48] >> Checking software version... up to date!
[01/04/2010 17:38:49] >> Fetching blacklist
[01/04/2010 17:38:49] >> Loading RSA key
[01/04/2010 17:38:49] >> Starting SQL connection
[01/04/2010 17:38:49] >> Running Database Manager
[01/04/2010 17:38:49] > Trigger: oninsert_account_viplist does not exist, creating it...
[01/04/2010 17:38:49] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: main.account_viplist (CREATE TRIGGER "oninsert_account_viplist" BEFORE INSERT ON "account_viplist" FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'INSERT on table `account_viplist` violates foreign: `account_id`') WHERE NEW."account_id" IS NULL OR (SELECT "id" FROM "accounts" WHERE "id" = NEW."account_id") IS NULL; SELECT RAISE(ROLLBACK, 'INSERT on table `account_viplist` violates foreign: `player_id`') WHERE NEW."player_id" IS NULL OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL; END
[01/04/2010 17:38:49] > Trigger: onupdate_account_viplist does not exist, creating it...
[01/04/2010 17:38:49] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: main.account_viplist (CREATE TRIGGER "onupdate_account_viplist" BEFORE UPDATE ON "account_viplist" FOR EACH ROW BEGIN SELECT RAISE(ROLLBACK, 'UPDATE on table `account_viplist` violates foreign: `player_id`') WHERE NEW."player_id" IS NULL OR (SELECT "id" FROM "players" WHERE "id" = NEW."player_id") IS NULL; END
[01/04/2010 17:38:49] > Optimized database.
[01/04/2010 17:38:49] >> Loading items

 

[Swizi]

Youve got a server version TFS 0.3.6
Gl gope some1 help you out

 

[sorcerers king]

Are u sure he have 0.3.6?

 

[Onizuka]

change sqlite to mysql in config.lua ;x

 

[zayat]

yes im sure i have 0.3.6. and about u Anco when i do that the doesnt open, it says Can not log sql connection

 

[kilergui]

I'm having the same problem