WoW Weapon Creator
| User, date | Message |
|---|---|
|
Written by Cayne94
5 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
5 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
5 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
5 years ago 440 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
5 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
5 years ago 7 posts since Wed, 04 Jun 08 |
Those are the last 2 lines... |
|
Written by kalvaro
5 years ago 440 posts since Thu, 29 Nov 07 |
Does table items have a column called name? |
|
Written by Cayne94
5 years ago 7 posts since Wed, 04 Jun 08 |
I don't think so. |
|
Written by Cayne94
5 years ago 7 posts since Wed, 04 Jun 08 |
yes, name1,name2,name3, and name4 |
|
Written by kalvaro
5 years ago 440 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
5 years ago 7 posts since Wed, 04 Jun 08 |
Wow, it's so simple, thanks so much  ^^
|
|
Written by eglerpay9
4 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
4 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
4 years ago 3950 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
4 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 helps  thanks 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) |
|
Written by Domitrix
4 years ago 4 posts since Sat, 14 Nov 09 |
I have the same problem so plz help!
|
|
Written by accman
4 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
3 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. |