-
Newbie
mangos rev 3959 db related issue
I've got it working, but I'm not comfortable with something; I get this output when mangosd.exe passes through the 'creature_loot_template' table:
2007-06-28 16:18:03 ERROR:Some items can't be succesfully looted: not exist or have in chance field value < 0.000001 with quest chance ==0 in `creature_loot_template` DB table . List:
loot entry = 21213 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21213 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21213 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 20052 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 20052 item = 31911 mincount = 1 maxcount = 1 (not exist)
loot entry = 21213 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 20052 item = 31912 mincount = 1 maxcount = 1 (not exist)
loot entry = 21213 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21251 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21246 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21301 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21301 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21298 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21298 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21301 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21251 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 21299 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21299 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21217 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21217 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 21215 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21216 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21216 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21298 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21298 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21263 item = 31911 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 32944 mincount = 1 maxcount = 1 (not exist)
loot entry = 21216 item = 32516 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29947 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29924 mincount = 1 maxcount = 1 (not exist)
loot entry = 21229 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21229 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21229 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21226 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21225 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21224 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 20034 item = 31906 mincount = 1 maxcount = 1 (not exist)
loot entry = 21220 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21216 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 32895 mincount = 1 maxcount = 1 (not exist)
loot entry = 20032 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21224 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21225 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21225 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 21227 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21221 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21229 item = 31893 mincount = 1 maxcount = 1 (not exist)
loot entry = 21230 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21230 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21230 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21231 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 21231 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21251 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21251 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 32267 mincount = 1 maxcount = 1 (not exist)
loot entry = 21301 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 20032 item = 30281 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29948 mincount = 1 maxcount = 1 (not exist)
loot entry = 20033 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 18692 item = 32569 mincount = 1 maxcount = 1 (not exist)
loot entry = 17767 item = 30868 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 20032 item = 31875 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29987 mincount = 1 maxcount = 1 (not exist)
loot entry = 21216 item = 30301 mincount = 1 maxcount = 1 (not exist)
loot entry = 21226 item = 30280 mincount = 1 maxcount = 1 (not exist)
loot entry = 21214 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21217 item = 30303 mincount = 1 maxcount = 1 (not exist)
loot entry = 21217 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29998 mincount = 1 maxcount = 1 (not exist)
loot entry = 20052 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 21246 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 20042 item = 31915 mincount = 1 maxcount = 1 (not exist)
loot entry = 20039 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 20039 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 20031 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 20031 item = 31902 mincount = 1 maxcount = 1 (not exist)
loot entry = 21218 item = 30281 mincount = 1 maxcount = 1 (not exist)
... now it says that those items either those items don't exist or have in chance field value < 0.000001 with quest chance ==0. I've checked some of the items, and they seem to be ok. What else could be wrong?
Either than that, I'm surprised that no other errors turned up. Pretty good work.
-