Problem nach Update

ja hab ich die dbs von meinem repack rauf getan wo kann ich mir die alten nochmal runterladen also world characters usw alles was ich brauche und sag mir wo ichs rein tun soll bitte

ahja wie kann ich den mysql server von der trintiycore starten?

/reported

Weswegen denn? cO

…wahrscheinlich deswegen ?

Is doch wummpe.

[CODE]2012-04-16 19:28:32 Using configuration file worldserver.conf.

2012-04-16 19:28:32 Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)

2012-04-16 19:28:32 Using ACE version: 5.8.3

2012-04-16 19:28:32 TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win64, Release) (worldserver-daemon)

2012-04-16 19:28:32 to stop.

2012-04-16 19:28:32 ______ __

2012-04-16 19:28:32 /__ _\ __ _/\ _

2012-04-16 19:28:32 /_/\ / _ __ /_\ ___ /_\ , _\ __ __

2012-04-16 19:28:32 \ \ /`‘__/\ \ /’ _ `/\ \ \ / /\ /\ \

2012-04-16 19:28:32 \ \ \ \ / \ \ /\ /\ \ \ \ \ _\ \ _\ \

2012-04-16 19:28:32 \ _\ _\ \ _\ _\ _\ _\ _\/`___ \

2012-04-16 19:28:32 //// ////////// `/_/> \

2012-04-16 19:28:32 C O R E /___/

2012-04-16 19:28:32 http://TrinityCore.org /__/

2012-04-16 19:28:32 ERROR: DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

2012-04-16 19:28:32 ERROR: Cannot connect to world database 127.0.0.1;3306;root;46Lo42tR;world[/CODE]


2012-04-16 23:37:47 Opening DatabasePool 'world'. Asynchronous connections: 1, synchronous connections: 1.

2012-04-16 23:37:47 MySQL client library: 5.5.16

2012-04-16 23:37:47 MySQL server ver: 5.5.16

2012-04-16 23:37:47 MySQL client library: 5.5.16

2012-04-16 23:37:47 MySQL server ver: 5.5.16

2012-04-16 23:37:47 [ERROR]: In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"

2012-04-16 23:37:47 [ERROR]: Unknown column 'HoverHeight' in 'field list'

2012-04-16 23:37:47 [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"

2012-04-16 23:37:47 [ERROR]: Table 'world.ip2nationcountries' doesn't exist

Hast du auch alle Sql Updates eingespielt? Soweit ich das sehe, fehlt dir in der creature_template die splate ‘HoverHeight’. Sowie die tabelle ip2nationcountries.

Überprüf nochmals ob du auch alle sqls eingespielt hast und spiel die fehlenden ggf. ein.

Mein prob ist, dass mir mein Heidi SQL beim einspielen der updates 2 Fehler schreit.

  1. Latency tabel ist bereits vorhanden (auth updates)

  2. OS tabel ist bereits vorhanden (world updates)

Welche “2 Updates” spielst Du denn ein?

https://github.com/T…re_template.sql

https://github.com/T…d_ip2nation.sql

hinzufügen…

dann ist dein fehler behoben…

am besten trintiydb neu machen… und richtig updaten