Zone and NPCS

[darkdonno]

Eqemu version: 0.6.0-DR2
Database: peq_kunark- RC1


From Zone.exe

[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
Error in DBLoadNPCFactionLists query3 'SELECT npc_faction_id, faction_id, value,
npc_value FROM npc_faction_entries order by npc_faction_id' #1054: Unknown colu
mn 'npc_value' in 'field list'
Error: EMuShareMem: DLLLoadNPCFactionLists: !cbDBLoadNPCFactionLists
[Error] Loading npcs faction lists FAILED!

[Sarepean]

Try this:

ALTER TABLE npc_faction_entries ADD npc_value TINYINT UNSIGNED DEFAULT '0' NOT NULL;

UPDATE npc_faction_entries SET npc_value=1 WHERE value<0;

-Sarepean