Little Help ?

[adriann54]

Hey...I got an error when I start MaNGOSD.exe

2009-07-19 23:30:32 Loading Loot Tables...
2009-07-19 23:30:32 
2009-07-19 23:30:32 creature_loot_template :
2009-07-19 23:30:32 
2009-07-19 23:30:32 >> Loaded 1 loot definitions (1 templates)
2009-07-19 23:30:32 ERROR:Table 'creature_loot_template' entry 80000 isn't creature entry and not referenced from loot, and then useless.

It says that 80000 is not a creature entry but in creature_template I have this creature :

insert into `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('80000','0','0','0','304','304','304','304','Chicken','',NULL,'3','5','500','500','100','100','100','7','7','0','8','1','0','100','200','0','10','1','2500','0','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','10000','10000','','0','3','1','1','0','0','0','0','0','0','1','0','0','0','');

While I am playing I can spawn this mob , but when I kill him it gives me only the money ( 1 gold ).

[kageb0shi]

hmmmmm...db issue

[adriann54]

How do I fix it ?

[kageb0shi]

update your database:)

or type this in query editor

first confirm entry is in table

use mangos;
select * from creature_loot_template where entry=80000;

and

use mangos;
select * from creature_template where entry=80000;

next

use mangos;
delete from creature_loot_template where entry=80000;
delete from creature_template where entry=80000;

I have latest db and 80000 is not listed in creature_loot_template or creature_template. Apparently chickens are supposed to drop loot.

[davemm]

How do I fix it ?

ask whoever made your database.