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?
|
Threaded Mode
