Initiate Mage
- Joined
- Jan 18, 2014
- Messages
- 1
- Reaction score
- 0
Hey guys i keep getting this error SQL Error (1054): Unknown column 'name2' in 'field list' the thing im trying to do is put in my weapon
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, itemstatscount)VALUES (99999, 2, 7, -1, "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", 46609, 5, 0, 1, 99999999, 13, -1, -1, 999, 1, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 1, 9999, 4, 9999, 7, 9999, 42, 9999, 32, 9999, 16, 9999, 38, 9999, 15, 9999, 46, 9999, 44, 9999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 0, 1000, 100, 100, 100, 100, 100, 100, 1000, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 0, "For Only The Op", 0, 0, 0, 0, 0, 1, 3, 0, 0, 1000, 0, 100/100, 0, 0, 0, 0, 1, 0, 2, 0, 4, 0, 3305, 0, 0, 0, 10);
and when i click the blue start button i get the error of Uknown column 'name2' in 'field list' please help im using heidisql to import it and i have tried ever batch file and none work please someone help me::::
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, itemstatscount)VALUES (99999, 2, 7, -1, "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", 46609, 5, 0, 1, 99999999, 13, -1, -1, 999, 1, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 1, 9999, 4, 9999, 7, 9999, 42, 9999, 32, 9999, 16, 9999, 38, 9999, 15, 9999, 46, 9999, 44, 9999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 0, 1000, 100, 100, 100, 100, 100, 100, 1000, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 0, "For Only The Op", 0, 0, 0, 0, 0, 1, 3, 0, 0, 1000, 0, 100/100, 0, 0, 0, 0, 1, 0, 2, 0, 4, 0, 3305, 0, 0, 0, 10);
and when i click the blue start button i get the error of Uknown column 'name2' in 'field list' please help im using heidisql to import it and i have tried ever batch file and none work please someone help me::::