Bgames
Olá visitante! Seja bem vindo ao nosso fórum!

Para você ter total acesso ao nosso fórum é preciso que você se cadastre.

Cadastre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

TrinityCore - Faltam tabelas na database World

Ver o tópico anterior Ver o tópico seguinte Ir em baixo

TrinityCore - Faltam tabelas na database World

Mensagem por marcell.ribeiro em Qui 5 Jul 2012 - 8:12

Olá. Fiz tudo certinho de acordo com o tutorial. Executei os sqls que vem lá:

Importei os sqls de: /TrinityServer/sql/create/

depois baixei o último TDB e importei os sqls também.

e na hora de importar os updates que estão em /TrinityServer/sql/updates/world/ deu:

Código:

ERROR 1146 (42S02) at line 1: Table 'world.disables' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.version' doesn't exist
ERROR 1146 (42S02) at line 15: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_proc_event' doesn't exist
ERROR 1146 (42S02) at line 53: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_start_scripts' doesn't exist
ERROR 1146 (42S02) at line 9: Table 'world.npc_spellclick_spells' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.event_scripts' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_dbc' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.page_text' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.game_event' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 11: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.spell_area' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 46: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 16: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_loot_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 18: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_text' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 13: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 13: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_transport' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.quest_start_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_dbc' doesn't exist
ERROR 1146 (42S02) at line 11: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 17: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_ranks' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spelldifficulty_dbc' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 34: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 9: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.npc_text' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 86: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject_questrelation' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 16: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.game_graveyard_zone' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.script_texts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 19: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist


Logo, na hora de rodar o worldserver deu:

Código:

Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 0.9.8o 01 Jun 2010 (library: OpenSSL 0.9.8o 01 Jun 2010)
Using ACE version: 5.7.7
TrinityCore rev. 2012-07-03 12:35:06 +0200 (537caf33e9ee+) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                      __
/\__  _\      __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
  \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
    \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/  \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                C O R E  /\___/
                                              \/__/

Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.1.63
MySQL server ver: 5.1.63-0+squeeze1
[ERROR]: In mysql_stmt_prepare() id: 1, sql: "DELETE FROM linked_respawn WHERE guid = ?"
[ERROR]: Table 'world.linked_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 2, sql: "REPLACE INTO linked_respawn (guid, linkedGuid) VALUES (?, ?)"
[ERROR]: Table 'world.linked_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 6, sql: "DELETE FROM gameobject WHERE guid = ?"
[ERROR]: Table 'world.gameobject' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 7, sql: "DELETE FROM game_event_gameobject WHERE guid = ?"
[ERROR]: Table 'world.game_event_gameobject' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 8, sql: "INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (?, ?, ?)"
[ERROR]: Table 'world.game_graveyard_zone' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 9, sql: "DELETE FROM game_graveyard_zone WHERE id = ? AND ghost_zone = ? AND faction = ?"
[ERROR]: Table 'world.game_graveyard_zone' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 10, sql: "INSERT INTO game_tele (id, position_x, position_y, position_z, orientation, map, name) VALUES (?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.game_tele' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 11, sql: "DELETE FROM game_tele WHERE name = ?"
[ERROR]: Table 'world.game_tele' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 12, sql: "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost) VALUES(?, ?, ?, ?, ?)"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 13, sql: "DELETE FROM npc_vendor WHERE entry = ? AND item = ?"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 22, sql: "INSERT INTO waypoint_data (id, point, position_x, position_y, position_z) VALUES (?, ?, ?, ?, ?)"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 23, sql: "DELETE FROM waypoint_data WHERE id = ? AND point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 24, sql: "UPDATE waypoint_data SET point = point - 1 WHERE id = ? AND point > ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 25, sql: "UPDATE waypoint_data SET position_x = ?, position_y = ?, position_z = ? where id = ? AND point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 26, sql: "UPDATE waypoint_data SET wpguid = ? WHERE id = ? and point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 27, sql: "UPDATE waypoint_data SET wpguid = 0"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 44, sql: "INSERT INTO waypoint_scripts (guid) VALUES (?)"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 45, sql: "DELETE FROM waypoint_scripts WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 46, sql: "UPDATE waypoint_scripts SET id = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 47, sql: "UPDATE waypoint_scripts SET x = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 48, sql: "UPDATE waypoint_scripts SET y = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 49, sql: "UPDATE waypoint_scripts SET z = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 50, sql: "UPDATE waypoint_scripts SET o = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 53, sql: "INSERT INTO creature_transport (guid, npc_entry, transport_entry,  TransOffsetX, TransOffsetY, TransOffsetZ, TransOffsetO) values (?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.creature_transport' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 54, sql: "UPDATE creature_transport SET emote = ? WHERE transport_entry = ? AND guid = ?"
[ERROR]: Table 'world.creature_transport' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 64, sql: "DELETE FROM game_event_creature WHERE guid = ?"
[ERROR]: Table 'world.game_event_creature' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 65, sql: "DELETE FROM game_event_model_equip WHERE guid = ?"
[ERROR]: Table 'world.game_event_model_equip' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 66, sql: "INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.gameobject' doesn't exist
MySQL client library: 5.1.63
MySQL server ver: 5.1.63-0+squeeze1
[ERROR]: In mysql_stmt_prepare() id: 0, sql: "SELECT entry, pool_entry FROM pool_quest"
[ERROR]: Table 'world.pool_quest' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound FROM creature_text"
[ERROR]: Table 'world.creature_text' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 4, sql: "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link"
[ERROR]: Table 'world.smart_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 5, sql: "SELECT entry, pointid, position_x, position_y, position_z FROM waypoints ORDER BY entry, pointid"
[ERROR]: Table 'world.waypoints' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 14, sql: "SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = ? ORDER BY slot ASC"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 28, sql: "SELECT MAX(id) FROM waypoint_data"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 30, sql: "SELECT point, position_x, position_y, position_z FROM waypoint_data WHERE id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 31, sql: "SELECT position_x, position_y, position_z FROM waypoint_data WHERE point = 1 AND id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 33, sql: "SELECT id, point FROM waypoint_data WHERE wpguid = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_flag, action, action_chance FROM waypoint_data WHERE wpguid = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 35, sql: "SELECT MAX(point) FROM waypoint_data WHERE id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 36, sql: "SELECT id, point FROM waypoint_data WHERE (abs(position_x - ?) <= ?) and (abs(position_y - ?) <= ?) and (abs(position_z - ?) <= ?)"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 37, sql: "SELECT wpguid FROM waypoint_data WHERE id = ? and wpguid <> 0"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 38, sql: "SELECT DISTINCT action FROM waypoint_data"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 39, sql: "SELECT MAX(guid) FROM waypoint_scripts"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 51, sql: "SELECT id FROM waypoint_scripts WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 57, sql: "SELECT guid, delay, command, datalong, datalong2, dataint, x, y, z, o FROM waypoint_scripts WHERE id = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"
[ERROR]: Table 'world.ip2nationCountries' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 59, sql: "SELECT entry FROM item_template WHERE name = ?"
[ERROR]: Table 'world.item_template' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 61, sql: "SELECT guid, id, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM gameobject WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? ORDER BY order_"
[ERROR]: Table 'world.gameobject' doesn't exist
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

Cannot connect to world database 127.0.0.1;3306;<login>;<senha>;world

E note que na última linha ele diz que não foi possivel conectar na world database. Sendo que já verifiquei no .conf e tá tudo certinho, tanto o host, quanto o login e a senha.

marcell.ribeiro


Mensagens : 1
Pontos : 7

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: TrinityCore - Faltam tabelas na database World

Mensagem por FooFKnight em Qui 5 Jul 2012 - 12:00

Olá Marcelo
Bom Este erro seu é porque sua Data Base "World" está Faltando Alguns Arquivos !
Recomendo você ah das Restore em sua Data Base "World" Novamente Só assim Sera Solucionado o seu Pequeno Erro !
Resolvido?
Atenciosamente, FooFKnight

FooFKnight


Mensagens : 679
Pontos : 679
Evolução : 2


Ver perfil do usuário http://www.hostbrazill.com/

Voltar ao Topo Ir em baixo

Re: TrinityCore - Faltam tabelas na database World

Mensagem por brianun em Qui 5 Jul 2012 - 13:51

a database que você diz é pelo navicat foof ?

brianun


Mensagens : 112
Pontos : 441

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: TrinityCore - Faltam tabelas na database World

Mensagem por FooFKnight em Qui 5 Jul 2012 - 14:05

Tanto Faz Navicat ou SQLyog.
Você tem que Deletar a que você tem que e Restaurar ah Nova "World"
Resolvido?

FooFKnight


Mensagens : 679
Pontos : 679
Evolução : 2


Ver perfil do usuário http://www.hostbrazill.com/

Voltar ao Topo Ir em baixo

Re: TrinityCore - Faltam tabelas na database World

Mensagem por DeltaServers em Qui 5 Jul 2012 - 15:37

marcell.ribeiro escreveu:Olá. Fiz tudo certinho de acordo com o tutorial. Executei os sqls que vem lá:

Importei os sqls de: /TrinityServer/sql/create/

depois baixei o último TDB e importei os sqls também.

e na hora de importar os updates que estão em /TrinityServer/sql/updates/world/ deu:

Código:

ERROR 1146 (42S02) at line 1: Table 'world.disables' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.version' doesn't exist
ERROR 1146 (42S02) at line 15: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_proc_event' doesn't exist
ERROR 1146 (42S02) at line 53: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_start_scripts' doesn't exist
ERROR 1146 (42S02) at line 9: Table 'world.npc_spellclick_spells' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.event_scripts' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_dbc' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.page_text' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.game_event' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 11: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.spell_area' doesn't exist
ERROR 1146 (42S02) at line 10: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 46: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 16: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_loot_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 18: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_text' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 13: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 13: Table 'world.waypoint_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_transport' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.quest_template' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 7: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.quest_start_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gameobject_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.item_template' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_dbc' doesn't exist
ERROR 1146 (42S02) at line 11: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 17: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_ranks' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.spelldifficulty_dbc' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_bonus_data' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 34: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 9: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.npc_text' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.creature_template_addon' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 86: Table 'world.spell_linked_spell' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.gameobject_questrelation' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.gameobject' doesn't exist
ERROR 1146 (42S02) at line 16: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.reference_loot_template' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist
ERROR 1146 (42S02) at line 2: Table 'world.game_graveyard_zone' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.script_texts' doesn't exist
ERROR 1146 (42S02) at line 4: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 19: Table 'world.smart_scripts' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'world.gossip_menu' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'world.spell_script_names' doesn't exist


Logo, na hora de rodar o worldserver deu:

Código:

Using configuration file /home/wow/server/etc/worldserver.conf.
Using SSL version: OpenSSL 0.9.8o 01 Jun 2010 (library: OpenSSL 0.9.8o 01 Jun 2010)
Using ACE version: 5.7.7
TrinityCore rev. 2012-07-03 12:35:06 +0200 (537caf33e9ee+) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                      __
/\__  _\      __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
  \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
    \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/  \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                C O R E  /\___/
                                              \/__/

Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.1.63
MySQL server ver: 5.1.63-0+squeeze1
[ERROR]: In mysql_stmt_prepare() id: 1, sql: "DELETE FROM linked_respawn WHERE guid = ?"
[ERROR]: Table 'world.linked_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 2, sql: "REPLACE INTO linked_respawn (guid, linkedGuid) VALUES (?, ?)"
[ERROR]: Table 'world.linked_respawn' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 6, sql: "DELETE FROM gameobject WHERE guid = ?"
[ERROR]: Table 'world.gameobject' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 7, sql: "DELETE FROM game_event_gameobject WHERE guid = ?"
[ERROR]: Table 'world.game_event_gameobject' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 8, sql: "INSERT INTO game_graveyard_zone (id, ghost_zone, faction) VALUES (?, ?, ?)"
[ERROR]: Table 'world.game_graveyard_zone' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 9, sql: "DELETE FROM game_graveyard_zone WHERE id = ? AND ghost_zone = ? AND faction = ?"
[ERROR]: Table 'world.game_graveyard_zone' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 10, sql: "INSERT INTO game_tele (id, position_x, position_y, position_z, orientation, map, name) VALUES (?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.game_tele' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 11, sql: "DELETE FROM game_tele WHERE name = ?"
[ERROR]: Table 'world.game_tele' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 12, sql: "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost) VALUES(?, ?, ?, ?, ?)"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 13, sql: "DELETE FROM npc_vendor WHERE entry = ? AND item = ?"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 22, sql: "INSERT INTO waypoint_data (id, point, position_x, position_y, position_z) VALUES (?, ?, ?, ?, ?)"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 23, sql: "DELETE FROM waypoint_data WHERE id = ? AND point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 24, sql: "UPDATE waypoint_data SET point = point - 1 WHERE id = ? AND point > ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 25, sql: "UPDATE waypoint_data SET position_x = ?, position_y = ?, position_z = ? where id = ? AND point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 26, sql: "UPDATE waypoint_data SET wpguid = ? WHERE id = ? and point = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 27, sql: "UPDATE waypoint_data SET wpguid = 0"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 44, sql: "INSERT INTO waypoint_scripts (guid) VALUES (?)"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 45, sql: "DELETE FROM waypoint_scripts WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 46, sql: "UPDATE waypoint_scripts SET id = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 47, sql: "UPDATE waypoint_scripts SET x = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 48, sql: "UPDATE waypoint_scripts SET y = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 49, sql: "UPDATE waypoint_scripts SET z = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 50, sql: "UPDATE waypoint_scripts SET o = ? WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 53, sql: "INSERT INTO creature_transport (guid, npc_entry, transport_entry,  TransOffsetX, TransOffsetY, TransOffsetZ, TransOffsetO) values (?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.creature_transport' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 54, sql: "UPDATE creature_transport SET emote = ? WHERE transport_entry = ? AND guid = ?"
[ERROR]: Table 'world.creature_transport' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 64, sql: "DELETE FROM game_event_creature WHERE guid = ?"
[ERROR]: Table 'world.game_event_creature' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 65, sql: "DELETE FROM game_event_model_equip WHERE guid = ?"
[ERROR]: Table 'world.game_event_model_equip' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 66, sql: "INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
[ERROR]: Table 'world.gameobject' doesn't exist
MySQL client library: 5.1.63
MySQL server ver: 5.1.63-0+squeeze1
[ERROR]: In mysql_stmt_prepare() id: 0, sql: "SELECT entry, pool_entry FROM pool_quest"
[ERROR]: Table 'world.pool_quest' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound FROM creature_text"
[ERROR]: Table 'world.creature_text' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 4, sql: "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link"
[ERROR]: Table 'world.smart_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 5, sql: "SELECT entry, pointid, position_x, position_y, position_z FROM waypoints ORDER BY entry, pointid"
[ERROR]: Table 'world.waypoints' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 14, sql: "SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = ? ORDER BY slot ASC"
[ERROR]: Table 'world.npc_vendor' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 28, sql: "SELECT MAX(id) FROM waypoint_data"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 30, sql: "SELECT point, position_x, position_y, position_z FROM waypoint_data WHERE id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 31, sql: "SELECT position_x, position_y, position_z FROM waypoint_data WHERE point = 1 AND id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 32, sql: "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 33, sql: "SELECT id, point FROM waypoint_data WHERE wpguid = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_flag, action, action_chance FROM waypoint_data WHERE wpguid = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 35, sql: "SELECT MAX(point) FROM waypoint_data WHERE id = ?"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 36, sql: "SELECT id, point FROM waypoint_data WHERE (abs(position_x - ?) <= ?) and (abs(position_y - ?) <= ?) and (abs(position_z - ?) <= ?)"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 37, sql: "SELECT wpguid FROM waypoint_data WHERE id = ? and wpguid <> 0"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 38, sql: "SELECT DISTINCT action FROM waypoint_data"
[ERROR]: Table 'world.waypoint_data' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 39, sql: "SELECT MAX(guid) FROM waypoint_scripts"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 51, sql: "SELECT id FROM waypoint_scripts WHERE guid = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 57, sql: "SELECT guid, delay, command, datalong, datalong2, dataint, x, y, z, o FROM waypoint_scripts WHERE id = ?"
[ERROR]: Table 'world.waypoint_scripts' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 58, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"
[ERROR]: Table 'world.ip2nationCountries' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 59, sql: "SELECT entry FROM item_template WHERE name = ?"
[ERROR]: Table 'world.item_template' doesn't exist
[ERROR]: In mysql_stmt_prepare() id: 61, sql: "SELECT guid, id, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM gameobject WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? ORDER BY order_"
[ERROR]: Table 'world.gameobject' doesn't exist
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

Cannot connect to world database 127.0.0.1;3306;<login>;<senha>;world

E note que na última linha ele diz que não foi possivel conectar na world database. Sendo que já verifiquei no .conf e tá tudo certinho, tanto o host, quanto o login e a senha.

FooFKnight escreveu:Olá Marcelo
Bom Este erro seu é porque sua Data Base "World" está Faltando Alguns Arquivos !
Recomendo você ah das Restore em sua Data Base "World" Novamente Só assim Sera Solucionado o seu Pequeno Erro !
Resolvido?
Atenciosamente, FooFKnight

brianun escreveu:a database que você diz é pelo navicat foof ?


FooFKnight escreveu:Tanto Faz Navicat ou SQLyog.
Você tem que Deletar a que você tem que e Restaurar ah Nova "World"
Resolvido?

Nossa, faz assim, salva as base, AUTH e CHARACTES, se ambas não estiver com erros, apos isso, deleta a base WORLD e reinicia tua maquina, apos isso, faz um repare em sua maquina com algum sistema de limpa erros no windows e depois reinicia novamente, apos isso, baixa o repack e coloca a base WORLD novamente, por que isso ? é um erro que da no windows, todos os windows faz isso, tem base que ainda roda, mas se você troca ela, você perde seus dados.
Recomendo: CCleaner 3.20.1750

DeltaServers


Mensagens : 373
Pontos : 380

Ver perfil do usuário https://www.deltaservers.com.br

Voltar ao Topo Ir em baixo

Re: TrinityCore - Faltam tabelas na database World

Mensagem por Conteúdo patrocinado Hoje à(s) 13:17


Conteúdo patrocinado


Voltar ao Topo Ir em baixo

Ver o tópico anterior Ver o tópico seguinte Voltar ao Topo


 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum