[Compile or cmake problems]

Did you remember to change the field in the auth.realmlist table?

 

Hello, that table was in 127.0.0.1, thought that changing my realmlist to the local net of my laptop, it would run properly but nope, I couldnt enter the kingdom. 

 

 

What I did is put the public ip in the normal adress of tha table, and then the local ip of my laptop in the local adress and open the ports. Now it seems it works properly.

 

Your guide in the wiki is really well explained.

 

Thanks you!

[Compile or cmake problems]

Hello again!

 

I setup everything following your wiki guide, and apparently everything works without problems.

 

I setup EVERYTHING on my laptop, and i'm trying to play on my desktop computer. The realmlist in the db (on my laptop) is set as 127.0.0.1, and in my realmlist.wtf (on my desktop computer) is set as the local ip of my laptop (192.168.x.xx).

 

I created an account as test/test, and gave it gm level 3.

 

When I try to connect it it says: Correct, and it lets me choose the kingdom (named by default trinity) and when I click accept it says "accessing a game server" and it returns to the kingdom choosing. Its like I can't enter the kingdom.

 

Should I do everything else with the realmlist? I didnt receive any error while the server setup (compile, db, etc), and I extracted maps, dbc, vmaps and mmaps. Followed all steps one by one.

 

Thanks!

 

Edit: Ok, in my laptop works properly... dont know why it doesnt work in my desktop pc ¬¬

[Compile or cmake problems]

Thanks @Nay, I'll comment if I've finally got it with your guide. 

 

I've merged all the sql updates in one file (I understood that in your words) and it gave me that error of columnes...

[Compile or cmake problems]

To get the world DB properly, you need to import TDB_full_335.55_2014_08_24.sql and all the sqls files in the folder sqlupdatesworld. 

 

I got some errors doing this about columnes etc.... and with the comment of @paradox I think im done with this files I downloaded.

 

Then Para, can you tell me where the official guide is? I will try with that one, I should have started there first :S

 

Thanks.

[Compile or cmake problems]

So, follow the official guide, or, ask your questions of who ever made that crap.

LOL, luckily I don't know who you are and I didn't expect anything from you. However, Nay helped me without problems, and was really helpful for me.

 

You don't understand that the files are downloaded from this website, but renamed.... the update file is a merged file of the updates files of the db, and the db has been downloaded from here... As I said, I followed "the official guide", and that crap as you say is only a easy guide made by a good guy for people like me, who know programming but never tried with a wow server. If you don't want to help at least dont insult.

 

Thanks.

 

EDIT:

 

 

 

Ok, this is the DB error:

 

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction_A = ?, faction_H = ? WHERE entry = ?"

Unknown column 'faction_A' 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 'faction_A' in 'field list'

[Compile or cmake problems]

Sounds like you are running a repack, we don't support repacks, go ask whatever shady website you grabbed it from, or, compile your own.

 

Sorry, its just the datapack and the update file, from a tutorial im following, nothing special or repack, its just renamed so it was easier to import.

[Compile or cmake problems]

Okay, with that version of mysql I had no more problems with database (I removed it and started it from 0 to avoid problems).

 

I imported the db and the update file to world without problems. The same with the auth, and finally the same with the characters.

 

No problems with Cmake and compiling with VS 12 2013. 

 

No problems extracting maps and dbc, I disabled vmaps and the authserver started properly:

 

 

But now when im going to start the worldserver I get this error:

 

DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

Cannot connect to world database 127.0.0.1;3306;root;test1234;world

 

Ofc I edited the authserver.conf and the worldserver.conf this last one in the three ways:

 

#        Default:     "127.0.0.1;3306;trinity;trinity;auth"

 

LoginDatabaseInfo = "127.0.0.1;3306;root;test1234;auth"

 

----------------------------------------------------------------------

 

 

       Default:     "127.0.0.1;3306;trinity;trinity;auth"       - (LoginDatabaseInfo)

#                     "127.0.0.1;3306;trinity;trinity;world"      - (WorldDatabaseInfo)

#                     "127.0.0.1;3306;trinity;trinity;characters" - (CharacterDatabaseInfo)

 

LoginDatabaseInfo     = "127.0.0.1;3306;root;test1234;auth"

WorldDatabaseInfo     = "127.0.0.1;3306;root;test1234;world"

CharacterDatabaseInfo = "127.0.0.1;3306;root;test1234;characters"

 

DB error:

 

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction_A = ?, faction_H = ? WHERE entry = ?"

Unknown column 'faction_A' 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 'faction_A' in 'field list'

 

 

Thanks again.

[Compile or cmake problems]

downgrade the mysql worked for the moment. Thanks!

[Compile or cmake problems]

Okay as you say im trying to do the new enviroment variable. I'm compiling using Cmake 32 bits (a version of 64 bits woulnd't work, no?)

 

 

While I was finding a solution for that problem, I started doing the database part. I do without problems the World (global db) and the Auth part, but with the characters one I receive this error:

 

Error Code : 1071 Specified key was too long; max key length is 1000 bytes

 

 

I receive it in several tables and i'm using SQLyog.

 

http://pastebin.com/BLNLxbS0

 

 

Thanks for your help!

[Compile or cmake problems]

Hello, Im following a tutorial about trinitycore.

 

I downloaded the full version of OPENSSL.

 

- I downloaded the last version of CMAKE.

 

- I downloaded Microsoft Visual Studio 2013 Express.

 

- I downloaded the last datapack available (TrinityCore-TrinityCore-e85f73c)

 

- I'm not using git

 

I started receiving some errors, but I managed with all.

 

Yes, I received the error "No BOOST_ROOT environment variable could be found!" and fixed with: 

 

 

--

 

 

After selecting "i'm not using git", the work was finished and generated.

 

After this, I opened the file "TrinityCore.sln", selected release, and started the compiling solution.

 

The errors:

 

Error 1 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 shared

 

Error 2 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionManagementMMapManager.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 3 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionManagementMMapFactory.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 4 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionManagementVMapManager2.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 5 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionMapsMapTree.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 6 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionModelsGameObjectModel.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 7 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory (........srcservercollisionDynamicTree.cpp) C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 collision

 

Error 8 error C1083: Cannot open include file: 'boost/asio/buffer.hpp': No such file or directory C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedPacketsByteBuffer.h 35 1 game

 

Error 9 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 scripts

 

Error 10 error C1083: Cannot open include file: 'boost/property_tree/ptree.hpp': No such file or directory C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedConfigurationConfig.h 25 1 authserver

 

Error 11 error C1083: Cannot open include file: 'boost/asio/io_service.hpp': No such file or directory C:UsersburiDocumentswowtrinity coredatasourceTrinityCore-TrinityCore-e85f73csrcserversharedLoggingLog.h 26 1 worldserver

 

---------------

 

The only thing I could find is to rename the "CMakeLists.txt" for this:

set (ENV{BOOST_ROOT} "C:/Boost")

 

but I have already done that as you can see in the pic.

 

Hope I explained well, any help is good.

 

Thanks!!