jefinho01

ainda continua o erro: > 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;)

irei testar, mas serve para que isso?

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

sim em sqlite, não sei abrir em mysql

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.

alguem tem o mapa?