Ir para conteúdo

Erros no otserv

Por jefinho01
em Suporte Tibia OTServer

Featured Replies

Postado

Diga em poucas palavras a base utilizada (Nome do servidor ou nome do website).

Ex. TFS 1.3;

Base: pbot

 

 

Qual erro está surgindo/O que você procura?

boa noite pessoal, sou novo no fórum e gostaria de ajuda para solucionar esses erros que da quando eu abro meu servidor (sqlitestudio) que segue abaixo:

ps: O servidor tambem está com problema de salvar quando reloga ele volta tudo, porfavor alguem poderia me ajudar? 

agradeço desde ja!

 

> Trigger: ondelete_accounts does not exist, creating it...
OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "DELETEON": syntax error (CREATE TRIGGER "ondelete_accounts"BEFORE DELETEON "accounts"FOR EACH ROWBEGIN     DELETE FROM "players" WHERE "account_id" = OLD."id";    DELETE FROM "account_viplist" WHERE "account_id" = OLD."id";    DELETE FROM "bans" WHERE "type" IN (3, 4) AND "value" = OLD."id";END;)
> Trigger: oninsert_account_viplist does not exist, creating it...
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;)
> Trigger: onupdate_account_viplist does not exist, creating it...
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;)

 

[Warning - Spell::configureSpell] Wrong vocation name: Force Archer
[Warning - Spell::configureSpell] Wrong vocation name: Force Archer
[Warning - Spell::configureSpell] Wrong vocation name: Force Archer

 

[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
I/O warning : failed to load external entity "data/npc/Capitao.xml"
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/Capitao.xml).
Info: failed to load external entity "data/npc/Capitao.xml"


[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Treiner"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
[Spawn::addMonster] Cannot find "Yeti"
I/O warning : failed to load external entity "data/npc/capitao vip.xml"
[Warning - Npc::loadFromXml] Cannot load npc file (data/npc/capitao vip.xml).
Info: failed to load external entity "data/npc/capitao vip.xml"


[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Tibia Bug"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Minishabaal"
[Spawn::addMonster] Cannot find "Chuck Norris the Cow Master"

 

[Error - GlobalEvent Interface]
data/globalevents/scripts/start.lua:onStartup
Description:
data/globalevents/scripts/start.lua:3: attempt to call field 'executeQuery' (a nil value)
stack traceback:
        data/globalevents/scripts/start.lua:3: in function <data/globalevents/scripts/start.lua:1>

 

Você tem o código disponível? Se tiver publique-o aqui: 

 

 

Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.Screenshot_7.thumb.png.82696d9fa1a56e778f94cdb9c463cbba.pngScreenshot_6.thumb.png.3c0259c5f6a7203e276bc07c931f7f51.pngScreenshot_5.thumb.png.d3bb5bd093a7d54d4610155583c08d36.pngScreenshot_8.thumb.png.7b126ecbf1f4b4650d4d448106a20ab0.png

Editado por jefinho01 (veja o histórico de edições)

  • Citar
  • Mention
    • Respostas 8
    • Visualizações 905
    • Created
    • Última resposta

    Top Posters In This Topic

    Popular Days

    Posted Images

    Postado
    • Autor
    Em 14/09/2018 em 02:28, victor4312 disse:

    Você esta abrindo o servidor em sqlite? os erro dos monsters acontecem por que tem o respaw deles no mapa mas não está de acordo ou não existe na pasta monsters

     

    sim em sqlite, não sei abrir em mysql

  • Citar
  • Mention
    • Postado

    Seus erros são basicamente :

     

    1- Não existe aquela tabela na sua database (porém a distro parece que criou elas)

    2- Os monsters não estão catalogados no monsters.xml

    3- Poste o arquivo start.lua para da uma olhada (entre spoilers)

    Senhoras e senhores, se alguma resposta lhe ajudou, marque-a como a melhor resposta e de ponto positivo, assim você incentiva quem lhe ajudou a continuar ajudando!!.

  • Citar
  • Mention
    • Postado
    • Autor
    4 horas atrás, tetheuscunha disse:

    Seus erros são basicamente :

     

    1- Não existe aquela tabela na sua database (porém a distro parece que criou elas)

    2- Os monsters não estão catalogados no monsters.xml

    3- Poste o arquivo start.lua para da uma olhada (entre spoilers)

      

    e como eu removo essa tabela da minha distro?


function onStartup()
	
db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")

db.executeQuery("DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < " .. (os.time() - 2 * 86400) .. ";")

db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")

end

    start.lua

    Editado por jefinho01 (veja o histórico de edições)

  • Citar
  • Mention
    • Postado
    11 minutos atrás, jefinho01 disse: 
    
e como eu removo essa tabela da minha distro?


function onStartup()
	
db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")

db.executeQuery("DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < " .. (os.time() - 2 * 86400) .. ";")

db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")

end

    start.lua

     

    Tenta assim :

     



     

    function onStartup()
        
    db.query("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")

    db.query("DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < " .. (os.time() - 2 * 86400) .. ";")

    db.query("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")

    end

    Senhoras e senhores, se alguma resposta lhe ajudou, marque-a como a melhor resposta e de ponto positivo, assim você incentiva quem lhe ajudou a continuar ajudando!!.

  • Citar
  • Mention

    • Participe da conversa

    Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

    Visitante
    Responder
    Ir para a lista de tópicos

    Quem Está Navegando 0

    • Nenhum usuário registrado visualizando esta página.

    Conteúdo Similar

    Estatísticas dos Fóruns

    • Tópicos 96.9k
    • Posts 519.9k

    Informação Importante

    Confirmação de Termo

    I accept