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

/* SQL Error: Unknown column 'name' in 'field list' */

User, date Message
Written by clayton53
5 years ago
Category: Import/Export
5 posts since Fri, 31 Oct 08
ZOMG HELP ME i keep getting that when i hit f9 to make my weapon
Written by clayton53
5 years ago
5 posts since Fri, 31 Oct 08
i would love it if someone could help me :S :D
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
You should post the query you are executing, otherwise noone will be able to help.
Written by clayton53
5 years ago
5 posts since Fri, 31 Oct 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 (.192,4,1,-1,"Pwned","Pwned","Pwned","Pwned",38699,6,0,100,100,1,-1,-1,1,70,0,0,0,0,0,0,0,1,1,0, 1,99999, 3,99999, 4,99999, 5,99999, 14,99999, 21,99999, 20,99999, 19,99999, 7,99999, 13,99999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,90000000,99999999,99999999,99999999,99999999,99999999,99999999,0,0,0,35844,1,0,0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,35842,1,0,0,0,0,35894,1,0,0,0,0,1,"Pwnage Server GM GEAR",0,0,0,0,0,-1,0,0,0,90000000,0,0,0,0,0,0,2,0,1,0,4,0,104,0,0,0);items
Written by ansgar
5 years ago
4801 posts since Fri, 07 Apr 06
The problem is here:
INSERT INTO items (entry, class, subclass, field4, name, name2,..

So your table "items" has no column called "name". Just a wild guess, seeing your other columns: could it be "name1" ?
Written by clayton53
5 years ago
5 posts since Fri, 31 Oct 08
when i add a one it has an error message
Written by rosenfield
5 years ago
127 posts since Wed, 24 Jan 07

wrote: ZOMG


It's been 4 years. The joke is dead beyond resurrection.

wrote: SQL Error: Unknown column 'name'



The weapon script is incompatible with the WoW server software package you're using.

The server software package contains the table definition, which in this case does not match with the weapon script in terms of defined columns.

Perhaps the script is designed for another package, or perhaps just for another version.

Solutions.

a. Use some other server software, specifically use the one that your weapon script was designed to work with.

b. Use another weapon script, or weapon script generator (whatever), specifically one designed to work with the server you're using.
Written by clayton53
5 years ago
5 posts since Fri, 31 Oct 08
i will try thouse right away
 

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