Hi, there.
I used to have a 3.3.5a Server running on my computer with my own character created and everything worked quite fine.
Now I found that TrinityCore has advanced to version 4.3.4 and wanted to upgrade my Server as well.
So I refered to the manual at
http://collab.kpsn.org/pages/viewpage.action?pageId=1704351
I downloaded the DB Repository
"TrinityCore_4.3.4_DB_Alpha.git"
and also the TDB Full SQL Script
"TDB_full_434.05_2013_07_17.sql"
As it was described in the manual
I created a new world database and
imported first the TDB Full SQL Script and
then generated the "world_update.sql" Script with the merge_linux.sh Script and imported it into the database.
Then I configured my Server with the new database but on start-up it gives me a SQL 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, unit_flags2, 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 = ?"
Unknown column 'trainer_spell' 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 'wow_world_4-3-4.ip2nationCountries' doesn't exist
"
Seems as if there is missing something.
I would love if someone who knows or has experienced the same could give me a hint.