Waffen batchen buggt

[Lemuna]

Ich hab mir Tyras 7er runtergeladen und mir bei wow-v gleich mal ne Waffe erstellt^^ Nur wenn ich jetz mit navicat auf world db geh -> execute Batchfile
kommt immer

[Err] 1062 - Duplicate entry '21400' for key 1
[Err] INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, 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, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, 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, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (21400,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);VALUES (21400,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);
[Msg] Finished - Unsuccessfully

Plx help^^

[Kleiner Dodo]

So wie ich das sehe ist die "Entry ID" doppelt vergeben, stell mal ne andere ein und versuchs nochmal

[Vulcanraven]

Originally Posted by psYcho aka. SLDZ

So wie ich das sehe ist die "Entry ID" doppelt vergeben, stell mal ne andere ein und versuchs nochmal

Genau die ID 21400

[Err] 1062 - Duplicate entry '21400' for key 1

[Lemuna]

n1 thx

[Lemuna]

Hmm hab die ID geänder nu kommt

[Err] 1054 - Unknown column 'name' in 'field list'
[Err] INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, 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, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, 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, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (12000,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);VALUES (12000,2,8,-1,"Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen","Schlächter der Titanen",31996,4,0,100000,100000,17,-1,-1,120,70,0,0,0,0,0,0,0,0,1,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,120,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,160,0,0,7600,1,0,0,0,0,28735,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0, 0,0,100,0,0,0,0,1,0,2,0,4,0,0,0,0,0,0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Edit: Help plx keine ahnung was da los is -.-

[Lemuna]

anyone knows whats my fault?

[Murachacha]

Bei mir dass gleiche -.-

[Err] 1146 - Table 'mangos.creature_names' doesn't exist
[Err] INSERT INTO `creature_names` VALUES ('235001', 'Gott der Natur', '', '', '0', '10', '0', '0', '0', null, '2160', '0', '0', '0', '1', '1', null, null);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

son scheiß kann weder npcs noch items ein batchen -.-

[Kleiner Dodo]

Kann es sein, dass du (Murachacha) die .sql Datei in die Falsche DB Batchen willst? Was anderes würde mir jetzt nicht einfallen

[Ediso]

@Muracaha: Du machst was falsch:1) Entweder wie gesagt Falsche DB
2) Oder du hast ein Antrix und Batch die Mango datei

[Battleman99]

leute hab ne frage hab mir ne waffe gemacht aber wenn ich sie im spiel holen will kommt nur so ein rotes fragezeichnen im inventar und ich kann sie net anlegen

hoffe ihr könnt helfen

[gore28]

also bei mir kommt immer

[Err] 1054 - Unknown column 'ExtendedCost' in 'field list'
[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, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, 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, ExtendedCost, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
VALUES (88388,2,2,-1,'Sunstrider`s Longbow',48294,5,0,0,00001,00001,15,-1,-1,171,70,0,0,0,0,0,0,0,1,0,0, 3,15, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0, 1,0,259,383,0,82,140,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,3000,2,100,10149,2,0,0,0,0,44972,1,0,0,0,0,46 699,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'An heirloom of the Sunstrider Dynasty, this bow`s hilt feels warm to the touch and bowstring almost ethereal.',0,0,0,0,0,1,0,0,0,0,0,135,0,0,0,0,2,0,2 ,0,0,0,75,0,0,0,0,'internalitemhanler',0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------



kann mir da wer helfen?

[Gordge]

Suchfunktion hat :



ausgeworfen... les mal den letzten Post....

[hikataru]

Originally Posted by Battleman99

leute hab ne frage hab mir ne waffe gemacht aber wenn ich sie im spiel holen will kommt nur so ein rotes fragezeichnen im inventar und ich kann sie net anlegen

hoffe ihr könnt helfen

JA das ist bi den meisten so zieh sie per Drag and Drop ( aufs item klicken mit links klick dan und das "c" fenster rein) an

mfg


<----

[fbsdfh]

einfach rüberziehen -.- standart bei emulatoren... hoffe konnte helfen

[Lemuna]

Das is nich standart..... Bei den meisten Emulatoren gehts auch bugfrei vorallem wenn du einfach vorhande Items veränderst