I don't know if this would be an appropriate topic... but when you go to wow-v... make a custom weapon and such, download batch, and then connect to HeidiSQL... click import... then Load SQL.File, find the weapon file, then press f9... any ideas what to do when an error pops up saying "Unkown 'column' in 'field' list?"
Thanks :)
WoW Weapon Creator
If you copy/paste the last two lines of SQL log from the pane in the bottom part of HeidiSQL, then it would be much clearer what's going on.
(The last line in the SQL log is the error you're seeing, and the next-to-last line is the SQL that caused the error.)
(The last line in the SQL log is the error you're seeing, and the next-to-last line is the SQL that caused the error.)
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, ReqDisenchantSkill, unk2) VALUES (1,2,7,-1,"Cayne's Starter Sword","Cayne's Starter Sword","Cayne's Starter Sword","Cayne's Starter Sword",18871,0,0,0000,0000,13,-1,-1,1,1,0,0,0,0,0,0,0,2,2,0, 1,900, 3,900, 4,900, 5,900, 6,900, 7,900, 12,900, 13,900, 14,900, 15,900,7777,7777,0,7777,7777,0,7777,7/* large SQL query, snipped at 2,000 characters */
/* SQL Error: Unknown column 'name' in 'field list' */
/* SQL Error: Unknown column 'name' in 'field list' */
I really dont know how to fix any of this im really new to this and such
can this be fixed:?: i Keep getting a
SQL Error:Unknown Column 'unk203_1' 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, 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, ReqDisenchantSkill, unk2)
VALUES (22691, 2, 15, -1, "Ima Dagger", "Ima Dagger", "Ima Daggeitemsr", "Ima Dagger", 35097, 0, 0, 0000, 0000, 13, -1, -1, 82, 80, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 3, 150, 4, 300, 7, 250, 14, 56, 28, 100, 38, 4000, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1500, 0, 200, 300, 5, 200, 300, 1, 200, 300, 2, 200, 300, 4, 0, 0, 0, 0, 0, 0, 0, 1400, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "If this dont throw you off idk what will!", 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 1000000, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 3305, 0, 0, 0);
hurry and help me ! ima Newb[/b][/code]
can this be fixed:?: i Keep getting a
SQL Error:Unknown Column 'unk203_1' 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, 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, ReqDisenchantSkill, unk2)
VALUES (22691, 2, 15, -1, "Ima Dagger", "Ima Dagger", "Ima Daggeitemsr", "Ima Dagger", 35097, 0, 0, 0000, 0000, 13, -1, -1, 82, 80, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 3, 150, 4, 300, 7, 250, 14, 56, 28, 100, 38, 4000, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1500, 0, 200, 300, 5, 200, 300, 1, 200, 300, 2, 200, 300, 4, 0, 0, 0, 0, 0, 0, 0, 1400, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "If this dont throw you off idk what will!", 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 1000000, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 3305, 0, 0, 0);
hurry and help me ! ima Newb[/b][/code]
I'm also having a similar problem.
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, RandomSuffixId, 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)
VALUES (39344, 2, 7, -1, "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", 53932, 5, 0, 100000000, 10000, 13, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 1, 500, 3, 300, 4, 500, 5, 500, 6, 500, 7, 500, 12, 50, 13, 50, 28, 20, 45, 700, 2000, 5000, 0, 100, 100, 2, 100, 100, 4, 100, 100, 5, 100, 100, 6, 1000, 30, 20, 30, 20, 20, 20, 250, 0, 0, 7599, 1, 0, 0, 0, 0, 28735, 1, 0, 0, 0, 0, 7600, 1, 0, 0, 0, 0, 35827, 1, 0, 0, 0, 0, 28735, 1, 0, 0, 0, 0, 1, "'One of the most legendary swords created'", 0, 0, 0, 0, 0, 1, 1, 0, 0, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3305, 0, 0);
That's my code but i keep getting this error.
SQL Error: Unknown Column 'RandomSuffixId' in 'field list'.
Any ideas?
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, RandomSuffixId, 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)
VALUES (39344, 2, 7, -1, "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", "Mazh'Kahr, Star Sword of Misery", 53932, 5, 0, 100000000, 10000, 13, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 1, 500, 3, 300, 4, 500, 5, 500, 6, 500, 7, 500, 12, 50, 13, 50, 28, 20, 45, 700, 2000, 5000, 0, 100, 100, 2, 100, 100, 4, 100, 100, 5, 100, 100, 6, 1000, 30, 20, 30, 20, 20, 20, 250, 0, 0, 7599, 1, 0, 0, 0, 0, 28735, 1, 0, 0, 0, 0, 7600, 1, 0, 0, 0, 0, 35827, 1, 0, 0, 0, 0, 28735, 1, 0, 0, 0, 0, 1, "'One of the most legendary swords created'", 0, 0, 0, 0, 0, 1, 1, 0, 0, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3305, 0, 0);
That's my code but i keep getting this error.
SQL Error: Unknown Column 'RandomSuffixId' in 'field list'.
Any ideas?
sorry for bringing back a old thread but im in need xD ok i get a error saying "SQL Error: unknown column 'name2' in 'field list'"
ok iv looked at name2 it looks the same as anyone elses and the only thing in the file that has field in it is field4, im new to this so anything helpsthanks
ok iv looked at name2 it looks the same as anyone elses and the only thing in the file that has field in it is field4, im new to this so anything helpsthanks
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 (98798, 2, 7, -1, "RICKY'S BEAST!!", "RICKY'S BEAST!!", "RICKY'S BEAST!!", "RICKY'S BEAST!!", 60682, 5, 0, 45454, 13343, 13, -1, -1, 998, 80, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 3, 9997, 4, 9997, 7, 9997, 12, 9997, 13, 999, 1, 10000, 38, 999, 19, 999, 37, 999, 44, 999, 100, 100000, 0, 100, 100000, 1, 87657, 50, 50, 50, 50, 50, 50, 100, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 0, "Look, but u cant touch this", 0, 0, 0, 0, 0, 1, 3, 0, 0, 999, 0, 9999, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 3303, 0, 0, 0);
mine is doing it to i need help how i fix mine
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 (81000, 2, 1, -1, "Titans burning axe", "Titans burning axe", "Titans burning axe", "Titans burning axe", 41560, 5, 0, 100000000, 10000, 17, -1, -1, 300, 250, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 25, 47, 100, 13, 5, 4, 33, 44, 66, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 300, 320, 2, 300, 320, 0, 0, 0, 666, 0, 0, 0, 0, 3, 0, 0, 34696, 2, 0, 0, 0, 0, 17713, 1,/* large SQL query, snipped at 2,000 characters */
/* SQL Error: Unknown 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 (81000, 2, 1, -1, "Titans burning axe", "Titans burning axe", "Titans burning axe", "Titans burning axe", 41560, 5, 0, 100000000, 10000, 17, -1, -1, 300, 250, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 25, 47, 100, 13, 5, 4, 33, 44, 66, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 300, 320, 2, 300, 320, 0, 0, 0, 666, 0, 0, 0, 0, 3, 0, 0, 34696, 2, 0, 0, 0, 0, 17713, 1,/* large SQL query, snipped at 2,000 characters */
/* SQL Error: Unknown column 'name2' in 'field list' */
Please login to leave a reply, or register at first.