Help with deaths SOLVED

[Soma]

well i know its kind of noob but i cant fix this D:

everytime i die i return to lvl 8 in my server.

i think this is something in config any idea?

thanks... REP+++

 

[Djivar]

both yes and no

 

[Soma]

how can i fix this?

 

[Djivar]

is it when they have bless? or dose it happen with both with bless and without ?

 

[canaan]

theres a problem with sql connection checks if your server says: error while saving x player, if then you should check your schemas and database

 

[Soma]

now that you mention it i do have some errors on data base.

[28/06/2010 17:32:21] > Trigger: oninsert_account_viplist does not exist, creating it...
[28/06/2010 17:32:21] 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
[28/06/2010 17:32:21] > Trigger: onupdate_account_viplist does not exist, creating it...
[28/06/2010 17:32:21] 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

 

[Soma]

hey well you're right when i logout or something this appears.

[28/06/2010 17:37:18] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (DELETE FROM "account_viplist" WHERE "account_id" = 2 AND "world_id" = 0)
[28/06/2010 17:37:18] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (DELETE FROM "account_viplist" WHERE "account_id" = 2 AND "world_id" = 0)
[28/06/2010 17:37:18] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (DELETE FROM "account_viplist" WHERE "account_id" = 2 AND "world_id" = 0)

aAnd This xD

[28/06/2010 17:37:18] Error while saving player: Eternal Oblivion.
[28/06/2010 17:37:19] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: account_viplist (SELECT "player_id" AS "vip" FROM "account_viplist" WHERE "account_id" = 2 AND "world_id" = 0)

 

[Soma]

Fixed! Thanks