Items in DB batchen

Unreall · 08/09/2010, 10:33

hiho wenn ich items in die DB patchen will bei mangos 3.3.5 dann bekomm ich immer die Fehlermeldung hier:
[Err] 1062 - Duplicate entry '16777215' for key 'PRIMARY'
[Err] INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (999999999, 2, 0, -1, "Unreall", 45691, 6, 0, 0, 56000000, 10000, 13, -1, -1, 750, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 25000, 3, 25000, 4, 25000, 5, 25000, 6, 25000, 7, 25000, 12, 25000, 0, 0, 0, 0, 0, 0, 1234567, 1234567, 0, 9999, 9999, 1, 2100, 255, 255, 255, 255, 255, 255, 1000, 0, 0, 17713, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 3, "only forunreall", 0, 0, 0, 0, 0, 1, 3, 0, 0, 213, 0, 5000, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);
[Msg] Finished - Unsuccessfully
__________________________________________________ ____

was heißt das?

Gordge · 08/09/2010, 10:55

Quote:

[Err] 1062 - Duplicate entry '16777215' for key 'PRIMARY'

sollte doch eindeutig sein... die ID gibt es schon

Magisch · 08/11/2010, 15:25

Einfach die Entry im Batchcode in eine höhere Zahl (z.b 220000) ändern. das sieht dann so aus =

Code:

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (220000, 2, 0, -1, "Unreall", 45691, 6, 0, 0, 56000000, 10000, 13, -1, -1, 750, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 25000, 3, 25000, 4, 25000, 5, 25000, 6, 25000, 7, 25000, 12, 25000, 0, 0, 0, 0, 0, 0, 1234567, 1234567, 0, 9999, 9999, 1, 2100, 255, 255, 255, 255, 255, 255, 1000, 0, 0, 17713, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 3, "only forunreall", 0, 0, 0, 0, 0, 1, 3, 0, 0, 213, 0, 5000, 0, 0, 0, 0, 2, 0, 2, 0, 2, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);

Quote:

sollte doch eindeutig sein... die ID gibt es schon

Ich denke , seine angegebene ID war einfach zu hoch und hat den Integer-Rahmen gesprengt^^

Snoud · 08/12/2010, 15:16

aber ich würd aufpassen wenn du die entryID zu hoch machst, findest du sie dann im wow ned mehr.

nightcore12.5 · 08/12/2010, 15:35

aber ich würd aufpassen wenn du die entryID zu hoch machst, findest du sie dann im wow ned mehr.

Da brauch ich mich nich zu wundern warum ich sie nich mit additem bekomme -.-.
Gut das ich noch mal hier nachgesehen hab thanks ^^