Did an update, Zone Server stopped did Schema change????

[Freejack]

Ok got this all fixed up and working again, I am not the greatest at sql queries but I can figure out data.

I now have a spam issue in the chat windows of TYou have been charged a mercenary upkeep cost of 3 plat, and 1 gold and your mercenary upkeep cost timer has been reset to . and that is all I get over and over.....

Any ideas how to fix this one since it stems from my original issue of which I fixed with updating all the assets of maps and db updates.

Also getting a unknown column 'faction_amount' in 'field list" any idea how to fix this one too.

[03-08-2023 12:42:15] [Zone] [QueryErr] [1054] [Unknown column 'faction_amount' in 'field list']
[SELECT id, name, lastname, level, race, `class`, bodytype, hp, mana, gender, texture, helmtexture, heros

[Freejack]

Ok did a wipe and fresh install, all the NPC's just vanished during this entire situation.

Appears that it is the Mercs that caused this. I did the updates for the server using the script to pull db updates and that is where it all went wonky.

I did fresh install and enabled bots as normal and was about to do Mercs when I saw the script and saw the tables. The tables of which were in question . So Bots will be in and Mercs are out. Doesn't seem to be anyone actually maintaining Mercs and Bots actually works well enough.

Anyone have this issue you now know the cause.

[manawenuz]

Originally Posted by Freejack

Ok did a wipe and fresh install, all the NPC's just vanished during this entire situation.

Appears that it is the Mercs that caused this. I did the updates for the server using the script to pull db updates and that is where it all went wonky.

I did fresh install and enabled bots as normal and was about to do Mercs when I saw the script and saw the tables. The tables of which were in question . So Bots will be in and Mercs are out. Doesn't seem to be anyone actually maintaining Mercs and Bots actually works well enough.

Anyone have this issue you now know the cause.

Mercs definitely do work, but as you stated, they get much less use than bots these days. Just a heads up that if you have any future issues you may want to consider posting to the Eqemu discord. You'll likely get a lot more help there: https://discord.gg/QqqZcWWzwG

[Freejack]

Originally Posted by manawenuz

Mercs definitely do work, but as you stated, they get much less use than bots these days. Just a heads up that if you have any future issues you may want to consider posting to the Eqemu discord. You'll likely get a lot more help there: https://discord.gg/QqqZcWWzwG

Yes Mercs do work but something changed in the schema that made it break things. I like Mercs but sadly you only get one.