|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
|
|
|
03-22-2013, 04:05 PM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
Getting mercs to work...
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?
|
|
|
|
03-22-2013, 07:38 PM
|
Developer
|
|
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
|
|
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.
|
03-22-2013, 11:18 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
So..
source [svn] mercs.sql
source [svn] merc updates
source [git] merc updates
..should get us up to speed then?
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
03-23-2013, 01:00 AM
|
Developer
|
|
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
|
|
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.
|
03-23-2013, 01:39 AM
|
Developer
|
|
Join Date: May 2011
Posts: 108
|
|
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.
|
03-23-2013, 02:37 AM
|
Hill Giant
|
|
Join Date: Jul 2009
Location: Indianapolis
Posts: 228
|
|
Is the last database still at rev 2294?
|
03-23-2013, 03:00 AM
|
Developer
|
|
Join Date: May 2011
Posts: 108
|
|
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
|
03-23-2013, 09:31 AM
|
Sarnak
|
|
Join Date: Mar 2013
Posts: 65
|
|
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
|
03-23-2013, 06:55 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
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.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
03-24-2013, 07:59 PM
|
Dragon
|
|
Join Date: Feb 2007
Posts: 659
|
|
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...
|
03-25-2013, 08:51 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
@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.
|
03-25-2013, 09:27 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
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.
|
03-25-2013, 09:42 AM
|
Developer
|
|
Join Date: Feb 2009
Location: Cincinnati, OH
Posts: 512
|
|
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.
|
03-25-2013, 11:12 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
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!
|
03-25-2013, 11:42 AM
|
Discordant
|
|
Join Date: Oct 2004
Location: In a house
Posts: 377
|
|
Works like a charm now. Thanks for pointing me in the right direction bad_captain!
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 05:19 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|