I was having this prob also so I ran these sql statements.
select
spawnentry.*
from
spawnentry
left join
npc_types
on
spawnentry.npcID=npc_types.id
where
npc_types.id is null;
and
select
spawnentry.*
from
spawnentry
left join
spawngroup
on
spawnentry.spawngroupID=spawngroup.id
where
spawngroup.id is null;
The first statement returned two rows. I removed these entries from the database and was able to get pass the charater screen and into the zone. I'm not sure if this did it because I did alot of other data normalization and came up with a completly different database than the one I initially started with. But it works.
|