(Blank screen) after server list. full info help.

[m0oni9]

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:

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