Getting mercs to work...

nosfentora · #1 03-22-2013, 04:05 PM

Hi all,

figured I'd try out the mercs and am running into a snag.

First attempt at sourcing the merc .sql's failed and i realized i never sourced in mercs.sql, so i started with a fresh db and today's source pull (3/22/13).

PEQ_DB_2506
then the rest of the tables (player,bots,views,qs)
/utils/sql/svn/mercs.sql
/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT

the above sourced fine.

sourcing

/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment

I got an error: errno 150

doing some research it appears it's related to the FK somehow, but I'm not sure how.

I tried creating the table without the FK, and then with NaviCat, add the key after creation.

It failed with errno:150 as well.

I changed the engine to MyISAM and the FK added.

I sourced in the data to merc_inventory.

All the other queries in 2013_03_1_Merc_Rules_and_Equipment were applied ok.

Next i sourced the last two sql files

/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells

Restarted the server (ran shared_memory first) and logged in.

no errors in the logs.

Went to POK and checked all of the merc liaisons and nothing showing up in the windows.

Using Steam ROF client: Starting EverQuest (Built Dec 10 2012 17:35:44)

Did I miss something along the way?

**bad_captain** · #2 03-22-2013, 07:38 PM

Check all of the /utils/sql/svn/2380_optional_mercxxxx.sql files as well. The merc_data one has the actual data that is used by the merc merchants to allow you to hire them. It may or may not be included in the latest peq database.

If you have the table merc_templates in you database, then it's probably something else. Did you change the rule AllowMercs to true? It defaults to false for now.

Otherwise, check you logs for errors.

**Uleat** · #3 03-22-2013, 11:18 PM

So..

source [svn] mercs.sql

source [svn] merc updates

source [git] merc updates

..should get us up to speed then?

**bad_captain** · #4 03-23-2013, 01:00 AM

Depends on what's included in peq db if anything. If nothing is included, check the changelog for rev 2380, and source them in in that order - mercs.sql will probably be last of those. Then all of the svn updates, then the git updates.

Confusing for sure, but I'm not sure of a better way, unless we keep an up to date mercs.sql that includes everything, but I don't think I'm supposed to do that.

**Robregen** · #5 03-23-2013, 01:39 AM

PEQ has been uploaded as of EQEmu rev 2605 in svn just before it got moved to git so merc should be included as far as I can tell. I'm pretty sure it's set up on the server but it's currently disabled atm.

just need to get the update sql from github which ever was committed on there.

Shiny151 · #6 03-23-2013, 02:37 AM

Is the last database still at rev 2294?

**Robregen** · #7 03-23-2013, 03:00 AM

no, the last one uploaded is 2506, I stated 2605 which I had it backward. my mistake. it's at 2506. that's if you use svn. the download section is 2294.

https://code.google.com/p/projecteqd...ce/detail?r=68

vkrr · #8 03-23-2013, 09:31 AM

Hope you dont mind me jumping on this thread, but my mercs seem to be stanceless, even though I have a populated (22 row) merc_stance table in my database.

Is this a common problem?

edit: Looks like the stances were not showing up until I dinged and then zoned. I'll try to replicate it

**Uleat** · #9 03-23-2013, 06:55 PM

I ask because I'm getting the same error as nosfentora when I try to source a new database.

My old one is fine, but it has been around since pre-2k and has been updated along the way.

Andrew80k · #10 03-24-2013, 07:59 PM

Quote:

Originally Posted by bad_captain

Depends on what's included in peq db if anything. If nothing is included, check the changelog for rev 2380, and source them in in that order - mercs.sql will probably be last of those. Then all of the svn updates, then the git updates.

Confusing for sure, but I'm not sure of a better way, unless we keep an up to date mercs.sql that includes everything, but I don't think I'm supposed to do that.

Maybe we can list them in order on a wiki page... ? I was struggling to get them to work until I found this page...

nosfentora · #11 03-25-2013, 08:51 AM

@bad_captain

Quote:

Check all of the /utils/sql/svn/2380_optional_mercxxxx.sql files as well. The merc_data one has the actual data that is used by the merc merchants to allow you to hire them. It may or may not be included in the latest peq database.

If you have the table merc_templates in you database, then it's probably something else. Did you change the rule AllowMercs to true? It defaults to false for now.

Otherwise, check you logs for errors.

I'll try that and get back to you. I didn't bother sourcing in old updates as I figured that since the PEQ rev was higher, it should already be there.

I also don't have a rule 'AllowMercs', so I must have missed something somewhere along the line.

I'll re-try and post back with results.

nosfentora · #12 03-25-2013, 09:27 AM

I tried creating a new database, from scratch and this worked:

Source:
PEQ_2506
then the rest of the tables (player,bots,views,qs)

Per bad_captain's suggestion,

/utils/sql/svn/2380_optional_merc_data
/utils/sql/svn/2380_optional_merc_merchant_npctypes_update
/utils/sql/svn/2380_optional_merc_rules

/utils/sql/svn/mercs.sql
/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT

Now when sourcing

/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment

there was no more error!

then source

/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells

I haven't logged in yet, but at least that got rid of the sourcing error.

I will try this on my main db (deleting all merc related tables first) and then post back.

**bad_captain** · #13 03-25-2013, 09:42 AM

I'll see what I can do wiki wise. I've not messed with it before, so we'll see. What I will probably also do is host an updated full merc script on github. I'll probably also do the same for my bots spell lists I haven't finished.

nosfentora · #14 03-25-2013, 11:12 AM

Using my main db, dropping all 'merc' tables, and rules then sourcing

/utils/sql/svn/2380_optional_merc_data
/utils/sql/svn/2380_optional_merc_merchant_npctypes_update
/utils/sql/svn/2380_optional_merc_rules

/utils/sql/svn/mercs.sql
/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT
/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment
/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells

I got no errors!! Yea!!

I'll fire up the server and log in when i can and report back on the results!

nosfentora · #15 03-25-2013, 11:42 AM

Works like a charm now. Thanks for pointing me in the right direction bad_captain!