[narcberry]

I went ahead and added the column with default data ('0' as per the schema)

ALTER TABLE spawnentry ADD COLUMN spawn_limit tinyint(4) NOT NULL DEFAULT '0';

It took care of the error but I get a new error that seemed to be the same problem revisited:

Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance,  spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, spawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.spawngroupID=spawn2.spawngroupID AND zone='cabeast' ORDER by chance' #1054: Unknown column 'spawnentry.npcID' in 'on clause'

So I went ahead and tried to add that column too:

ALTER TABLE spawnentry ADD COLUMN npcID int(11) NOT NULL DEFAULT '0';
ERROR 1060 (42S21): Duplicate column name 'npcID'

I dont understand why it reports an unknown column when it exists... or why there are multiple database errors with a fresh install.