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

WoW Weapon Creator

User, date Message
Written by Cayne94
6 years ago
Category: General
7 posts since Wed, 04 Jun 08
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 :)
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07
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.)
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
So... where do i paste the last 2 lines of the SQL log?
Written by kalvaro
6 years ago
595 posts since Thu, 29 Nov 07

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.
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
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' */
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
Those are the last 2 lines...
Written by kalvaro
6 years ago
595 posts since Thu, 29 Nov 07
Does table items have a column called name?
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
I don't think so.
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
yes, name1,name2,name3, and name4
Written by kalvaro
6 years ago
595 posts since Thu, 29 Nov 07

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
Written by Cayne94
6 years ago
7 posts since Wed, 04 Jun 08
Wow, it's so simple, thanks so much happy ^^
Written by eglerpay9
5 years ago
1 posts since Wed, 10 Jun 09
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]
Written by robodrgn4545
5 years ago
2 posts since Wed, 29 Jul 09
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?
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06

wrote: ... Unknown column ...

means, your table is missing this "RandomSuffixId" column, while the INSERT query above contains this column.
Written by thelethalmoo
5 years ago
2 posts since Sat, 26 Sep 09
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);

Written by Domitrix
5 years ago
4 posts since Sat, 14 Nov 09
I have the same problem so plz help!unhappy
Written by accman
5 years ago
1 posts since Sun, 15 Nov 09
I think you dont download rigth you know its not same its like Arcemu/aspire/mangons and stuff try to download the rigth verson
Written by 1061172
5 years ago
1 posts since Sun, 06 Dec 09
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.