World of Warcraft Server for Windows - Installation Guide

[cyclone7]

When i try to install TortoiseSVN-1.6.8 i get this error:''The Installation package is not supported by this processor type.Contact your product vendor.''Please help me.

I found the problem...ty anyway.

[Cdprojects]

Thanks to you temporary its finnaly working. I just decided to destroy all my databases and start again and applied my updates carefully and everything started right and all is working! Thank you for your help and your awesome guide!

[WernerCD]

error: error setting certificate verify locations:

CAfile: /bin/curl-ca-bundle.crt

CApath: none

while accessing https://scriptdev2.svn.sourceforge.net/svnroot/scriptdev2/info/refs

fatal: HTTP request failed

Trying to clone SD2... getting same error both with GIT GUI and Git Bash.

Cloned Mangos successfully so I know it works.

[Cdprojects]

My server is working fine I can connect to it but when my friends try to connect it doesnt work is there anything to change somewhere?

[temporary]

WernerCD, well i did use Turtoise SVN instead of GIT to clone Scriptdev2

CDProjets, i assume that you made a LAN server and an Internet server?

i also assume that connecting with an other computer on the network it does work with the LAN connection...you could also try the internet connection with your own pc see if it works but as soon as your going to redirect the ports, it may not work anymore with the internet conenction within the lan

So i guess, you may need to redirect your ports on your router....

[vindir]

NVM , i should read

[vindir]

Me Again.

got these error when i start mangos

SQL: SELECT required_9590_01_mangos_db_script_string FROM db_version LIMIT 1 query

ERROR: Unknown column 'required_9590_01_mangos_db_script_string' in 'field list' Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9590_01_mangos_db_script_string`! Not all sql updates applied?

ok i havent updated all databases because when i try to update with the sql in the C:/Mangos/sql/updates i think they don´t update because of this message :

Query : ALTER TABLE character_db_version CHANGE COLUMN required_9687_01_characters_character_queststatus_daily required_9692_01_characte...

Error Code : 1054

Unknown column 'required_9687_01_characters_character_queststatus_daily' in 'character_db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Query : alter table `mail` add column `body` longtext CHARSET utf8 COLLATE utf8_general_ci NULL after `subject`

Error Code : 1060

Duplicate column name 'body'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

this is the error message when i copie the "9010_01_realmd_realmlist.sql" text in the query box and trie to execute the current query with the "realmd" database for example. it happend with every sql in the update folder.

Tipps?

Thank you

[caeruleaus]

you can checkout SD2 with git but you need to do

git svn clone *repository*

instead of just

git clone *repository*

[vindir]

ok now i have all files updated (i think) know mangosd.exe is compiling untill:

"Loading Items...

[0 ms] SQL: SELECT MAX(Entry) FROM Item_template

[0 ms] SQL: SELECT COUNT(*) FROM item_template

[16 ms] SQL: SELECT * FROM item_template

Error in Item_template table, probably sql file format was updated (there should be 138 fields in sql)

[temporary]

Hum, you should perhaps drop your table and restart part 14-15-16

When you update a table, make sur you've looked at the table version, this will help choose wich update to do first...

And please read all the **

[seanb]

I was having problem getting mangosd.exe to run (it showed sql errors, then crashed), so i dumped my sql tables (emptied them actually), and started the sql over again.

I think the problem i'm having is understanding the update process. If you ever wanted to re-word something, the step with the SQL updates might be one area you could improve. Please don't think i'm trying to criticize you though, the entire tutorial is awesome! i just think that area is a little fuzzy for first timers.

You say to choose your updates, either from c:\\mangos\\sql\\updates, OR the update packs. Does that mean that the information in both areas is the same, just in different forms?

Right now i have the following in my SQL.

Characters - 9849

Mangos - 9590, 388

Realmd - 9748

When i look at the C:\\mangos\\sql\\updates, i cant find any sql files for realmd or characters with a higher number, but i can find some for mangos.

If i go one step further, to c:\\mangos\\sql\\updates\\0.16 i can find some more sql files for mangos, with numbers inbetween the other two groups. It looks like i should install the updates from /0.16 folder, then the ones in the /updates folder.

Then if i look at the updatepacks URL, i find some 389 and 390 updates. you say to only update to those after i've updated my core. I'm not sure what that means either.

So what should i do? i did it once last night, and obviously messed it up, because mangosd.exe would not run (realmd.exe did though!)

[caeruleaus]

with udb, he means run the core patch files and then the update packs (so core patch, might be 1 or 2 update packs, another core patch, etc). Only apply the sql updates if your DB needs it though. They should be labeled witha revision number.

[vindir]

@seanb: Ive had the exact same problem. And now i my server is running.

What did i do?

first:

http://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/Updates/0.12.0_additions/

first use these:

388_corepatch_characters_9311_to_9582.sql

(here you must select the characters database in sqlyog)

388_corepatch_mangos_9311_to_9582.sql

(and here the mangos dtb of course)

then use the big

388_updatepack_mangos.sql

(selsect the mangos database)

the use the next:

389_corepatch_characters_9583_to_9630.sql

389_corepatch_mangos_9583_to_9630.sql

and the big one:

389_updatepack_mangos.sql

then the next one:

390_corepatch_characters_9631_to_9763.sql

390_corepatch_mangos_9631_to_9763.sql

390_corepatch_realmd_9631_to_9763.sql

(select the realmd database of course)

big one is next:

390_updatepack_mangos.sql

soo now i used the

Advanced Creature Intelligence Database for Mangos

(Part 16)

and nooow:

i looked in the database version of mangos

and i got

UDB 0.12.0 (390) for MaNGOS 9763 with SD2 SQL for rev. 1677

now ive looked in the

C:\\Mangos\\sql\\Updates for higher ones (only for mangos) :

i scroll down and saw these datas:

9766_01_mangos_spell_proc_event

9767_01_mangos_mangos_string

9767_02_mangos_command

9768_01_mangos_command

9794_01_mangos_mangos_string

9794_02_mangos_command

9803_01_mangos_spell_bonus_data

9826_01_mangos_spell_script_target

i used all of these and now it is working.

I hope it work for you too.

And sry for my bad english.

[temporary]

seanb, no i don't take your comment the wrong way... i think its bin the part that most people asked question about and perhaps the hardess part to describ the right way...

I've re-wrote everything this week, i don't know if your talking about the new version or the old one.....

Yes UDB Corepatch and sql/updates is the same.... The Corepatch is a bunch of sql/updates...

theres 2 way to see it ...when you take the core from UDB to create your database, well you have a number there... theres a version for your mangos database... when you start updating the first time, its best to follow the next number from UDB ...its simple 388... 389....390 ... but when you check the version of your database, mangos won't launch because its not up to latest vesion... since theres still files in sql/update that can be use to upgrade your table even though UDB doesn't have them

UDB will only make pack of Core files that fits their UDB Updatepack ....because to be able to put content in the table, you need to create the table

Thanks for the example Vindir

[seanb]

Thank you to Vindir and Temporary. I'm up and running!

[cajkan]

Hello im reciving some error

when i apply SD2 last patch C:\\Mangos\\src\\bindings\\ScriptDev2\\sql\\mangos_scriptname_full.sql

i get this error

Query:

/* */

/* AREATRIGGER */

DELETE FROM areatrigger_scripts WHERE entry=4591

Error occured at:2010-06-01 18:14:52

Line no.:4

Error Code: 1146 - Table 'scriptdev2.areatrigger_scripts' doesn't exist

Pls anyone tell me how to fix this problem

TNX

[seanb]

i wouldn't worry about it if everything works right. It's trying to delete an unnecessary table row, and not finding it.

[cajkan]

Well acctually some Rows are applyed and some are deleted... i`ll try whats gonna happen

Tnx coz i was worried abbout it

if anyone know any other suggestion WELCOME

[Torzino]

Thank you finally i got this installed thanks to your guide!

[wolfgangJT]

I am having trouble. I have followed two guides exactly and cannot get it to work. When I launch the mangosd.exe I see the cmd prompt but it disappears immediately and I check the error log and this is what I get:

2010-06-15 16:26:00 SQL: SELECT required_10056_01_mangos_spell_proc_event FROM db_version LIMIT 1

2010-06-15 16:26:00 query ERROR: Unknown column 'required_10056_01_mangos_spell_proc_event' in 'field list'

2010-06-15 16:26:00 The table `db_version` in your [WORLD] database indicates that this database is out of date!

2010-06-15 16:26:00

2010-06-15 16:26:00 [A] You have: --> `9990_01_mangos_spell_chain.sql`

2010-06-15 16:26:00

2010-06-15 16:26:00 You need: --> `10056_01_mangos_spell_proc_event.sql`

2010-06-15 16:26:00

2010-06-15 16:26:00 You must apply all updates after [A] to to use mangos with this database.

2010-06-15 16:26:00 These updates are included in the sql/updates folder.

2010-06-15 16:26:00 Please read the included [README] in sql/updates for instructions on updating.

Any tips? I have tried to update all of that it says and it still doesn't work.

EDIT Nevermind, I found out what I was suppost to do. When it says that, you are going to have to apply every update from the A file to the B file.

[SaiyaNicole]

i'm knda new in to this thing with C++ and other stuffs, but I try to make my own WOW private server, just for me... and I am stuck to this part (part 7) because I have microsoft visual c++ 2010 and in the tools menu is like this:

- tools-> option->Projects and solution->VC++ directories then nothing.... there are no more options or anything.... can you explain me what to do?http://photos1.hi5.com/0129/076/548/8fcX0U076548-02.jpg

[temporary]

Hi there

I aint in front of my server but i suggested to use 2008 since, mangos may be "compatible" with 2010, altough Scriptdev2 isn't (unless they changed this within the last 2 month's)

[Derelictlulz]

Followed all the steps in the OP up until the last one. When I start mangosd.exe this comes up in the error log:

2010-06-23 21:26:02 Using configuration file mangosd.conf.
2010-06-23 21:26:02 World Database: 127.0.0.1;3306;root;snappy4;mangos
2010-06-23 21:26:02 MySQL client library: 5.0.56
2010-06-23 21:26:02 MySQL server ver: 5.1.41-community 
2010-06-23 21:26:02 ERROR:SQL: SELECT required_10089_01_mangos_game_event_pool FROM db_version LIMIT 1
2010-06-23 21:26:02 ERROR:query ERROR: Unknown column 'required_10089_01_mangos_game_event_pool' in 'field list'
2010-06-23 21:26:02 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2010-06-23 21:26:02 ERROR:
2010-06-23 21:26:02 ERROR:  [A] You have: --> `9539_01_mangos_spell_bonus_data.sql`
2010-06-23 21:26:02 ERROR:
2010-06-23 21:26:02 ERROR:  [b] You need: --> `10089_01_mangos_game_event_pool.sql`
2010-06-23 21:26:02 ERROR:
2010-06-23 21:26:02 ERROR:You must apply all updates after [A] to [b] to use mangos with this database.
2010-06-23 21:26:02 ERROR:These updates are included in the sql/updates folder.
2010-06-23 21:26:02 ERROR:Please read the included [README] in sql/updates for instructions on updating.

I've tried applying the updates with SQLyog but it's giving me an error about a column (something like required_xxxx) that doesn't exist. I've also tried reading the readme in the sql/updates folder but I haven't gotten any wiser from that either. Any help would be greatly appreciated!

[temporary]

Seem you're almost done

Altough, i would ask you that you read Part 15 again, all the information is there...assuming of course that you've download the right packages...

Btw, you've just showed your password in your "Code" ...i would suggest you modify your password if you've allowed internet connection to your sql database... of course we don't have your IP but still

[Koichiisama]

Small problem I'm having, wonder if anyone could assist. I'm currently going through part 8 of the process. I was able to complete the Win folder compile and went to ScriptDev2 to compile that one. Compile is going through when I get a fail. I clean the build and attempt again, get the same result. Looking back through the output I find this:

1>..\\scripts\\kalimdor\\caverns_of_time\\old_hillsbrad\\old_hillsbrad.cpp(358) : error C2065: 'npc_tarethaAI' : undeclared identifier

1>..\\scripts\\kalimdor\\caverns_of_time\\old_hillsbrad\\old_hillsbrad.cpp(358) : error C2065: 'pTarethaAI' : undeclared identifier

1>..\\scripts\\kalimdor\\caverns_of_time\\old_hillsbrad\\old_hillsbrad.cpp(358) : error C2061: syntax error : identifier 'npc_tarethaAI'

1>..\\scripts\\kalimdor\\caverns_of_time\\old_hillsbrad\\old_hillsbrad.cpp(366) : fatal error C1903: unable to recover from previous error(s); stopping compilation

Anyone have any idea how I could fix this? Thank you for your time.