How are Mercs turned ON?

[Uleat]

[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:

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.

[Riklin]

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...

[provocating]

Originally Posted by Riklin

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.