[Guide] How to compile TrinityCore, Start to Finish

[mwood100]

The fact that it said 8 successful but didn't have 2 failed is weird.
If everything compiled okay (no failed), then I guess you should be fine.

About the database, you can try SQLyog, some people have reported that it executes queries much faster than navicat.

hey thanks for quick reply, and that does seem strange so idk and i was wondering if id be able to use heidiSQL? cause thats what i used on my acremu based server prior to moving to trinity, if not ill jsut go ahead and download SQLyog thanks in advance once more

[schexyp]

Very nice, quick and simple. Approved to my liking =)

[mwood100]

i think i found my problem, i completed restarted the process and after THG finished last night i only downloaded 40xx files while this time i downloaded 46xx files and while compiling there were 10 "items" to compile instead of the 8 that i had last time so that maybe why there were only 8 successful, thanks for the guide! +rep for sure, keep up the good work

[mwood100]

-_- sorry for the millions of posts here -_- but i figured out i just needed to update wow for my last post, i created an account but when i log in it gets to "authenticating" then it says "you have been disconnected from the server" any ideas?

Mwood100

[shadowman465]

Hey very nice guide but when I start up Worldserver.exe it give me this

2010-07-21 19:00:49 Using configuration file worldserver.conf.
2010-07-21 19:00:49 TrinityCore Rev: 8972 Release Hash: d1f87300fb8f (Win32,little-endian) (core-daemon)
2010-07-21 19:00:49 <Ctrl-C> to stop.

2010-07-21 19:00:49  ______                       __
2010-07-21 19:00:49 /\__  _\       __          __/\ \__
2010-07-21 19:00:49 \/_/\ \/ _ __ /\_\    ___ /\_\ \ ,_\  __  __
2010-07-21 19:00:49    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2010-07-21 19:00:49     \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2010-07-21 19:00:49      \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
2010-07-21 19:00:49       \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
2010-07-21 19:00:49                                  C O R E  /\___/
2010-07-21 19:00:49 http://TrinityCore.org                    \/__/

2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 Realm running as realm ID 1
2010-07-21 19:00:49 Using World DB: TDB 335.10.32
2010-07-21 19:00:49 Using creature EventAI: ACID 3.0.4 - Final Release for Trinity (3.3.2 Client)
2010-07-21 19:00:49 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2010-07-21 19:00:49 Using DataDir ./
2010-07-21 19:00:49 WORLD: VMap support included. LineOfSight:1, getHeight:1
2010-07-21 19:00:49 WORLD: VMap data directory is: ./vmaps
2010-07-21 19:00:49 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2010-07-21 19:00:50 
2010-07-21 19:00:50 Loading Trinity strings...
2010-07-21 19:00:50 
2010-07-21 19:00:50 >> Loaded 848 Trinity strings from table trinity_string
2010-07-21 19:00:50 Initialize data stores...
2010-07-21 19:00:51 ERROR: SQL and DBC format strings are not matching for table: 'spell_dbc'
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 71356 at field id:2108 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 71803 at field id:2108 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72111 at field id:2136 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72125 at field id:2136 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 70816 at field id:2146 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72233 at field id:2146 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72234 at field id:2146 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72235 at field id:2146 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: 
Some required *.dbc files (1 from 89) not found or not compatible:
./dbc/Spell.dbc (exist, but have 234 fields instead 234) Wrong client version DBC file?

[myran2]

Hey very nice guide but when I start up Worldserver.exe it give me this

2010-07-21 19:00:49 Using configuration file worldserver.conf.
2010-07-21 19:00:49 TrinityCore Rev: 8972 Release Hash: d1f87300fb8f (Win32,little-endian) (core-daemon)
2010-07-21 19:00:49 <Ctrl-C> to stop.

2010-07-21 19:00:49  ______                       __
2010-07-21 19:00:49 /\__  _\       __          __/\ \__
2010-07-21 19:00:49 \/_/\ \/ _ __ /\_\    ___ /\_\ \ ,_\  __  __
2010-07-21 19:00:49    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2010-07-21 19:00:49     \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2010-07-21 19:00:49      \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
2010-07-21 19:00:49       \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
2010-07-21 19:00:49                                  C O R E  /\___/
2010-07-21 19:00:49 http://TrinityCore.org                    \/__/

2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 MySQL client library: 6.0.0
2010-07-21 19:00:49 MySQL server ver: 5.1.48-community 
2010-07-21 19:00:49 Realm running as realm ID 1
2010-07-21 19:00:49 Using World DB: TDB 335.10.32
2010-07-21 19:00:49 Using creature EventAI: ACID 3.0.4 - Final Release for Trinity (3.3.2 Client)
2010-07-21 19:00:49 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2010-07-21 19:00:49 Using DataDir ./
2010-07-21 19:00:49 WORLD: VMap support included. LineOfSight:1, getHeight:1
2010-07-21 19:00:49 WORLD: VMap data directory is: ./vmaps
2010-07-21 19:00:49 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2010-07-21 19:00:50 
2010-07-21 19:00:50 Loading Trinity strings...
2010-07-21 19:00:50 
2010-07-21 19:00:50 >> Loaded 848 Trinity strings from table trinity_string
2010-07-21 19:00:50 Initialize data stores...
2010-07-21 19:00:51 ERROR: SQL and DBC format strings are not matching for table: 'spell_dbc'
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 71356 at field id:2108 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 71803 at field id:2108 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72111 at field id:2136 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72125 at field id:2136 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 70816 at field id:2146 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72233 at field id:2146 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72234 at field id:2146 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: spelldifficulty_dbc: spell 72235 at field id:2146 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
2010-07-21 19:00:51 ERROR: 
Some required *.dbc files (1 from 89) not found or not compatible:
./dbc/Spell.dbc (exist, but have 234 fields instead 234) Wrong client version DBC file?

You didn't apply your SQL updates

---------- Post added at 08:53 PM ---------- Previous post was at 08:51 PM ----------

-_- sorry for the millions of posts here -_- but i figured out i just needed to update wow for my last post, i created an account but when i log in it gets to "authenticating" then it says "you have been disconnected from the server" any ideas?

Mwood100

uhhh. That's a toughie. That normally means the authentication seeds aren't updated unless there was a new patch today, that's impossible.
All I can say is make sure you're on wow patch 3.3.5a and are using the latest rev of trinitycore.

[shadowman465]

Wow your fast :O I guess I skipped that part xD
-Thanks alot

[mwood100]

OOOOOH 3.3.5a okay im only at 3.3.5 that may be the issue thanks a ton

[myran2]

OOOOOH 3.3.5a okay im only at 3.3.5 that may be the issue thanks a ton

Yep, that's the issue. Authentication changed in 3.3.5a :P

[shadowman465]

Is there a way to make it so you have to launch MYsql from the server folder to get it running so its like a repack? Or if you do that can you not update it or something?

-Thanks

[myran2]

Is there a way to make it so you have to launch MYsql from the server folder to get it running so its like a repack? Or if you do that can you not update it or something?

-Thanks

It's just a mess running it out of a batch file, you can't use MySQL from the command line and you miss out on some other features and for what? Something that's just a TINY bit easier?

[V1cTorY]

Could you run me through the part where you release the files in Visual Studio, since i had to download visual studio 10 its a bit different arrangement of buttons.

[myran2]

Could you run me through the part where you release the files in Visual Studio, since i had to download visual studio 10 its a bit different arrangement of buttons.

It WILL NOT work with Visual Studio 2010, you NEED Visual Studio 2008

[V1cTorY]

[/COLOR]

It WILL NOT work with Visual Studio 2010, you NEED Visual Studio 2008

Yeah, i just figured that out and installed visual studio 2008, one more question, while trying to execute the DB it is taking forever so i tried your other way through a command prompt but it keeps saying mysql is not a recognized command. any tips?

[Octagonmodz]

Ok, so i the whole extracting the DB , im trying to do the command in CMD but im getting this error

C:\Users\Dylan>mysql -u root -p ascent -D world2 < C:TDB_335.10.32_8874.sql
'mysql' is not recognized as an internal or external command,
operable program or batch file.