What's wrong with adding this item?

Results 1 to 2 of 2
  1. #1
    Apprentice Deathboy312 is offline
    MemberRank
    Sep 2006 Join Date
    17Posts

    What's wrong with adding this item?

    Hell once again, i come back with another issue. I got my server running fine with MaNGOS, ok so im using SQLyog to try to add items, i copy the code from the wow vandetta website into the "Querys" Tab and add them. Then i run this code:
    Code:
    INSERT INTO item_template (entry, class, subclass, unk0, name, name2, name3, name4, 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, ScriptName, DisenchantID)
    VALUES (90000,2,7,-1,"Illidarin sword","Illidarin sword","Illidarin sword","Illidarin sword",1542,6,0,0,50009999,999999999,13,-1,-1,70,70,0,0,0,0,0,0,0,50,1,0,1,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,10000,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,9331,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Illidans general sword.",0,0,0,0,0,1,3,0,0,0,0,999,0,0,0,0,0,0,1,0,2,0,0,0,0,0,"internalitemhanler",0);
    And then i get this:
    Code:
    
    Error Code : 1054
    Unknown column 'RandomProperty' in 'field list'
    (0 ms taken)
    
    What is wrong?


  2. #2
    Novice Argok is offline
    MemberRank
    Jul 2007 Join Date
    1Posts

    Re: What's wrong with adding this item?

    Have u tried to put 0 in the null slots instead of leavin blank?



Advertisement