WoW Weapon Creator

[expired user #3507]'s profile image [expired user #3507] posted 16 years ago in General Permalink
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 :)
[expired user #1125]'s profile image [expired user #1125] posted 16 years ago Permalink
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.)
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
So... where do i paste the last 2 lines of the SQL log?
kalvaro's profile image kalvaro posted 16 years ago Permalink

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.
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
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' */
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
Those are the last 2 lines...
kalvaro's profile image kalvaro posted 16 years ago Permalink
Does table items have a column called name?
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
I don't think so.
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
yes, name1,name2,name3, and name4
kalvaro's profile image kalvaro posted 16 years ago Permalink

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
[expired user #3507]'s profile image [expired user #3507] posted 16 years ago Permalink
Wow, it's so simple, thanks so much happy ^^
[expired user #4068]'s profile image [expired user #4068] posted 15 years ago Permalink
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]
[expired user #4165]'s profile image [expired user #4165] posted 15 years ago Permalink
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's profile image ansgar posted 15 years ago Permalink

... Unknown column ...

means, your table is missing this "RandomSuffixId" column, while the INSERT query above contains this column.
[expired user #4235]'s profile image [expired user #4235] posted 14 years ago Permalink
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);
[expired user #4492]'s profile image [expired user #4492] posted 14 years ago Permalink
I have the same problem so plz help!unhappy
[expired user #4493]'s profile image [expired user #4493] posted 14 years ago Permalink
I think you dont download rigth you know its not same its like Arcemu/aspire/mangons and stuff try to download the rigth verson
[expired user #4554]'s profile image [expired user #4554] posted 14 years ago Permalink
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.