Ubuntu 17.10 x64. Fresh clone of the 3.3.5 branch. I've let the worldserver create its own world database from scratch, and this is what it tells me:
TrinityCore rev. bc1f456125c1 2018-11-14 22:57:06 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
Using SSL version: OpenSSL 1.0.2g 1 Mar 2016 (library: OpenSSL 1.0.2g 1 Mar 2016)
Using Boost version: 1.62.0
Updating Auth database...
>> Auth database is up-to-date! Containing 2 new and 42 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 1 new and 31 archived updates.
Updating World database...
>> World database is up-to-date! Containing 32 new and 4037 archived updates.
In mysql_stmt_prepare() id: 55, 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, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?"
Unknown column 'trainer_type' in 'field list'
Could not prepare statements of the World database, see log for details.
Now, the funny thing is, if I don't put a TDB_full_world file in the bin directory, it grumbles about how it explicitly wants a 'TDB_full_world_335.64_2018_02_19.sql' file. If I give it this file, which I am under the impression is a little outdated, I get the error above. There is a newer TDB_full_world file, TDB_full_world_335.19041_2019_04_15.sql. Which if I put in the bin directory, is ignored. In my TrinityCore directory, the revision_data.h.in.cmake file references this newer sql file. I'm not sure why a freshly compiled worldserver would ask for this older sql file. (Manually applying this newer sql file, and all the updates thereafter, also doesn't work. but I know it's best to let the worldserver process do the updating, so manually doesn't really count.)
What's the dumb thing I'm missing, making me look especially dumb?
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
I am really sorry to have to ask, but here goes.
Ubuntu 17.10 x64. Fresh clone of the 3.3.5 branch. I've let the worldserver create its own world database from scratch, and this is what it tells me:
TrinityCore rev. bc1f456125c1 2018-11-14 22:57:06 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
Using SSL version: OpenSSL 1.0.2g 1 Mar 2016 (library: OpenSSL 1.0.2g 1 Mar 2016)
Using Boost version: 1.62.0
Updating Auth database...
>> Auth database is up-to-date! Containing 2 new and 42 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 1 new and 31 archived updates.
Updating World database...
>> World database is up-to-date! Containing 32 new and 4037 archived updates.
In mysql_stmt_prepare() id: 55, 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, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?"
Unknown column 'trainer_type' in 'field list'
Could not prepare statements of the World database, see log for details.
Now, the funny thing is, if I don't put a TDB_full_world file in the bin directory, it grumbles about how it explicitly wants a 'TDB_full_world_335.64_2018_02_19.sql' file. If I give it this file, which I am under the impression is a little outdated, I get the error above. There is a newer TDB_full_world file, TDB_full_world_335.19041_2019_04_15.sql. Which if I put in the bin directory, is ignored. In my TrinityCore directory, the revision_data.h.in.cmake file references this newer sql file. I'm not sure why a freshly compiled worldserver would ask for this older sql file. (Manually applying this newer sql file, and all the updates thereafter, also doesn't work. but I know it's best to let the worldserver process do the updating, so manually doesn't really count.)
What's the dumb thing I'm missing, making me look especially dumb?