Zdravím. Nebudu to protahovat a rovnou to napíšu Pokaždé, když se na TC2 snažím vložit item, který jsem vytvořil na wow-v.com, tak mne to hodí error. Požívám SQLyog a můžu se hned jeden dát...
Error occured at:2009-10-09 10:57:14
Line no.:2
Error Code: 1062 - Duplicate entry '1292' for key 1
Query:
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 (555001, 2, 1, -1, "Havoc, Blade of the Labyrinth", 47011, 5, 0, 0, 0, 0, 17, -1, -1, 262, 80, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 4, 132, 7, 184, 44, 101, 31, 87, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 890, 1112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3200, 0, 0, 33480, 2, 0, 0, 0, 0, 40880, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "Ancient weapons such as this were lost under Auchindoun", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10)
Error occured at:2009-10-10 11:08:28
Line no.:2
Error Code: 1264 - Out of range value adjusted for column 'ItemLevel' at row 1
Zkoušel jsem s tím snad všechno, ale prostě mi to nejde vložit do té databáse