Unknown column 'faction_amount"

[Kennebec]

I built a new server and restored my databases. The schema was from December 2021. Then I ran the eqemu_server.pl and updated the database schema.

Now I don't have any spawns in any zones. When I log in my GM account I am seeing an error "(1054)(Unknown column 'faction_amount' in field list')

Full message:
[1054] [Unknown column 'faction_amount' in 'field list']
[SELECT id, name, lastname, level, race, `class`, bodytype, hp, mana, gender, texture, helmtexture, herosforgemodel, size, hp_regen_rate, hp_regen_per_second, mana_regen_rate, loottable_id, merchant_id, alt_currency_id, npc_spells_id, npc_spells_effects_id, npc_faction_id, adventure_template_id, trap_template, mindmg, maxdmg, attack_count, npcspecialattks, special_abilities, aggroradius, assistradius, face, luclin_hairstyle, luclin_haircolor, luclin_eyecolor, luclin_eyecolor2, luclin_beardcolor, luclin_beard, drakkin_heritage, drakkin_tattoo, drakkin_details, armortint_id, armortint_red, armortint_green, armortint_blue, d_melee_texture1, d_melee_texture2, ammo_idfile, prim_melee_type, sec_melee_type, ranged_type, runspeed, MR, CR, DR, FR, PR, Corrup, PhR, see_invis, see_invis_undead, qglobal, AC, npc_aggro, spawn_limit, attack_speed, attack_delay, findable, STR, STA, DEX, AGI, _INT, WIS, CHA, see_hide, see_improved_hide, trackable, isbot, exclude, ATK, Accuracy, Avoidance, slow_mitigation, version, maxlevel, scalerate, private_corpse, unique_spawn_by_name, underwater, isquest, emoteid, spellscale, healscale, no_target_hotkey, raid_target, armtexture, bracertexture, handtexture, legtexture, feettexture, light, walkspeed, peqid, unique_, fixed, ignore_despawn, show_name, untargetable, charm_ac, charm_min_dmg, charm_max_dmg, charm_attack_delay, charm_accuracy_rating, charm_avoidance_rating, charm_atk, skip_global_loot, rare_spawn, stuck_behavior, model, flymode, always_aggro, exp_mod, heroic_strikethrough, faction_amount FROM npc_types WHERE id = 57034]

Is there an additional database update needed?

Thanks for any help.

[Kennebec]

I think I found it. I looked at the latest PEQ Database archive and one from 9 days earlier. This was in the latest PEQ and not in the older version for the build of table npc_types:

`heroic_strikethrough` int(11) NOT NULL DEFAULT 0,
`faction_amount` int(10) NOT NULL DEFAULT 0,

When I get home tonight I will try rebuilding just that table after the install and database update.

Leaving this here for posterity in case anyone else runs into the issue.

[joligario]

All the database changes are in the source sql folder (https://github.com/EQEmu/Server/tree...l/git/required). Also, running the database check in eqemu_server.pl will run any missing updates. If it didn't catch it, you can always roll back your version in the database to an earlier one to force the update.

[Kennebec]

I did run the database updater first. there were a couple of recent updates not caught.