[Mangos] Rev 9748 (3.3.3a) Fatal Repeat Crash

[humanity lost]

Me and a few friends were messing around on GM Island. I decide to spawn Jaina Proudmoore (creature id: 17772) to get her display id. Before she spawns, a fatal error comes up, and mangosd.exe crashes. Tried to restart server: still crashes once anyone tries to log in and enter world. Tried going into the databases using NaviCat Lite and deleting her creature template and record in the Creature table. No such luck. Still crashing immediately when someone enters world. Please help!

Not sure if it was the spawning of Jaina or something else that may have caused it. The first crash happened almost immediately after I typed .npc add 17772, so I can only assume that this was the cause. I will ask my friends tomorrow what they were doing around the time of the first crash. For now that's all I have to go on.

First line on the readme of the Mangos pack: Description Repack Ver.6.29-Client 3.3.3a (11723)

+Rep for helpful replies :]

Damn you, Jaina.

[Kiev]

Go into the creature spawns and remove her , as she will still be saved in there, table name will have something resembling "creature_spaws" or "npc_spawns", and she will typically be on the last page.

[darkpatato]

Remove her from spawns

[humanity lost]

Hey thanks guys, but I can't find the creatures or npc spawns database... maybe my mangos databases are missing them or something, but I just can't seem to find them. This is what I see when I look in my mangosd database file:



Any ideas? Could this be the problem? Should I reinstall Mangos? Will this delete all my characters, accounts and data? Thanks for the help so far :], looking forward to your replies.

[Kiev]

Take a look in creature_respawn, as im not familiar with the MaNGOS database structure. And reinstalling would get rid of them, but you can dump the SQL file and execute it again when you are done.

[Link_S]

TIP; Use a SQL query to find her and delete her, much simpler.

I could've written it for you, but I'm (as Kiev) unfamiliar to the Mangos database structure.

[humanity lost]

Hey thanks . I'm gonna look into SQL to see how to make a query. Since you guys aren't familiar with Mangos, what emulator do you recommend? I may just choose a different core to work with.

[The-Eradicator]

Hey thanks . I'm gonna look into SQL to see how to make a query. Since you guys aren't familiar with Mangos, what emulator do you recommend? I may just choose a different core to work with.

They'll recommend ArcEmu, because it has Lua and is "easier to customize". I'm not sure what that's supposed to mean since I don't use it.

I'd recommend TrinityCore. It's a derivative of MaNGOS, but generally is developed faster than MaNGOS.

The main difference between the two would be:

- ArcEmu is very crash-happy, generally due to the database rather than the core.
- ArcEmu is "easier to customize". I don't use it, but that's what is always touted.
- ArcEmu has a Lua engine to load scripts without recompiling.

- TrinityCore has more class spells & talents working correctly.
- TrinityCore, in my experience, rarely crashes.

MaNGOS and TrinityCore basically have different feature-sets, but i'd recommend TrinityCore because it will usually include MaNGOS patches in addition to their own fixes.



In summary:

If you're making a Blizzlike server go with TrinityCore.

If you're willing to put in more work and effort into your [fun]server to have everything working, go with TrinityCore.

If you're going to wipe the database and start from scratch, either emulator is appropriate, but you will still have more class spells working on TrinityCore.

If you're just running a server to mess around with a few friends, ArcEmu is easier to run.

If you're capable of patching the core to fix spells, you can go with either emulator without too much of a difference.

[humanity lost]

Awesome post :], will +rep as soon as I can.

Very helpful. I may go public with it, but for now it's just a few friends--and the server would be barely up because I have school and a job. But Trinitycore sounds good. Is there a version out compatible with 3.3.3a?

[The-Eradicator]

Awesome post :], will +rep as soon as I can.

Very helpful. I may go public with it, but for now it's just a few friends--and the server would be barely up because I have school and a job. But Trinitycore sounds good. Is there a version out compatible with 3.3.3a?

Sure is.

trinitycore - Project Hosting on Google Code

[humanity lost]

Awesome thanks will set up when I get free time later on. Bye-bye Mangos, I guess :P. Thanks for all the help people, I appreciate it.