Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers

Support::Linux Servers Support forum for Linux EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2015, 06:35 PM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
Default How are Mercs turned ON?

Has anyone tried turning on Mercs recently? I found the mercs.sql script and ran it, then went in the rule_values table and turned them on. Reset the server afterward. Mercs still are not activating. All the usual merc liasons say is something about keeping the area clean...

Is there a specific set of scripts or specific set of optional scripts that need to be done in a specific order to get them to work now?

The link in the windows setup guide points to this webpage:
http://wiki.eqemulator.org/p?Enabling_Mercenaries

That basically states to run mercs.sql, then run 2 sql statements, one to turn it on in the rules, and the other to change the npc types, so that they can be hired. What happens is the merc UI comes up, you select the merc, then when you click on the "Hire" button you get a long red set of sql:

[MySQL Error] 1054: Unknown column "m_stats.attack_delay in the 'field list'


There are many patches in the utils/sql/git/required and optional directories. Which of these is necessary to make mercs work now?

thanks,
Riklin (Halls Havoc)
Reply With Quote
  #2  
Old 12-18-2015, 06:48 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Quote:
[MySQL Error] 1054: Unknown column "m_stats.attack_delay in the 'field list'
I ran across that issue last night helping someone else..

There are actually 3 queries on that page..did you run the 'class' change one?


Try running this query:
Code:
UPDATE `db_version` SET `version` = '7999';
that will set your db version to just before the 'mercs.sql' load..

..and then run eqemu_update.pl manually and select option '3' until all of the updates have taken.


The guy I was helping said he got mercs to work by doing that..but, I don't think he's online just yet, so i haven't gotten any more feedback from him.

Make sure your database is backed up before trying that, too.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #3  
Old 12-18-2015, 10:55 PM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
Default

There are people on the server right now, but when I get a moment, I'll restart the server and do these updates. If this can be confirmed as a reliable fix, the mercs page needs to get this added to it...

Thanks Uleat...
Reply With Quote
  #4  
Old 12-19-2015, 01:33 AM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
Default

This doesn't work. The script 2013_03_01_Merc_Rules_and_Equipment.sql fails. From what I can tell it's failing because of a foreign key problem with the table merc_inventory.

There is one other script that won't run also. 2013_02_25_Impr_HT_LT.sql

I'll see if I can figure out what's going on there tomorrow, when I'm not so tired...

This used to work easily, but I suspect a lot of servers don't use mercs, so there aren't many people "testing" it...
Reply With Quote
  #5  
Old 12-19-2015, 02:08 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

That's what I'm concerned about atm..

..mercs are updating without having the initial file sourced...


And, I suspect, that once mercs.sql is sourced in, some of that information is being reverted. (Which is why mercs really need to be fully installed in the peq db distro.)


I'll take a look at those scripts and see if I can figure out what's causing their issues.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #6  
Old 12-19-2015, 04:04 PM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
Default

Thanks Uleat!

I've bandaided it by removing the foreign key constraint. It works and the nasty red messages do not show up when a merc is hired, but I suspect even though the animation shows them all geared up, I suspect they really have no gear.
Reply With Quote
  #7  
Old 12-21-2015, 08:03 PM
sudosteve
Fire Beetle
 
Join Date: Dec 2015
Posts: 2
Default

For what it's worth, I had issues getting my merc list to populate on the merc vendors. Turns out I just needed to update the Mercs:AllowMercs rule on all rule sets, not just rule set 10 (poknowledge is using pop+ rules, not eqemu_default apparently). I ran this query to update them all:

UPDATE `peq`.`rule_values` SET `rule_value`='true' WHERE `rule_name`='Mercs:AllowMercs';

Be sure to swap out "peq" with your database name first, if different. Hopefully this saves a few gray hairs somewhere.
Reply With Quote
  #8  
Old 12-21-2015, 10:22 PM
Burningsoul
Discordant
 
Join Date: Oct 2009
Posts: 310
Default

That rules set value can kiss my sarnak. It has a use but for the average person it is such a headache at first.
Reply With Quote
  #9  
Old 12-22-2015, 01:16 AM
Riklin
Hill Giant
 
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
Default

That rule_values issue isn't the one that's causing mercs to not work. I had already set them all to true.
Reply With Quote
  #10  
Old 01-29-2016, 02:35 AM
Warking
Hill Giant
 
Join Date: Mar 2012
Location: Norrath
Posts: 132
Default

delete, I had a compile issue, fixed
Reply With Quote
  #11  
Old 01-29-2016, 09:18 AM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Quote:
Originally Posted by Riklin View Post
This doesn't work. The script 2013_03_01_Merc_Rules_and_Equipment.sql fails. From what I can tell it's failing because of a foreign key problem with the table merc_inventory.

There is one other script that won't run also. 2013_02_25_Impr_HT_LT.sql

I'll see if I can figure out what's going on there tomorrow, when I'm not so tired...

This used to work easily, but I suspect a lot of servers don't use mercs, so there aren't many people "testing" it...
Just to reinforce this being a problem. All of my servers, when I upgrading them from January 2015 source, ran into these two scripts failing on the automatic upgrade.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:33 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3