View Full Version : [SOLVED] 4.3.4 Worldserver Error's ( Linux Debian )

12-05-2013, 12:21 PM
Hello ppl i got some error's in my worldserver.
I put all the sql files.

Core: https://github.com/TrinityCore/TrinityCore/tree/4.3.4
Sql: http://www.trinitycore.org/f/files/download/9-tdb-full-434/
Sql updates: https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha

I think the whole lesson I complied properly: http://collab.kpsn.org/pages/viewpage.action?pageId=1704351

My error's

Using configuration file /home/wow/server2/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.0.3
TrinityCore rev. 5da508c0a0e2 2013-12-04 14:43:35 -0330 (master branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/

DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database;3306;root;daniell;world

In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
In mysql_stmt_prepare() id: 54, 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, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'trainer_spell' in 'field list'

Please help, I'm trying a few days and do not know what to do anymore. I have read thousands of topics not already know.

Thank you in advance!

12-05-2013, 01:45 PM
Your core seems to be compiled properly. You miss updates in your databases. Apply all of these:


12-05-2013, 02:08 PM
I rly put it but again this error.

12-05-2013, 02:21 PM
Download this db:


12-05-2013, 04:28 PM
Go into your source directory under sql updates and go into all 3 -> auth, characters and world.
If you're on linux just do: "cat * >> all.sql" (without quotes) in each directory then just run the queries.

12-05-2013, 05:42 PM
The main problem on TrinityCore is that they just throw their SQL updates in the sql/ folder and expect you to track down the needed updates to query them. There's a 'old' folder with SQL updates thrown in there too, which could be vital to your search for these updates. They honestly should've kept the MaNGOS system which tells you what SQL update you need before launching the world.

Now, here are the specific sql updates you need:

creature_template column update: https://github.com/TrinityCore/TrinityCore/blob/4.3.4/sql/old/4.3.4/2013_01_29_00_world_creature_template_434.sql
command column update: https://github.com/TrinityCore/TrinityCore/blob/4.3.4/sql/updates/world/2013_08_30_01_world_command.sql