/* 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 3958 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 3958 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. |