distal-attribute
distal-attribute
distal-attribute
distal-attribute

WoW Weapon Creator

Cayne94 posted 7 years ago in General
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 :)
rosenfield posted 7 years ago
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.)
Cayne94 posted 7 years ago
So... where do i paste the last 2 lines of the SQL log?
kalvaro posted 7 years ago

Cayne94 wrote: So... where do i paste the last 2 lines of the SQL log?



Here!

What rosenfield means is that if you're getting an error due to the SQL code, we need to see the SQL code in order to know what the error is.
Cayne94 posted 7 years ago
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' */

Cayne94 posted 7 years ago
Those are the last 2 lines...
kalvaro posted 7 years ago
Does table items have a column called name?
Cayne94 posted 7 years ago
I don't think so.
Cayne94 posted 7 years ago
yes, name1,name2,name3, and name4
kalvaro posted 7 years ago

Cayne94 wrote: yes, name1,name2,name3, and name4



Then, when it reads:

INSERT INTO items (entry, class, subclass, field4, name, name2

... it should read:

INSERT INTO items (entry, class, subclass, field4, name1, name2

Cayne94 posted 7 years ago
Wow, it's so simple, thanks so much happy ^^
eglerpay9 posted 6 years ago
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]
robodrgn4545 posted 5 years ago
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?
ansgar posted 5 years ago

wrote: ... Unknown column ...

means, your table is missing this "RandomSuffixId" column, while the INSERT query above contains this column.
thelethalmoo posted 5 years ago
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 helpssmilethanks




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);

Domitrix posted 5 years ago
I have the same problem so plz help!unhappy
accman posted 5 years ago
I think you dont download rigth you know its not same its like Arcemu/aspire/mangons and stuff try to download the rigth verson
1061172 posted 5 years ago
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' */

Please login to leave a reply, or register at first.