Help!!!!ME!!!!!

[expired user #4165]'s profile image [expired user #4165] posted 15 years ago in General Permalink
Ok so I try to put a weapon in. Here's my code:
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);

The error I'm getting is:
SQL Error: Unknown column 'RandomSuffixId' in 'fieldlist'.
Any ideas at all?
kalvaro's profile image kalvaro posted 15 years ago Permalink
The error message is pretty self-explanatory. You are asking MySQL to insert a value into a column called RandomSuffixId in a table that doesn't have such column.

My guess is that you are importing data for the wrong version of the app. You should ask whoever wrote the application that generated that SQL code.

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