bury

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!

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 ¬¬

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...

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.

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'

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.

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.

downgrade the mysql worked for the moment. Thanks!

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!

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!!