Items in DB batchen

08/09/2010 10:33 Unreall#1
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?
08/09/2010 10:55 Gordge#2
Quote:
[Err] 1062 - Duplicate entry '16777215' for key 'PRIMARY'
sollte doch eindeutig sein... die ID gibt es schon
08/11/2010 15:25 Magisch#3
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^^
08/12/2010 15:16 Snoud#4
aber ich würd aufpassen wenn du die entryID zu hoch machst, findest du sie dann im wow ned mehr.
08/12/2010 15:35 nightcore12.5#5
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 ^^