Mercenaries

[Armm]

i compiled the latest version alright, i went to source in the merc_rules_and_equipment.sql statement and i get errors about primary key for first two lines which i fixed because they already exist...

However alter table also got tripped up claiming it couldnt find mercbuffs, in my case it was already named properly to merc_buffs??

The final error i couldnt get past and i tried this in mysqldump and heidesql... once it get to the part where it wants to create merc_inventory it throws an error saying..

DROP TABLE IF EXISTS merc_inventory;
CREATE TABLE merc_inventory (
	merc_inventory_id      	int(10) unsigned NOT NULL auto_increment,
	merc_subtype_id       	int(10) unsigned NOT NULL default '0',
	item_id           	int(11) unsigned NOT NULL default '0',
	min_level       	int(10) unsigned NOT NULL default '0',
	max_level   		int(10) unsigned NOT NULL default '0',
	PRIMARY KEY  (merc_inventory_id),
	KEY FK_merc_inventory_1 (merc_subtype_id),
	CONSTRAINT FK_merc_inventory_1 FOREIGN KEY (merc_subtype_id) REFERENCES merc_subtypes (merc_subtype_id)
);
/* SQL Error (1005): Can't create table 'peq.merc_inventory' (errno: 150)

Foreign key constraint is incorrectly formed */

[Armm]

Also if you do a SHOW INNODB STATUS you get this relevant portion..

LATEST FOREIGN KEY ERROR\n------------------------\n130301 10:49:53 Error in foreign key constraint of table peq/merc_inventory:\n FOREIGN KEY (merc_subtype_id) REFERENCES merc_subtypes (merc_subtype_id)):\nCannot resolve table name close to:\n (merc_subtype_id))\n------------\n

[Furniture]

Heres the exact error I am getting

Originally Posted by Armm

The final error i couldnt get past and i tried this in mysqldump and heidesql... once it get to the part where it wants to create merc_inventory it throws an error saying..

DROP TABLE IF EXISTS merc_inventory;
CREATE TABLE merc_inventory (
	merc_inventory_id      	int(10) unsigned NOT NULL auto_increment,
	merc_subtype_id       	int(10) unsigned NOT NULL default '0',
	item_id           	int(11) unsigned NOT NULL default '0',
	min_level       	int(10) unsigned NOT NULL default '0',
	max_level   		int(10) unsigned NOT NULL default '0',
	PRIMARY KEY  (merc_inventory_id),
	KEY FK_merc_inventory_1 (merc_subtype_id),
	CONSTRAINT FK_merc_inventory_1 FOREIGN KEY (merc_subtype_id) REFERENCES merc_subtypes (merc_subtype_id)
);
/* SQL Error (1005): Can't create table 'peq.merc_inventory' (errno: 150)

Foreign key constraint is incorrectly formed */

[bad_captain]

Did you have all of the previous sql updates applied? I compiled that script from all of my changes and applied it as one to my secondary database, and it ran correctly.

Do you have to table merc_subtypes? what is its primary key?

Had you somehow run the script before? Those rules are new, and should not already exist.

Did you resource the database? Maybe it was already put in peq db?

[Armm]

i just dropped all merc related tables except rule values, modified rule inserts to updates, and it went in this time. Sorry, its a bit confusing knowing what to apply first and some of that stuff is included in PEQ 2506(?) or whatever latest is.

[Armm]

I can confirm that the duplicate merc entry bug seems fixed. I can also confirm that trying to hire a merc above level 85 doesnt crash the zone anymore, you just get a message saying it failed, which is fine.

Thanks for the tips, info, and fixes, very much appreciated.

[bad_captain]

Originally Posted by Armm

I can confirm that the duplicate merc entry bug seems fixed. I can also confirm that trying to hire a merc above level 85 doesnt crash the zone anymore, you just get a message saying it failed, which is fine.

Thanks for the tips, info, and fixes, very much appreciated.

Good to hear! While I do test it all, it's nice to get feedback that it works for others as well, since others have different play styles or setups that I may not be able to reproduce.

[rencro]

Table merc_subtypes is MyISAM when building new db from 2506, will not take FK until I changed it to InnoDB..

This is in relation to 2013_03_1_Merc_Rules_and_Equipment.sql with a new db sourced from peqdb_rev2506...

[Furniture]

Tonight I started building an eqemu server after many months of inactivity and I am encountering this same exact error with the duplicate keys and it wont create the mercs_inv table. Any help would be appreciated!

[bad_captain]

Yeah, I would prefer to have 1 script for all things merc, but we have seen the issues it causes, so this is the best we can do. I'm not sure what else can be done, but it would be nice if there was some way to know what updates peq has included so people would know what to and what not to source in. Maybe a list of applied updates that can be compared to before sourcing in updates.

Something like db version, but for applied updates? A table with rows for all of the updates included in that version? I don't know.

[bad_captain]

No problem. It was actually an easier fix than I thought. I just had to have to time to sit down and debug through the entire suspend/dismiss procedure to figure out what it was.

I plan to tackle dps mercs next, I just need more data on spells cast / skills used, especially for Journeyman mercs (using different stances). I have a decent idea of Apprentice mercs at least to 65. After that, I'm clueless, but I should be able to come up with something. I just hate using a melee DPS merc because they are so picky on when to attack (they hate getting aggro and their range to decide to join the fight when the main tank is also the puller is miniscule).

Timers still need work, and every once in a while I don't get stances when hiring (but suspending/unsuspending or zoning fixes it), but I think they are starting to work pretty well.

I'll try to clean up the sql as well. I'm not sure why it would work on mine, but not using the peq download.

[bad_captain]

Requesting Data- if you play on live (or test) and you use mercs, I could use some data. I'm trying to compile spell lists for caster dps specifically, but can use any other data.

I have pretty good data between lvl 60 - 65. I will be creating lvl 1 toons to get data, but this will take a lot of time. If anyone has data for any level, I would appreciate it. If you have it, lvl, stance, and proficiency should be known ( but not required) . I could also use /logs if you don't want to compile it on your own. ( just need the message when the spell hits) .

I have basic nuke code working on my local machine, so spell lists are all I need now. Once stances are fully in, then the spell casting can be further tweaked.

Thanks.

[Shiny151]

Hey captain; my mercs don't rez for some reason. I'm up to date with the most recent build as of last night and I'm pretty sure i've got your .sql order down.

Clerics have really only been hitting my group with Virtue and that's about it.

How can I resolve this?

Thanks!

[bad_captain]

What level, proficiency, tier?

select * from merc_spell_list_entries
where merc_spell_list_id = 3
and spell_type = 65536;

what does that return? that should list the 8 resurrect spells.

If it returns nothing, check that sql for those spells has been run. Also check spell_type in that same table for the datatype. I think at one time I had it as a tinyint, should be int.

Other than that, the corpse's owner should be in your group.

Do they heal at all, or just buff? What class are you?

[Shiny151]

Originally Posted by bad_captain

What level, proficiency, tier?

select * from merc_spell_list_entries
where merc_spell_list_id = 3
and spell_type = 65536;

what does that return? that should list the 8 resurrect spells.

If it returns nothing, check that sql for those spells has been run. Also check spell_type in that same table for the datatype. I think at one time I had it as a tinyint, should be int.

Other than that, the corpse's owner should be in your group.

Do they heal at all, or just buff? What class are you?

Thanks. I'll check it out when i get home. Levels range from 66-69 Balanced, Journeyman, T2. I've not played around with much else. They heal and buff but they don't keep mana well at all. Usually 50% or OOM; even idle. (using UF and RoF clients) Proficiencies have no noticeable impact; most likely i've got something jacked in my sql then. No issues with melee, they do their jobs well. Altho i think it's hilarious that the Vah Shir grunt and jump in your face when a mob dies.

Thanks for the tips.