Missing columns "name2" ,"name3" and "name4"
Does any1 know how to add created item from wow-v.com in heidisql to Fusion arcemu 3.2.2? When i try it juts keeps saying "SQL Error: Unkown column "name2" in "field list"
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, 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, ReqDisenchantSkill, unk2)
VALUES (12345, 2, 15, -1, "Exstreme Rogue Power", "Exstreme Rogue Power", "Exstreme Rogue Power", "Exstreme Rogue Power", 41872, 6, 0, 50009999, 20009999, 13, -1, -1, 345, 80, 0, 0, 0, 0, 0, 0, 0, 5, 1, 0, 1, 5000, 3, 5000, 4, 5000, 35, 5000, 7, 5000, 13, 5000, 38, 5000, 37, 5000, 32, 5000, 31, 5000, 2500, 7000, 0, 2500, 7000, 6, 50000, 200, 200, 200, 200, 200, 200, 50000, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 2, "Made by GmDomitrix", 0, 0, 0, 0, 0, 1, 3, 0, 0, 500, 0, 1000, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 3313, 0, 0, 0);
When i press f9 to run it comes an error: "SQL Error: Unkown column "name2" in "field list"
Plz reply if got an answer
VALUES (12345, 2, 15, -1, "Exstreme Rogue Power", "Exstreme Rogue Power", "Exstreme Rogue Power", "Exstreme Rogue Power", 41872, 6, 0, 50009999, 20009999, 13, -1, -1, 345, 80, 0, 0, 0, 0, 0, 0, 0, 5, 1, 0, 1, 5000, 3, 5000, 4, 5000, 35, 5000, 7, 5000, 13, 5000, 38, 5000, 37, 5000, 32, 5000, 31, 5000, 2500, 7000, 0, 2500, 7000, 6, 50000, 200, 200, 200, 200, 200, 200, 50000, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 2, "Made by GmDomitrix", 0, 0, 0, 0, 0, 1, 3, 0, 0, 500, 0, 1000, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 3313, 0, 0, 0);
When i press f9 to run it comes an error: "SQL Error: Unkown column "name2" in "field list"
Plz reply if got an answer
Please login to leave a reply, or register at first.