[Critmonster]

I am getting an error when trying to buy a merc.


What I am not getting is why it is seeing m_stats.attack_delay at all. In both my mercs_stats table and vwmercnpctypes there is no column called attack_delay.

SELECT
			ms.merc_npc_type_id,
			'' AS name,
			ms.clientlevel,
			ms.level,
			mtyp.race_id,
			mstyp.class_id,
			ms.hp,
			ms.mana,
			0 AS gender,
			mai.texture,
			mai.helmtexture,
			ms.attack_speed,
			ms.STR,
			ms.STA,
			ms.DEX,
			ms.AGI,
			ms._INT,
			ms.WIS,
			ms.CHA,
			ms.MR,
			ms.CR,
			ms.DR,
			ms.FR,
			ms.PR,
			ms.Corrup,
            ms.mindmg,
            ms.maxdmg,
            ms.attack_count,
			ms.special_abilities,
			mwi.d_melee_texture1,
            		mwi.d_melee_texture2,
			mwi.prim_melee_type,
			mwi.sec_melee_type,
			ms.runspeed,
			ms.hp_regen_rate,
			ms.mana_regen_rate,
			1 AS bodytype,
			mai.armortint_id,
			mai.armortint_red,
			mai.armortint_green,
			mai.armortint_blue,
			ms.AC,
			ms.ATK,
			ms.Accuracy,
			ms.spellscale,
			ms.healscale
			FROM merc_stats ms
			INNER JOIN merc_armorinfo mai
			ON ms.merc_npc_type_id = mai.merc_npc_type_id
			AND mai.minlevel <= ms.level AND mai.maxlevel >= ms.level
			INNER JOIN merc_weaponinfo mwi
			ON ms.merc_npc_type_id = mwi.merc_npc_type_id
			AND mwi.minlevel <= ms.level AND mwi.maxlevel >= ms.level
			INNER JOIN merc_templates mtem
			ON mtem.merc_npc_type_id = ms.merc_npc_type_id
			INNER JOIN merc_types mtyp
      ON mtem.merc_type_id = mtyp.merc_type_id
      INNER JOIN merc_subtypes mstyp
      ON mtem.merc_subtype_id = mstyp.merc_subtype_id

Server is 2 days old, windows, followed the wiki guide for server and mercs. Have also changed merchant ID's, corrected spelling issues in Source_view.sql ect. Server works great. Liaison's work, just can not spawn the actual merc.

I really appreciate any help given.