[Two] Problem with extractor

[firedraken]

I have compiled the server and loaded all sql files on a linux box. I am having a problem though with extracting maps, vmaps, and mmaps. When i run the tools i get an error (on my windows box) saying the mscrv100.dll file is missing. I have it loaded in my system32 folder and have rebooted a couple of time since placing it there. Is there a way to the needed map files without the dll? or can anyone share their server 4.3.4 files with me? I know they can not be posted here

Or even if you could share working extractors with me that would be great.

[antz]

Were you able to resolve this ?

[antz]

i would put the dll in the same folder as the .exe's you are running - works for me

- Just make sure its the right one, as there are several different versions

[firedraken]

Antz I have done that also. When i try to extract on my linux box following the guide at http://getmangos.eu/bb/search/430969217/ the script can't find vmap* But I have put the dll in the same folder, in windows, syste, and system32 with no luck. It might be the dll but i have tried several downloads of the dll with the same result. Yes, they are all downloaded from different servers.

[antz]

I have just checked my folder and I have two dll's

msvcp100.dll & msvcr100.dll

[firedraken]

okay i got them to stop erroring but now during the extraction i get a lot of errors when building the vmaps and mmaps i.e. file name to long or file can't be read. Any idea of how to fix this?

[firedraken]

Can't find area flag for areaid 3381 [10, 14].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [11, 14].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [12, 14].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [13, 14].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3419 [4, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3419 [5, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [7, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [8, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [9, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [10, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [11, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [12, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_53.adt

Can't find area flag for areaid 3381 [13, 15].

Processing........................84%

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [7, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [8, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [9, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [10, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [11, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [7, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [8, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3381 [9, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [4, 7].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [5, 7].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [6, 7].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [7, 7].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [4, 8].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [5, 8].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [6, 8].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3397 [7, 8].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3379 [2, 12].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3379 [2, 13].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3379 [2, 14].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3379 [1, 15].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_54.adt

Can't find area flag for areaid 3379 [2, 15].

Processing........................85%

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [14, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [15, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [14, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [15, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [14, 2].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [15, 2].

File: World\\Maps\\Zul'gurub\\Zul'gurub_34_55.adt

Can't find area flag for areaid 3379 [15, 3].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [0, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [1, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [2, 0].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [0, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [1, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [2, 1].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [0, 2].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [1, 2].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [2, 2].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [0, 3].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [1, 3].

File: World\\Maps\\Zul'gurub\\Zul'gurub_35_55.adt

Can't find area flag for areaid 3379 [2, 3].

Processing........................87%

Processing........................89%

Processing........................90%

Processing........................92%

Processing........................93%

Processing........................95%

Processing........................96%

Processing........................98%

Processing........................100%

Extract Stratholme (29/206)

Processing........................1%

Processing........................3%

Processing........................4%

Processing........................6%

Processing........................7%

Processing........................9%

Processing........................10%

Processing........................12%

Processing........................14%

Processing........................15%

Processing........................17%

Processing........................18%

Processing........................20%

Processing........................21%

Processing........................23%

Processing........................25%

Processing........................26%

Processing........................28%

Processing........................29%

Processing........................31%

Processing........................32%

Processing........................34%

Processing........................35%

Processing........................37%

Processing........................39%

Processing........................40%

Processing........................42%

Processing........................43%

Processing........................45%

Processing........................46%

Processing........................48%

Processing........................50%

Processing........................51%

Processing........................53%

Processing........................54%

Processing........................56%

Processing........................57%

Processing........................59%

Processing........................60%

Processing........................62%

Processing........................64%

Processing........................65%

Processing........................67%

Processing........................68%

Processing........................70%

Processing........................71%

Processing........................73%

Processing........................75%

Processing........................76%

Processing........................78%

Processing........................79%

Processing........................81%

Processing............

Building map 001:

Creating navMesh...

We have 1011 tiles.

Building map 001, tile [00,00]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [00,01]

ERROR:Error reading ModelSpawn, file name too long!

[00,01]: Building movemap tiles...

[00,01]: Building navmesh tile...

[00,01]: Adding tile to navmesh...

[00,01]: Writing to file...

Building map 001, tile [00,02]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [01,00]

ERROR:Error reading ModelSpawn, file name too long!

[01,00]: Building movemap tiles...

[01,00]: Building navmesh tile...

[01,00]: Adding tile to navmesh...

[01,00]: Writing to file...

Building map 001, tile [01,01]

ERROR:Error reading ModelSpawn, file name too long!

[01,01]: Building movemap tiles...

[01,01]: Building navmesh tile...

[01,01]: Adding tile to navmesh...

[01,01]: Writing to file...

Building map 001, tile [01,02]

ERROR:Error reading ModelSpawn, file name too long!

[01,02]: Building movemap tiles...

[01,02]: Building navmesh tile...

[01,02]: Adding tile to navmesh...

[01,02]: Writing to file...

Building map 001, tile [02,00]

ERROR:Error reading ModelSpawn, file name too long!

[02,00]: Building movemap tiles...

[02,00]: No polygons to build on tile!

Building map 001, tile [02,01]

ERROR:Error reading ModelSpawn, file name too long!

[02,01]: Building movemap tiles...

[02,01]: Building navmesh tile...

[02,01]: Adding tile to navmesh...

[02,01]: Writing to file...

Building map 001, tile [02,02]

ERROR:Error reading ModelSpawn, file name too long!

[02,02]: Building movemap tiles...

[02,02]: No polygons to build on tile!

Building map 001, tile [19,12]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [19,13]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [19,14]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [19,15]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [19,16]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [20,12]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [20,13]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [20,14]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [20,15]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [20,16]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [21,12]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [21,13]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [21,14]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [21,15]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [21,16]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,12]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,13]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,14]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,15]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,16]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,17]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [22,18]

ERROR:Error reading ModelSpawn, file name too long!

Building map 001, tile [23,12]

ERROR:Error reading Modele [15,19]

These exerts from the file as of this point when the process is done I will post the whole file as an attachment as well as on my web site for viewing.

[antz]

The Zul'gurub errors are normal and can safely be ignored

As for 2nd lot, not 100% sure, might be ok though

[firedraken]

Final output for the extractor is posted at http://darkhome.homeip.net/mangos_build.htm any input would be appreciated going to load them to the server and see if it run.

[firedraken]

okay now I get this

2013-02-14 20:46:03 MaNGOS/ (* * Revision 12337 - *) for Linux_x32 (little-endian) [world-daemon]

2013-02-14 20:46:03 <Ctrl-C> to stop.

2013-02-14 20:46:03

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2013-02-14 20:46:03 Using configuration file /home/mangos/etc/mangosd.conf.

2013-02-14 20:46:03 World Database total connections: 2

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 Character Database total connections: 2

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 Login Database total connections: 2

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 MySQL client library: 5.5.29

2013-02-14 20:46:03 MySQL server ver: 5.5.29-0ubuntu0.12.04.1

2013-02-14 20:46:03 Realm running as realm ID 1

2013-02-14 20:46:03 Using World DB: MaNGOS3_Cata_Rev_3

2013-02-14 20:46:03 Using creature EventAI: ACID 3.1.0 'Another Wild Adventure'

2013-02-14 20:46:03 Using DataDir /home/mangos/data/

2013-02-14 20:46:03 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1

2013-02-14 20:46:03 WORLD: VMap data directory is: /home/mangos/data/vmaps

2013-02-14 20:46:03 WORLD: mmap pathfinding enabled

2013-02-14 20:46:03 ERROR:VMap file '/home/mangos/data/vmaps/001.vmtree' is missing or point to wrong version vmap file, redo vmaps with latest vmap_assembler.exe program

2013-02-14 20:46:03 ERROR:Correct *.map files not found in path '/home/mangos/data/maps' or *.vmtree/*.vmtile files in '/home/mangos/data/vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.

when I try to run the server. I extracted from the right client build using the current revision and the tools from that server revision. WTF how can I fix this?

[firedraken]

when i run the exe files on there own during vmapextractor it doesn't find

wow-update-13164.mpq

13205

13287

13329

13596

13623

wow-update-base-13914.mpq

14007

14333

14480

14545

15005

15050

and I get an error about not being able to read file when extracting Azeroth and Kalimdor

[firedraken]

I found the missing MPQ's and re-ran ad.exe it gets to STC_Mine_BG map 162 and errors. i ran the repair utility and rebooted my comp with no luck. What can i do?

[antz]

did you recompile the vmap extractor/assembler exe's from the source ?

[firedraken]

yes, yes i did

[antz]

Hmm , can you try running the server with vmaps swtiched off - just to check that the rest is ok

[firedraken]

disabled vmaps and all started up with no errors and I was able to get to server command prompt

[firedraken]

okay disabling vmaps let me boot but when i try to create a character i get

2013-02-15 19:22:46 ERROR:SQL: SELECT type, time, data FROM account_data WHERE account='5'
2013-02-15 19:22:46 ERROR:query ERROR: Unknown column 'account' in 'where clause'
2013-02-15 19:22:53 ERROR:SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.equipmentCache, characters.slot FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '5' ORDER BY characters.guid
2013-02-15 19:22:53 ERROR:query ERROR: Unknown column 'characters.slot' in 'field list'
2013-02-15 19:24:23 ERROR:SQL: mysql_stmt_prepare() failed for 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, primary_trees, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, health, power1, power2, power3, power4, power5, specCount, activeSpec, exploredZones, equipmentCache, knownTitles, actionBars, slot) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) '
2013-02-15 19:24:23 ERROR:SQL ERROR: Unknown column 'dungeon_difficulty' in 'field list'

i'm using the database that is on the git what do i need here and where can i find it I want this up and running!

[firedraken]

all updates that my server will accept without error have been applied

The Following would not apply These are YTDB

707_corepatch_characters_12301

711_updatepack_mangos_12309

712_updatepack_mangos_12309

713_updatepack_mangos_12337

The error given on all these are similar to the below

Error occured at:2013-02-15 20:20:10

Line no.:2

Error Code: 1054 - Unknown column '712_FIX_12309' in 'db_version_ytdb'

[Xenithar]

You are missing columns in your characters database. How did you create your database?

[firedraken]

the create database script in the server sql/create/ folder I followed the wiki to compile and run