Bonjour à tous,
Je souhaite monter un serveur privée 2.4.3, aucunement pour un but lucratif, juste pour jouer avec deux-trois amis /emoticons/default_smile.png (Nous jouons tous sur officiel en même temps)
J’ai donc suivi le howto officiel Trinity, seul probleme au moment de trouver les db, suites à de multes recherches je tombe sur ce qui semble être le core final 2.4.3, mais … après instalation des script … j’arrive à lancer authserver mais lorsque je lance worldserver tout un tas d’erreur mysql, des bases qui n’existent pas etc …
In mysql_stmt_prepare() id: 1, sql: “DELETE FROM linked_respawn WHERE guid = ?”
Table ‘world.linked_respawn’ doesn’t exist
In mysql_stmt_prepare() id: 2, sql: “REPLACE INTO linked_respawn (guid, linkedGu id) VALUES (?, ?)”
Table ‘world.linked_respawn’ doesn’t exist
In mysql_stmt_prepare() id: 53, sql: “INSERT INTO creature_transport (guid, npc_ entry, transport_entry, TransOffsetX, TransOffsetY, TransOffsetZ, TransOffsetO) values (?, ?, ?, ?, ?, ?, ?)”
Table ‘world.creature_transport’ doesn’t exist
In mysql_stmt_prepare() id: 54, sql: “UPDATE creature_transport SET emote = ? WH ERE transport_entry = ? AND guid = ?”
Table ‘world.creature_transport’ doesn’t exist
In mysql_stmt_prepare() id: 64, sql: “INSERT INTO creature (guid, id , map, spaw nMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, ori entation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, Movemen tType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘phaseMask’ in ‘field list’
In mysql_stmt_prepare() id: 67, sql: “INSERT INTO gameobject (guid, id, map, spa wnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, r otation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”
Unknown column ‘phaseMask’ in ‘field list’
In mysql_stmt_prepare() id: 69, sql: “INSERT INTO disables (entry, sourceType, f lags, comment) VALUES (?, ?, ?, ?)”
Table ‘world.disables’ doesn’t exist
In mysql_stmt_prepare() id: 70, sql: “DELETE FROM disables WHERE entry = ? AND s ourceType = ?”
Table ‘world.disables’ doesn’t exist
In mysql_stmt_prepare() id: 0, sql: “SELECT entry, pool_entry FROM pool_quest”
Table ‘world.pool_quest’ doesn’t exist
In mysql_stmt_prepare() id: 3, sql: “SELECT entry, groupid, id, text, type, lang uage, probability, emote, duration, sound FROM creature_text”
Table ‘world.creature_text’ doesn’t exist
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_par am2, event_param3, event_param4, action_type, action_param1, action_param2, acti on_param3, action_param4, action_param5, action_param6, target_type, target_para m1, target_param2, target_param3, target_x, target_y, target_z, target_o FROM sm art_scripts ORDER BY entryorguid, source_type, id, link”
Table ‘world.smart_scripts’ doesn’t exist
In mysql_stmt_prepare() id: 5, sql: “SELECT entry, pointid, position_x, position _y, position_z FROM waypoints ORDER BY entry, pointid”
Table ‘world.waypoints’ doesn’t exist
In mysql_stmt_prepare() id: 14, sql: “SELECT item, maxcount, incrtime, ExtendedC ost FROM npc_vendor WHERE entry = ? ORDER BY slot ASC”
Unknown column ‘slot’ in ‘order clause’
In mysql_stmt_prepare() id: 29, sql: “SELECT point, position_x, position_y, posi tion_z, orientation, move_flag, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point”
Unknown column ‘orientation’ in ‘field list’
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”
Unknown column ‘orientation’ in ‘field list’
In mysql_stmt_prepare() id: 56, sql: “SELECT difficulty_entry_1, difficulty_entr y_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, fac tion_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_cl ass, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resista nce3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spe ll5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName , MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, Racia lLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, Scrip tName FROM creature_template WHERE entry = ?”
Unknown column ‘difficulty_entry_1’ in ‘field list’
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 "
Table ‘world.ip2nationCountries’ doesn’t exist
In mysql_stmt_prepare() id: 68, sql: “SELECT entry FROM disables WHERE entry = ? AND sourceType = ?”
Table ‘world.disables’ 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 localhost;3306;trinity;******;world
Donc pour moi le souci viens des db, mais je ne comprends pas pourquoi il manque des tables, alors que c’est la version finale pour 2.4.3, peut être me suis-je trompé ailleurs ?
Informations:
OS: Ubuntu Server 12.04 LTS
MySQL: 5.5.28
ACE: 6.0.3
Et si quelqu’un peut m’expliquer la difference (si il y’en a une) entre ce que “vous” appelez core et les db ?