Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Arcemu WOW V ARCEMU HELP WITH SQL Error (1054): Unknown column 'name2' in 'field list'

Initiate Mage
Joined
Jan 18, 2014
Messages
1
Reaction score
0
Hey guys i keep getting this error SQL Error (1054): Unknown column 'name2' in 'field list' the thing im trying to do is put in my weapon


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, itemstatscount)VALUES (99999, 2, 7, -1, "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", "OP GM WEPS", 46609, 5, 0, 1, 99999999, 13, -1, -1, 999, 1, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 1, 9999, 4, 9999, 7, 9999, 42, 9999, 32, 9999, 16, 9999, 38, 9999, 15, 9999, 46, 9999, 44, 9999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 0, 1000, 100, 100, 100, 100, 100, 100, 1000, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 18060, 1, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 0, "For Only The Op", 0, 0, 0, 0, 0, 1, 3, 0, 0, 1000, 0, 100/100, 0, 0, 0, 0, 1, 0, 2, 0, 4, 0, 3305, 0, 0, 0, 10);

and when i click the blue start button i get the error of Uknown column 'name2' in 'field list' please help im using heidisql to import it and i have tried ever batch file and none work please someone help me:(::(::(::(:
 
Lord of the Legion
Joined
Jul 28, 2005
Messages
426
Reaction score
35
Verify that your column names (The field list) are in the appropriate order as in the database. Also, when you insert in MySQL and you include a value for every column, you do not need to specify the column names. Basically it's saying that it doesn't see a column named 'name2' coming up after name1.

Does that script comply with the DB structure for your version of ArcEmu? Meaning is that script for your ArcEmu or a different version?
 
Back
Top