Not a newbie, but still having trouble setting up MAngos properly ...

Newbie Spellweaver
Joined
Mar 4, 2007
Messages
10
Reaction score
0
Hi!

[EDIT]: Maybe I should add that I took the Mangos Server Pack "Revision 3279 + ScriptDev2 Rev. 28 + Honor 0.70 + Jail + Chat&WhisperLogs + Dungeon/map Instancing v2.0 (beta)" from this board (btw. from a link to

I haven't dealt with WOW Server "emulation" (Is it okay to call this emulation? These folks at angos always claim they don't emulate a server ...) since almost a year, I guess Mangos was at rev. 4 or whatever. Now I have some spare time and wondered how far this project has come. So I wanted to install Mangos again, but I have soe bad trouble with it. Since two days I try to install all kinds of revisions and Databases, but all of them just make me mad instead of working correctly.

I have read all kinds of install instructions (some were outdated I guess now ...) but no1 enabled me to set up and run the server 100 % ...

My problem is that I can set up and run a server and I can even connect. But when I am ingame there are either no NPCs (I once managed to get them ingame, but then ...) or I have them but they show no quests and I can't talk to them.

I should add that I am pretty aware of the fact that this is no problem of MAngos itself but of my capabilities to install this f*chin thing :winky: But I just can't figure out what I am doing wrong.

Here I add the log file I got the last time I ran this damn thing:
Most of the time I get those error messages that some sql tables or templates or whatever r empty, but I don't know what I did wrong. Besides the other steps in setting up a server I did this in Navicat:
I open this connection I just called "mangos" (guess every1 can name this as he wants, right?) and then I make a "new database" called "mangos" (later I add one called "realmd" of course) and then I right-click on the database "mangos" and hit "execute batch file" and execute the new silver DB 0.6.2 132. When this is finished (it takes about 3 Minutes I guess) I add thie sql file called "mangos" in the folder of the Mangos server I d/l'ed (it's rev. 3278) and after that I do this with the realmd file (making a DB in NAvicat, executing, ...).
Okay, after I always got this f*cking errors that some templates are empty, I saw that there are more sql-batchfiles in the folder called "ScriptDev sql". I executed those, too (incl. those updates), but as u see if u have a look at the log further down, I still get those errors.

Can u PLEASE tell me what I forgot to do? I guess that it can only be a minor fault I did, cuz the server itself seems to run. So please, this is killing me!

2007-03-04 12:10:01 Using configuration file mangosd.conf.
2007-03-04 12:10:01 MaNGOS daemon /0.7-SVN (Win32)
2007-03-04 12:10:01 <Ctrl-C> to stop.


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
MMMMMM


2007-03-04 12:10:01 World Database: 127.0.0.1;3306;root;801232;mangos
2007-03-04 12:10:01 Login Database: 127.0.0.1;3306;root;801232;realmd
2007-03-04 12:10:01 Realm running as realm ID 1
2007-03-04 12:10:01 Using DataDir ./
2007-03-04 12:10:01 Initialize data stores...
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 28 data stores
2007-03-04 12:10:02
2007-03-04 12:10:02 Loading Game Object Templates...
2007-03-04 12:10:02 ERROR:`gameobject_template` table is empty!

2007-03-04 12:10:02 >> Loaded 0 game object templates
2007-03-04 12:10:02
2007-03-04 12:10:02 Loading player Create Info & Level Stats...
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 40 player create definitions
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 336 player create items
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 1526 player create spells
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 2049 player create skills
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 189 player create actions
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 2400 level stats definitions
2007-03-04 12:10:02 Loading Spell Chain Data...
2007-03-04 12:10:02
2007-03-04 12:10:02 >> Loaded 1329 spell chain records
2007-03-04 12:10:02 Loading Spell Proc Event conditions...
2007-03-04 12:10:03 >> Loaded 819 spell proc event conditions
2007-03-04 12:10:03
2007-03-04 12:10:03 Loading Aggro Spells Definitions...
2007-03-04 12:10:03 >> Loaded 53 aggro generating spells
2007-03-04 12:10:03
2007-03-04 12:10:03 Loading NPC Texts...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 npc texts
2007-03-04 12:10:03 Loading Quest Area Triggers...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 quest trigger points
2007-03-04 12:10:03 Loading Items...
2007-03-04 12:10:03 >> Loaded 73 item prototypes
2007-03-04 12:10:03
2007-03-04 12:10:03 Loading Page Texts...
2007-03-04 12:10:03 ERROR:`page_text` table is empty!

2007-03-04 12:10:03 >> Loaded 0 page texts
2007-03-04 12:10:03
2007-03-04 12:10:03 Loading Item Texts...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 item pages
2007-03-04 12:10:03 Loading Creature Templates...
2007-03-04 12:10:03 ERROR:`creature_template` table is empty!

2007-03-04 12:10:03 >> Loaded 0 creature definitions
2007-03-04 12:10:03
2007-03-04 12:10:03 Loading Quests...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 quests definitions
2007-03-04 12:10:03 ERROR:`quest_template` table is empty!
2007-03-04 12:10:03 Loading Teleport Coords...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 teleport definitions
2007-03-04 12:10:03 Loading Pet Name Parts...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 198 pet name parts
2007-03-04 12:10:03 Loading pet level stats...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 level pet stats definitions
2007-03-04 12:10:03 ERROR:Error loading pet_levelstats table or table empty.
2007-03-04 12:10:03 Loading Player Corpses...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 corpses
2007-03-04 12:10:03 Loading Loot Tables...
2007-03-04 12:10:03 creature_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `creature_loot_template` is empty.
2007-03-04 12:10:03 disenchant_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `disenchant_loot_template` is empty.
2007-03-04 12:10:03 fishing_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `fishing_loot_template` is empty.
2007-03-04 12:10:03 gameobject_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `gameobject_loot_template` is empty.
2007-03-04 12:10:03 item_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `item_loot_template` is empty.
2007-03-04 12:10:03 pickpocketing_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `pickpocketing_loot_template` is empty.
2007-03-04 12:10:03 skinning_loot_template :
2007-03-04 12:10:03
2007-03-04 12:10:03 ERROR:>> Loaded 0 loot definitions. DB table `skinning_loot_template` is empty.
2007-03-04 12:10:03 Loading Auctions...
2007-03-04 12:10:03 Loading Guilds...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 guild definitions
2007-03-04 12:10:03 Loading RaidGroups..
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 raidgroup definitions
2007-03-04 12:10:03 Returning old mails...
2007-03-04 12:10:03 Loading Scripts...
2007-03-04 12:10:03 scripts :
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 script definitions
2007-03-04 12:10:03 spell_scripts :
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 script definitions
2007-03-04 12:10:03 Initializing Scripts...
2007-03-04 12:10:03 WORLD: Starting BattleGround System
2007-03-04 12:10:03 ERROR:SQL: SELECT MAX(`instanceid`) FROM `instance_reset`;
2007-03-04 12:10:03 ERROR:query ERROR: Table 'mangos.instance_reset' doesn't exist
2007-03-04 12:10:03 Loading Transports...
2007-03-04 12:10:03
2007-03-04 12:10:03 >> Loaded 0 transports
2007-03-04 12:10:03 WORLD: Starting Event System
2007-03-04 12:10:03 WORLD: Starting Corpse Handler
2007-03-04 12:10:03 WORLD: World initialized
2007-03-04 12:10:03
2007-03-04 12:10:03 mangosd process priority class set to HIGH
2007-03-04 12:10:03
2007-03-04 12:10:05 Halting process...
 
Drop/Empty the database mangos. Create mangos again if you dropped it. Import silver DB 0.6.2 132 again. Don't import the mangos.sql one. The silver DB 0.6.2 132 is a full database. You might need to import the scripts.sql and updates in the ScriptDev 2 folder. Since you are using ScriptDev2 Rev. 28. Depends on who made the database.
 
So u think just leaving this Manogs.sql away makes this thing work? okay, I'll give it a try later.

Thx a lot for this hint. BUt why do these manuals that explain how to set up mangos always tell me to execute this mangos.sql? and why do I in fact not need to execute/import it to the SQL-DAtabase?


Again, thx for ur help :jester:
 
The silver DB 0.6.2 132 is a full database. Meaning it is a sql dump of a mangos.sql with a lot of updates. Since you are using a ScriptDev2 compiled server. You could still import the ScriptDev2 .sql files after the full, it wouldn't hurt.
 
okay, thx so far. But this still hasn't brought me any further. I found that my Navicat seems not to import the whole Database if I execute the batch file ... (at least it seemed so). I thought that maybe my DB is incomplete (for whatever reason), so I searched for another one and found the "newest" (at least it's been called newest) Silver DB Version called "SDBFULL_0.6.3_122_chaos_release.sql" ...

Compared to the one I had b4, called "FULLSDB_0.6.2_132_chaos_release.sql", the filesize was alot larger:

FULLSDB_0.6.2_132_chaos_release.sql - Size: 38.879 kb
SDBFULL_0.6.3_122_chaos_release.sql - Size:104.767 kb

:eek6:

hmm, I don't know why this is the case and I honestly do not care at all as long as this f*ckin thing will work now, but I got disappointed once again.

I imported the new DB, this time with this SQLyog application and it took much longer to import that one (at least 20 Minutes, don't know exactly). And when SQLyog finished importing the file, there were much more imported."querries" (is that the right name?) reported.

So I thought: "Hey, this time it may finally work!", but nooooooooo ...

I set up a new admin account for me and started WOW, logged in and created a new Character (Troll, Hunter). But when I hit "create", it takes me back to the character-selection screen and there is no newly created character. So I can't get into the world anymore.
Mangos says in the Server-Window (this CMD Window, ya know ...) "xyz created successfully" ...

I don't know what to do now ... This whole thing is pissing me off.

Does any1 know what I am doing wrong? After having imported this new Siver DB I started Mangos and tried what I wrote above. It didn't work, so I additionally imported the scripts.sql, mangos.sql, etc. one after the other, always trying to create a new character between the steps of importing new sql-files ... without success.

PLEASE HELP ME!!!! I JUST WANNA PLAY ...
 
hmm, just found that strange line in the Log of the server:

2007-03-05 15:20:48 ERROR:SQL ERROR: Unknown column 'bound_instances' in 'field list'

any idea what this could mean? Has that anything to do with my problem?
 
Back