Register for your free account! | Forgot your password?

You last visited: Today at 08:01

  • Please register to post and access all features, it's quick, easy and FREE!

 

Waffen batchen buggt

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Oct 2006
Posts: 855
Received Thanks: 112
Waffen batchen buggt

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
Quote:
[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^^



Lemuna is offline  
Old   #2
 
elite*gold: 0
Join Date: Jan 2006
Posts: 387
Received Thanks: 23
So wie ich das sehe ist die "Entry ID" doppelt vergeben, stell mal ne andere ein und versuchs nochmal


Kleiner Dodo is offline  
Thanks
2 Users
Old   #3
 
elite*gold: 0
Join Date: May 2006
Posts: 7,805
Received Thanks: 4,570
Quote:
Originally Posted by psYcho aka. SLDZ View Post
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
Vulcanraven is offline  
Thanks
2 Users
Old   #4
 
elite*gold: 20
Join Date: Oct 2006
Posts: 855
Received Thanks: 112
n1 thx


Lemuna is offline  
Old   #5
 
elite*gold: 20
Join Date: Oct 2006
Posts: 855
Received Thanks: 112
Hmm hab die ID geänder nu kommt
Quote:
[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 is offline  
Old   #6
 
elite*gold: 20
Join Date: Oct 2006
Posts: 855
Received Thanks: 112
anyone knows whats my fault?
Lemuna is offline  
Old   #7
 
elite*gold: 0
Join Date: Feb 2008
Posts: 7
Received Thanks: 0
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 -.-
Murachacha is offline  
Old   #8
 
elite*gold: 0
Join Date: Jan 2006
Posts: 387
Received Thanks: 23
Kann es sein, dass du (Murachacha) die .sql Datei in die Falsche DB Batchen willst? Was anderes würde mir jetzt nicht einfallen
Kleiner Dodo is offline  
Old   #9
 
elite*gold: 0
Join Date: Feb 2008
Posts: 78
Received Thanks: 29
@Muracaha: Du machst was falsch:1) Entweder wie gesagt Falsche DB
2) Oder du hast ein Antrix und Batch die Mango datei
Ediso is offline  
Old   #10
 
elite*gold: 0
Join Date: May 2008
Posts: 7
Received Thanks: 0
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
Battleman99 is offline  
Old   #11
 
elite*gold: 0
Join Date: Jun 2006
Posts: 9
Received Thanks: 1
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?
gore28 is offline  
Old   #12
 
elite*gold: 62
Join Date: Apr 2006
Posts: 12,492
Received Thanks: 2,859
Suchfunktion hat :



ausgeworfen... les mal den letzten Post....
Gordge is offline  
Old   #13
 
elite*gold: 0
Join Date: Jun 2008
Posts: 6
Received Thanks: 0
Quote:
Originally Posted by Battleman99 View Post
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


<----
hikataru is offline  
Old   #14
 
elite*gold: 0
Join Date: Jan 2008
Posts: 10
Received Thanks: 0
einfach rüberziehen -.- standart bei emulatoren... hoffe konnte helfen
fbsdfh is offline  
Old   #15
 
elite*gold: 20
Join Date: Oct 2006
Posts: 855
Received Thanks: 112
Das is nich standart..... Bei den meisten Emulatoren gehts auch bugfrei vorallem wenn du einfach vorhande Items veränderst


Lemuna is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Waffen batchen mit novos 0.3.6
huhu wollt mal fragen wie man mit NoVos 0.3.6 waffen batcht, navicat hab ich bitte genau erklären, bin noch ein neuling in der privaten WoW...
2 Replies - WoW Private Server
Sachen Rein Batchen waffen npc [Navicat]... Fehler bitte helfen
Hi Leute habe folgene porbleme server alles läuft super wollte waffen und npc´s ein batchen mache es mit navicat Verbindung VerbindungsName:...
4 Replies - WoW PServer Hosting
WOW EIGENE WAFFEN BATCHEN
Hallo liebe com , bin sehr neu vill koennt ihr mir helfen oder kennt euch aus damit also ich wollt auf einen server den mein freund erstellt...
1 Replies - Say Hello
Waffen Batchen
allso ichhabe waffen erstellt mit wow-v.com aber weis nciht wie ich die ins spiel rein mache allso ob ichs mit navigate machem mus oder wie zb über...
13 Replies - WoW PServer Hosting
waffen, rüss usw. batchen geht einfach ned...=(
hallo liebe community.... immer wenn ich einpaar waffen oder so batchen will kommt dieser error 1146 - Table 'ascent.creature_template'...
1 Replies - WoW Main - Discussions / Questions



All times are GMT +2. The time now is 08:01.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.