Mercenary failed to spawn

[pythag]

Hii
After some time I have managed to get a single pc private/server up and running, trying to get everything working that is possible - bots took some time but all there now.
However Mercs are down after intense searching via here and google.
I am using "peqbeta_2014-09-25-02-01"
I have turned them on
Resourced the code from here http://www.eqemulator.org/forums/sho...meele_texture1
Corrected the d_meele issue to d_melee
I have the hire window and can turn costs on and off
imported the dbstr_us.txt from a live account to correct the "Unknown DB String 6120105-2" errors

Yet all that still get "Mercenary failed to spawn!"

Any advice of what I am missing!

[trevius]

Have you tried compiling the latest source code updates? Previously, mercs were loaded from a view instead of from the merc related tables. The view could run into certain issues, so I recently changed it to no longer rely on the view at all.

All you should need to do in order to enable mercs is this:

1. Set the AllowMercs rule to true.
2. Create a Merc Merchant NPC that is class 71.
3. Add the NPC ID of the Merc Merchant to the merc_merchant_entries table. (an example is merc_merchant_entry_id = 1, merc_merchant_template_id = 1, and merchant_id = 123456, where 123456 is the NPC ID of the Merc Merchant)
4. Restart your server.

That should be it. If that is not working, then there may be something else wrong with your merc tables (such as a missing update). If you ran the mercs.sql file, then you overwrote some of the updates since that file was created and your queries will fail. Make sure you also applied all merc related sql from after that change as well (which I think are the ones in the git/required folder). The only one I know of for sure offhand is the specialabilities field updates for mercs.

You should be able to watch your server console logs when you try to right click on the Merc Merchant to see if you are getting any SQL errors. If you get errors, post them and it should be easy to figure out what is missing.

[pythag]

Thanks for the info Trevius.
Your fix did instruct me to how to simply add a Merc to the server future.
This post http://www.eqemulator.org/forums/showthread.php?t=37951 by Cassieze is also super informative in explaining how to edit things.
I did ensure the *required* sql were ran just in case.

However still failed to spawn, the solution was by Sorvani as below, simply had to run the sql statements (once editing the d_meele)
Merc SPecial Abilities: http://pastebin.com/6gpx9RGM
Fix the View: http://pastebin.com/dXfrkFmd
Update Liaisons: http://pastebin.com/s7i5vWLk

I am running peqbeta_2014-09-25-02-01 not sure if the 2014-10-11-02 version is running as the wiki suggests not to use it

Thank you

[trevius]

Ya, you are running older source code. People on the new code will probably have an easier time because they don't need to mess with that merc view anymore. They just need to do what I listed.

[pythag]

older source code

Ok probably missing the obvious here but the wiki states

WARNING! The Oct 11 2014 PEQ database peqbeta_2014-10-11-02:01.tar.gz is broken. Use the peqbeta_2014-09-25-02-01.tar.gz one instead!

So I did as instructed - then ran all the .sql from the required section which were after the 25_9_2014, so unclear how my code is older - unless there is more code out there.

I am happy with the install but asking so I can learn!

[trevius]

I am referring to the source code here:
https://github.com/EQEmu/Server

Not the database version you are on from PEQ. If you are running the latest source code on the older snapshot of the PEQ DB, it should have updated everything automatically for you when you started the server (as long as you chose the options to update the required in the startup script that gets ran when you start the world process).

Have you updated your source code from Github and compiled the latest version yet?

[pythag]

Mmmm looks like some more reading, did a "git pull" on the source folder and got a bunch of updates - so need to go rerun a few things, thank you