World server cant start

[cliffsmits]

hello guys i have compiled with the latest version of eluna evreything worked well
auth server will run but the world server crash do somone know a solution how to fix it

i use my world database backup from the orginal trinitycore

 

[Foereaper]

Database structure is wrong

 

[cliffsmits]

i have run the updates for the world/auth/characters but it wont get online

In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT entry, 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, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, 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, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'BaseVariance' in 'field list'
In mysql_stmt_prepare() id: 29, sql: "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?"
Unknown column 'move_type' in 'field list'
In mysql_stmt_prepare() id: 54, sql: "SELECT entry, 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, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, 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, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'BaseVariance' in 'field list'

 

[kolakocide]

See, download the EDB, run all updates that are in there. If there are no updates to run, make a backup of the tables you want in your world database. If there is no World database in the EDB collection, get the latest Trinitycore DB files. Which should be 355.55. Inside the EDB folder, there is a file that will automatically run all updates in the Updates folder. So just copy and paste the whole selection. If this didn't put you in the right track or help at all, please give me a PM.

 

[cliffsmits]

i tried to run the updates i have runned this command "copy *.sql updates.sql" to make a sql for all the updates there where but when i run the updates there are 11 queries errors / not exist hopefully somone can help me futher this proces
i hope that my backup from the world table still can be used or fixed cause i made allot of custom content into it



they also said this to do but i dont really understand this

Wait, wait... you only need to run the individual updates, if you're compiling a commit that requires them.

Say for example, you pull (download) the "TDB 335.56 - 2014/09/21" commit here...

https://github.com/TrinityCore/Trini...6fd1e6ffbd556b, you import the "auth_database.sql" and "characters_database.sql" inside C:\Core\sql\base into the respective databases, you then download the full 333.56 Database (the updates inside this folder are only required to be run IF you are using an old DB version and want to update it). Otherwise you can just download "TDB_full_335.56_2014_09_21.7z" and run it on your world database using the source/commit that I posted above.

No updates needed at all... You can check the dates by clicking on the commit I sent "TDB 335.56 - 2014/09/21".

That's it man, really simple.