Reaper Trinity Core Installation Guide

Special Thanks to Wrath for creating this Reaper-X TrinityCore Installation Instruction, and that means full credits should be given to him ;)

First Things first!!! Pay attention to the instuctions directly do not vear off and think you know what your doing because you wouldnt be reading this if you knew what you was doing…jking but still stay to the instructions.

1. Install wow 2.4.3 and make sure you have the correct version I repeat 2.4.3. ok now off to the good stuff.

2. Download and install MYSQL follow the instructions that are provided for you on the page. Even if you have installed mysql before reread the instuctions and follow to a T.

3. After you have finished installing mysql download and install .net framework 3.5 SP1. This is also provided for you on the web page. If you have previous installations of MYSQL uninstall it and delete any sql folders left over and then reinstall.

4. Now download the Trinity Core 595 SD2 809 (Trinity/UDB ONLY) FULL | 18.0 MB | Rapidshare (or from any mirror you choose) and then extract it. I usually extract it to the desktop. you can extract it by double clicking on the file.

5.After you get the mysql loaded and configured there are some changes that you have to make. go to your desktop folder called Reaper-X Trinity Rev 1 and then open it. then open the folder labeled install database.Now right click on the Install Reaper-X Trinity.bat file and edit it in notepad. you must add qotes as seen below.. Also you must make sure that the correct path is typed for where the bin file is located.What you see below is my path make sure you type your path.After your done editing this file save and close it.

REM #################################################### REM # MySQL HOST PATH - MySQL Server Path REM # EXAMPLE: C:\Program Files\MySQL Community 5.0\bin REM #################################################### set mysqlpath="c:\Program Files\mysql\MySQLServer5.0\bin" <--notice the qoutes in the path.

6. Now open the Reaper-X Trinity Rev 1 folder that is located on your desktop. Hang in there were getting to the good parts.

7. You should see a bunch of files and 4 folders when you open it up.

8. The first thing we want to do when we get this folder open is fill the folder that says data with the correct stuff. If you open the data folder up you will see three folders. DBC ,maps and Vmaps. DBC is already filled with the correct stuff, dont touch, delete or anything right now. If you open maps and Vmaps the folders are empty and that is ok. We are going to fill them with the correct data.

9. Close out of the Data windows that you have open so that you are back at your desktop and reopen the Reaper-X Trinity Rev 1 folder.Now open the extractors folder. You should see a folder and a file. Folder named vmap extractor and assembler. and a file named map and DBC extractor.exe.

10. Open the vmap extractor and assembler folder and you should see 4 files in there. Copy all 4 files and then paste them into your c:\program files\world of warcraft\data\enus directory and then run the RUN ME FOR VMAPS!.bat file. This will create the VMAPS folder. this may take a while so just wait till it tells you it is done.

11. Ok after Vmaps are created copy the folder name vmaps that has now been created, into the Reaper-X Trinity Rev 1 folder under the data folder. This is where the three folders are that I talked about earlier (maps,vmaps,dbc). copy all the contents from vmaps into the folder named vmaps in there. So now you should have a filled dbc folder and a filled vmaps folder in there. the maps folder is empty still but we are going to add data in a minute in there also.

12. Ok now we need to put data into the map folder so the way to do that is go to Reaper-X Trinity Rev 1 (on your dekstop) folder again and go to extractors. copy the map and dbc extractor.exe file to the c:\program files\world of warcraft folder and paste it there. now run the maps and dbc extractor.exe file. This will start to install the maps to a folder called maps. see how easy that is. Once it is done you now need to open the maps folder it created and copy the contents or data, and then paste it into the folder called maps located in the Reaper-X Trinity Rev 1\data\maps folder (you know the folder on your dekstop). now the DBC, VMAPS and MAPS folder all have data in them. YAY!!!

13. Now you need to move those folders to the correct location. Go to your c:\drive and make a folder there on the root called WOW. now open the wow folder you just created and make another folder in there called DATA. Now open the DATA folder you just created. Now go to your desktop and inside your Reaper-X Trinity Rev 1 folder open the data folder. You should see the three folders in there (maps,vmaps and DBC) copy all three folders into the DATA folder we just created previously. so when done you should have 3 folders in you c:\wow\data path. maps,vmaps and DBC should be in there.

14. Now you need to run the Install Reaper-X Trinity.bat file(located in the Reaper-X Trinity Rev 1 folder on your desktop under the install database folder. Run this file and it will take a while for this too run.

15. once it is done it should close on its own if not hit any key and it should close.

16. Now you need to download Navicat program. this will allow you to edit the sql files. after downloading Navicat make a new connection and name it whatever you want.username should be root or whatever you made it when you set SQl up. Put your password in whatever you made the password.Click test and it should be sucessful. Now open the realmd tables and then go to realmlist. once you open realmlist you will see a table probably empty and this is where you need to add your realm name. Put your realm name where it says realm name and then put your IP address where it says ip address(127.0.0.1). The ID should be 1. close Navicat out.

17. Now go back to your desktop and open the trinityrealm.exe file and you should see your realm listed in there.

18. Now open click on the trinitycore.exe file and it should start scripting, let it run.

19. Once it is finished you now need to create an account so you can play. Hit enter to get a command prompt. Type account create (login name anything you want) (your password). Hit enter it should say account created.

20. Now if you want Gm power in which im sure you do type account set gm (username) 3 and hit enter. should have a GM account now.

21. Now you need to create the TBC (The burning Crusade) addon so you can play in the Burning Crusade area. Type account set addon (Your username) 1.

22. Navigate to c:\program files\world of warcraft. Look for the realmlist.wtf file. right click on it and click on edit. Should open a notepad. Now take everything out of there and type “set realmlist 127.0.0.1″ without the quotes. Save and close.

22. You can now open Wow and type your username and Password and login to your realm and play as a GM.

Comments Navigation « Previous 1 2 3 4 ... 6 Next »

confused said Jan 13, 2009 at 5:15 am

thats just it they won’t run i get application has failed to start becouse msvcr71.dll was not found

Link to this comment Reply to this comment
wrath said Jan 13, 2009 at 4:41 am

@ confused,

Confused on your desktop is you folder that you downloaded all the reaper files in. In that folder are 2 files that you need to run by double clicking on them. Trinityrealm.exe and trinitycore.exe. run both of them. The realm is real quick when it comes up. It shows you the name of your realm and so forth. leave it up when you open it. Now the trinitycore.exe takes a little longer to run (should see scripts running) once it’s done it should be to let you know its done. Just watch in case you didnt activate the beep. you will know when its done. Now leave both of those windows up anytime you want to play the game. any questions write back.

Link to this comment Reply to this comment
confused said Jan 13, 2009 at 2:57 am

Ok i started over and everything works except when i get done with running navicat i close it out i go to my trinity folder im not sure about 17 and 18 i can’t seem to get that to work

Link to this comment Reply to this comment
confused said Jan 13, 2009 at 2:24 am

Ok still something is wrong but i have gotten further then i have uninstalling and starting over it could be all the failed attemps screwed something so starting fresh

Link to this comment Reply to this comment
Colt45 said Jan 13, 2009 at 2:19 am

Well if there are anymore errors just post them and the Reaper-X team will do their best!

Link to this comment Reply to this comment
confused said Jan 13, 2009 at 1:50 am

Hmm i think i might have it i got it doing something new when you start the bat i click 1 and it asks for ma,e then pass then world so on and so on well i didn’t have a name and that was where the problem was i have tride like a 100 times and i put root then my password then did defaukt for the rest and it seems to be working as of this moment its still running

Link to this comment Reply to this comment
confused said Jan 13, 2009 at 1:10 am

when i run the bat i get error 1045 access denied for user
when you install mysql i check it and i can put my password in and it works
do you have to do something else with mysql ? besides installing it and checking if it works ?
Ive even skipped over the bat and tride running navicat and i get access denied too ?

Link to this comment Reply to this comment
Jack said Jan 12, 2009 at 8:58 pm

@confused

instead of typing:
set mysqlpath=”c:\Program Files\mysql\MySQLServer5.0\bin” ,
try typing this on the Reaper-X Trinity.bat file (by editing it with notepad):
set mysqlpath=”C:\Program Files\MySQL\MySQL Server 5.0\bin”

Link to this comment Reply to this comment
confused said Jan 12, 2009 at 1:56 pm

Im new to making a server i followed the guide to the point the mysql works i checked it takes my password i get to the run Reaper-X Trinity.bat it asks for what the person in post 27 said and i get nothing just error messages and for download Navicat i get error 1045 access denied for user ive been going over these posts and uninstalling reinstalling the last three days what am i missing ?

Link to this comment Reply to this comment
Fu Man Chew said Jan 12, 2009 at 10:16 am

I am setting up a lan party server… I get to the relm selection part of the sign in process and it does not get past that… I have set the realmlist to point to my servers IP but I cannot connect to the server… any ideas or info… please

Link to this comment Reply to this comment
Jack said Jan 12, 2009 at 7:36 am

Ok, I just got into my server and created a druid.
Apparently after a druid hits level 100+, there is a bug that makes your game to crash when you open your character tab (c).
To fix this, all you have to do is to go to C:\Program Files\World of Warcraft\WTF\Account\(name of your account in this server)\(name of your current server)\(character’s name)
and then open savedvariables.lua with notepad and replace what’s in there with:

SHOW_KEYRING = 0 PLAYERSTAT_LEFTDROPDOWN_SELECTION = "PLAYERSTAT_SPELL_COMBAT" PLAYERSTAT_RIGHTDROPDOWN_SELECTION = "PLAYERSTAT_SPELL_COMBAT" SHOW_BATTLEFIELD_MINIMAP = "0"

PS: You’ll have to learn to live without seeing your base stats.
PPS: The empty paragraph is intended, which means you have to “type” it too.

Link to this comment Reply to this comment
Jack said Jan 12, 2009 at 7:21 am

Thank you for your help, I got around every problem and my server is running perfectly.
Great guide by the way. :D

Link to this comment Reply to this comment
Colt45 said Jan 12, 2009 at 5:39 am

In the .Conf files where it says:

127.0.0.1;3306;root;root;realmd

Change the second root to your mysql password, example if my password was 1234 it would look like this:

127.0.0.1;3306;root;1234;realmd

Link to this comment Reply to this comment
Jack said Jan 12, 2009 at 2:26 am

Using configuration file trinityrealm.conf.
Trinity (realm-daemon)
to stop.

Database: 127.0.0.1;3306;root;root;realmd
ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@'localhost’ (using password: YES)

ERROR:Cannot connect to database

Help please?

Link to this comment Reply to this comment
Jack said Jan 11, 2009 at 11:52 pm

To fix the SQL error, instead of typing:
set mysqlpath=”c:\Program Files\mysql\MySQLServer5.0\bin” ,
type:
set mysqlpath=”C:\Program Files\MySQL\MySQL Server 5.0\bin”

Atleast it worked for me :D

Link to this comment Reply to this comment
Jbudd0649 said Jan 11, 2009 at 10:15 am

How did you fix the SQL error? Im having the same Problem. I already ran the SQL check in command prompt. Sql looks good.

Link to this comment Reply to this comment
hcpowah said Jan 11, 2009 at 4:14 am

everybody is asking for a 3.0.3 release, but will there be a repack for patch 3.0.8? (wich will be released in a week or two)

Link to this comment Reply to this comment
Spike said Jan 10, 2009 at 11:43 pm

spontaneously decided to just start working for me, I got that map 0004331 map error thing, rereading the guide, probably going to redo the database after deleting everything, I got this once with MaNGOS and fixed it like that so, wish me luck.

Link to this comment Reply to this comment
Spike said Jan 10, 2009 at 11:27 pm

I have .NET Framewark 3.0 for SP1, I’ll upgrade to 3.5, that may have been the problem, not sure, but I’ll get back to you.

Link to this comment Reply to this comment
Colt45 said Jan 10, 2009 at 9:17 pm

I would try re-downloading and extracting it. If this doesn’t work make sure you have .NET Framework 3.5 SP1 installed.

Link to this comment Reply to this comment
Spike said Jan 10, 2009 at 9:31 am

See post 39, been working with it since then, re-extracting, editing, etc. the trinity files and I even re-extracted the vmaps/maps a few times, still getting the same error when I doubleclick the core or realm.exe files.

Still working on it, thanks for any replies.

(if you don’t feel like scrolling up)

C:\Documents and Settings\Owner\Desktop\Reaper-X Trinity Rev 1\TrinityRealm.exe

This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem.

^ Error message

Link to this comment Reply to this comment
Teus said Jan 10, 2009 at 1:48 am

With a Fresh install, trinity works great !

..but some Dranei start zone quests doesn’t work fine.

Link to this comment Reply to this comment
Demokritos said Jan 9, 2009 at 6:40 pm

Thanks a lot Wrath and Reaper, I was playing 2.4.3 up to now and I’m very grateful for the updated release!

I hope their is a GM island and vendors come with it, but in any case I’m still very grateful to you guys!

THUMBS UP!
SALUTE!

Link to this comment Reply to this comment
zyagor said Jan 8, 2009 at 10:03 pm

So I feel dumb on my second question now to so to fix the problem I was having you just have to have trinity realm and trinity core up and running or it wont even try to connect had to close it the first time and never tried opening it together again. very simple seems to be working now to just had to make the account with both up or got a error.

Link to this comment Reply to this comment
Colt45 said Jan 8, 2009 at 2:38 am

Alright Ima talk to Reaper (Hey Oatman if you see this send me or Reaper an email or Im us with your new email address), and we will try to get a NEW Trinity FAQs page along with a page that has EVERY KNOWN error and how you can fix it.

Link to this comment Reply to this comment
Zyagor said Jan 7, 2009 at 11:10 pm

Or @ steele if you can help me since you fixed the same problem I am at before you had your other problem

Link to this comment Reply to this comment
Zyagor said Jan 7, 2009 at 11:00 pm

@norr
Hey can you tell me how you fixed your problem? I am having the same problem it wont check passwords or any thing it just says unable to connect I changed the realmslist to and from what I can tell every thing seems ok still checking around though.

Link to this comment Reply to this comment
degg said Jan 7, 2009 at 10:50 pm

@Colt45

LOL…thx a ton, feel semi-retarted, haha.

Appreciate the help!!

Link to this comment Reply to this comment
Zvarder said Jan 7, 2009 at 9:28 pm

How do I make the server public? The guide you linked is outdated.

Link to this comment Reply to this comment
Colt45 said Jan 7, 2009 at 7:30 pm

@degg
Lol many people have this problem, its because you are playing on a GM account. To change it so that you start at lvl 1 on a Gm account go in to TrinityCore.conf files and find some GM settings and change the GM start level to 1.

Link to this comment Reply to this comment
degg said Jan 7, 2009 at 12:20 pm

I got it working with minor hiccups…great guide. One issue however, it starts all characters as lvl 70. Even if I have the trinitycore.exe config’d to start at player lvl 1…any fix for this?

thanks in advance.

Link to this comment Reply to this comment
Colt45 said Jan 7, 2009 at 7:34 am

@JC
I can convert your character from the old release (just that one though, lol I don’t want fifty characters to convert). Email me or IM me at CDTG45@yahoo.com

Link to this comment Reply to this comment
Jason said Jan 7, 2009 at 4:51 am

I got around the batch file problem by using Navicat to make clean databases and run the .sql files into each. At least so far- characters and realmd look fine, but world1 (of 3) is taking forever, for a lot less commands done. Which makes sense, as there is a lot of map and creature data to collate. >.>

Link to this comment Reply to this comment
Jason said Jan 7, 2009 at 4:26 am

Srsly, I’ve installed MySQL correctly, and I was using Arcane-Fire, but Trinity is not getting into MySQL correctly or something. It works from the command prompt. But not Trinity’s batch file. Arcane Fire, yes, Trinity, no.

Link to this comment Reply to this comment
JC said Jan 7, 2009 at 4:13 am

Hi This release is exelente…
it installed and run like a charm but it is possible to continue playing whith my old character from the previous release “Repack_Arcane-Fire” because i am level 53 human and i don’t want to start over from the begining

thanks for your continuos support

Link to this comment Reply to this comment
Zyagor said Jan 7, 2009 at 2:04 am

Nevermind on my question I figured it out must of put mysql on wrong to answer the other one the user name is root and that let me complete the process

Link to this comment Reply to this comment
Zyagor said Jan 6, 2009 at 10:28 pm

@DeathWing

Hey I have the same problem you had getting the error ” my sql is not recognized as an internal or external command” Could you tell me how you were able to fix this or any one who knows?

Link to this comment Reply to this comment
Colt45 said Jan 6, 2009 at 5:57 am

@Remar
Ya it is, lol. Anyways MaNGOS has released support for 3.0.3, so it should only be a matter of time before Trinity releases it (but knowing Trinity it will be even more stable than MaNGOS has it).

@Wrath
I truely believe it is an excelent guide though there may be a few small error, it is still good to have for most of the community.

Link to this comment Reply to this comment
wrath said Jan 6, 2009 at 4:50 am

Sorry guys if I missed anything in the guide or if something was out of order. I did all this one afternoon at work in my head.lol
The guide I believe is pretty close to installing the game however it is not exact.
It should be mainly used by someone that has installed the game or packs before and use the guide to fix some issues here and there to get you up and running. thanks for all the comments and fixes by reaper and the gang.

Link to this comment Reply to this comment
steele said Jan 5, 2009 at 9:29 pm

ok so i finally get everything to work can log in create a character, type in name, and click ok, it then puts me at the char select, but with no characters…WTF..?? anyways serverlog comes up wiht unknown field difficulty…not sure what that is..

ERROR:SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z, orientation, data, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arena_pending_points, latency) VALUES (1, 5, ‘Alena’, 10, 4, 530, 0, 10349.6, -6357.29, 33.4026, 0, ‘1 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 45 0 0 0 100 0 45 0 1000 0 100 0 1 1610 50398218 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1153957888 1157234688 1155596288 1053240066 1069547520 15475 15475 0 1083328804 1085425956 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 18 25 20 24 19 0 0 0 0 0 0 0 0 0 0 50 0 0 0 0 0 0 0 1084227584 1084227584 1084227584 1084227584 1084227584 1084227584 0 0 0 0 0 0 0 0 25 10240 25 0 0 16 0 0 1079134501 1082729618 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 134612489 33554440 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20897 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20896 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20898 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20982 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25861 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 1073741824 0 0 0 0 6 1073741824 8 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1073741824 0 0 12 1073741824 0 0 0 0 0 0 0 0 0 0 10 1073741824 14 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 95 327681 0 162 327681 0 109 19661100 0 137 19661100 0 756 65537 0 173 327681 0 38 65537 0 253 65537 0 176 327681 0 414 65537 0 415 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ‘, ‘0 0 131072 4 0 0 0 0 ‘, 0, 0, 0, 0, 0, 1231165610, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 3430, 0, ”, ‘0′, ‘0′ )
2009-01-05 17:26:50 ERROR:SQL ERROR: Unknown column ‘dungeon_difficulty’ in ‘field list’
2009-01-05 17:27:07 ERROR:SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z, orientation, data, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arena_pending_points, latency) VALUES (2, 4, ‘Aleana’, 10, 4, 530, 0, 10349.6, -6357.29, 33.4026, 0, ‘2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 45 0 0 0 100 0 45 0 1000 0 100 0 1 1610 50398218 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1153957888 1157234688 1155596288 1053240066 1069547520 15475 15475 0 1083328804 1085425956 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 18 25 20 24 19 0 0 0 0 0 0 0 0 0 0 50 0 0 0 0 0 0 0 1084227584 1084227584 1084227584 1084227584 1084227584 1084227584 0 0 0 0 0 0 0 0 25 10240 25 0 0 16 0 0 1079134501 1082729618 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100991492 33554438 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20897 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20896 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20898 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20982 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25861 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 1073741824 0 0 0 0 20 1073741824 22 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16 1073741824 0 0 26 1073741824 0 0 0 0 0 0 0 0 0 0 24 1073741824 28 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 95 327681 0 162 327681 0 109 19661100 0 137 19661100 0 756 65537 0 173 327681 0 38 65537 0 253 65537 0 176 327681 0 414 65537 0 415 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ‘, ‘0 0 131072 4 0 0 0 0 ‘, 0, 0, 0, 0, 0, 1231165627, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 3430, 0, ”, ‘0′, ‘0′ )
2009-01-05 17:27:07 ERROR:SQL ERROR: Unknown column ‘dungeon_difficulty’ in ‘field list’

any ideas?

Link to this comment Reply to this comment
steele said Jan 5, 2009 at 7:55 pm

norr how did u fix your quick disconnection problem, getting it on my end here thx

Link to this comment Reply to this comment
steele said Jan 5, 2009 at 7:27 pm

get this error when i try to set addon, and then try to login

2009-01-05 15:23:57 ERROR:SQL: UPDATE account SET expansion = ‘1′ WHERE id = ‘5′
2009-01-05 15:23:57 ERROR:SQL ERROR: Unknown column ‘expansion’ in ‘field list’
2009-01-05 15:24:18 ERROR:SQL: SELECT id, gmlevel, sessionkey, last_ip, locked, sha_pass_hash, v, s, expansion, mutetime, locale FROM account WHERE username = ‘TRINITY’
2009-01-05 15:24:18 ERROR:query ERROR: Unknown column ‘expansion’ in ‘field list’
2009-01-05 15:24:18 ERROR:WorldSocket::HandleAuthSession: Sent Auth Response (unknown account).

when i login to wow all it does is let me choose the realm then when i click ok i disconnect immideatly…anyhelp would be appreciated.

Link to this comment Reply to this comment
Remar said Jan 5, 2009 at 7:26 pm

Funny how it works eh Colt45 ?… I hate that we are not truely free to pursue our passions. Any way… any word on a more functional database for 3.0.3 ?

Link to this comment Reply to this comment
Colt45 said Jan 5, 2009 at 7:22 pm

Though for Reaper-X is is completley legal ;)

Link to this comment Reply to this comment
Colt45 said Jan 5, 2009 at 7:01 pm

@Unknown
There is a reason that THEY don’t. If THEY were to bring the database and core onto the same website it would make it ILLEGAL and against Blizzards Terms of Use, so instead they keep them on differant sites and then like magic, ITS LEGAL ;)

Link to this comment Reply to this comment
darkvenom said Jan 5, 2009 at 6:26 pm

Wait! Fixed it!

Open TrinityCore.conf and in the DataDir = “.” fill the quotes with “C:\WoW\data”

this guide forgot to mention editing the realm and core conf files to use the users own db username and password.

Link to this comment Reply to this comment
darkvenom said Jan 5, 2009 at 6:16 pm

still asking for 0004331.map even though I’m using TBC and 2.4.3 and the files required are present and extracted.

any suggestions?

Link to this comment Reply to this comment
j said Jan 5, 2009 at 12:09 pm

#colt45

Thx; I realize it probably is a honest mistake but it nuked a previous db in the process. :( These packs really should have a prefix tag associated with them. It prevents the databases from stepping on another group release’s toes…

Link to this comment Reply to this comment
j said Jan 5, 2009 at 12:07 pm

#tweaked

Socket error generally means something is already bound to a port. Do you have another mangos/trinity running? You can try various switches to the ‘netstat’ cmd to help you debug.

Link to this comment Reply to this comment
hivic said Jan 5, 2009 at 11:55 am

First off awesome guide.
To try to help a little, the sql is not recognized error can be fixed by opening your sql server window and looking at the initial batch file and make sure the paths are identical (i have version 5.1) had to update that.

My issue is when im trying to run trinityrealm.exe i get an error that the application failed to start because the side-by-side configuration is incorrect. damn vista, if there is a fix it would be awesome to know.

Link to this comment Reply to this comment