Got a good one here, stumped....
 

Ok, when I zone into gfaydark there ar eonly a few mobs up when there should be 379. Also when I do #showstats on one of the mobs (a_wolf_pup00) it says it is SpawnGroupID 157, but when I look in the database 157 is a_forest_bat12, I verified this in the spawnentry table and 157 is npcid 6 which is a_forest_bat. Here is the output from Zone.exe when Gfay boots up, not sure what the stuff in bold is but I think it is related. Please any help, I have completely gone through the database and cannot find what is wrong.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 160 commands loaded
[Status] Weather should change in 6764 seconds
Init: Loading zone lists, zone state or spawn listElapsed time: 516
Spawn2count: 379
gmspawntype_count: 1
npc_count: 6
npcloot_count: 0
Zone state loaded.
, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 54; Time Offset = 0
Reading zhdr file './cfg/gfaydark.cfg'
Using database for safe coords.
Zone safe coords are x = 10; y = -20; z= 0
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for gfaydark ...
[Status] Done loading doors for gfaydark ...
[Status] Zone Bootup: gfaydark (54)
Connected to worldserver: 111.11.1.11:9000

1) Who compiled 0.5.7-DR2 for you, and
2) what db is it? i would reccomend only using TCSMyWorld db's (npcmovdb).

I compiled the source myself using Visual Studio .NET 2003.

I am using a version of TCMyWorld's database but with custom content, including all of the npc's and spawn tables, but I did not alter any of the tables, only the entries.

Did you change anything in the database?

Re: Got a good one here, stumped....
 

Are you looking at the right table? Spawn Groups can have multiple spawn IDs in them (so that they don't always spawn the same mobs every time). You'll need to look at all the SpawnEntryIDs that are associated with spawngroup 157. Just do a "SELECT SpawnEntryID FROM spawngroup WHERE SpawnGroupID=157;" and it should show you all the mobs that should spawn at that point.

P.S.
I'm at work right now so I don't have a copy of the DB handy to get the correct columns in the search. You may need to change the table/column names used in the search.

I fixed the problem....I emptied the Zone_State_Dump table and now mobs are spawning. Found this out by accident.