Quote:
|
Originally Posted by calranthe
Error loading NPCs from database. Bad query.
(many many of this line)
Error loading NPCs from database. Bad query.
|
That is probably happening because the server is having trouble reading from your npc_types table. If I remember correctly, it should not stop you from zoning in. Someone should probably add code to take out some redundant messages, al la syslog ("last message repeated 5 times").
For your testing purposes, this should be the query that the eqemu server is running on your DB that causes this error:
Code:
SELECT npc_types.id,npc_types.name,npc_types.level,
npc_types.race,npc_types.class,npc_types.hp,
npc_types.gender,npc_types.texture,npc_types.helmtexture,
npc_types.size,npc_types.loottable_id,
npc_types.merchant_id,npc_types.banish,npc_types.mindmg,
npc_types.maxdmg,npc_types.npcspecialattks,
npc_types.npc_spells_id,npc_types.d_meele_texture1,
npc_types.d_meele_texture2,npc_types.walkspeed,
npc_types.runspeed,npc_types.fixedz,
npc_types.hp_regen_rate,npc_types.mana_regen_rate,
npc_types.aggroradius,npc_types.bodytype,
npc_types.npc_faction_id,npc_types.face,
npc_types.see_invis,npc_types.see_invis_undead,
npc_types.lastname,npc_types.qglobal,npc_types.AC,npc_types.npc_aggro
FROM npc_types,spawn2 WHERE spawn2.zone='innothule'
AND npc_types.id=spawn2.id