[Arcemu]Error with SQL importer and any sql program.

[4l3k]

Hey guys.. i made my own stuff at wow-v.com .. i made the entry 16000 so no weapon could be overwrited. when i try to import the weapon to world database in SQLyoq, Navicat or heidiSQL it allways says : [Err] 1054 - Unknown column 'unk203_1' in 'field list', [Msg] Finished - Unsuccessfully, /* SQL Error: Unknown column 'unk203_1' in 'field list' */. When i try to remove unk203_1 it says : /* SQL Error: Column count doesn't match value count at row 1 */.

- Please help me out :s

[4l3k]

no one can help?

[Reflection]

Switch unk203_1 with unk201_3.

[4l3k]

Switch unk203_1 with unk201_3.

Doesnt work :s

[Reflection]

Oh, hm, post the entire sql code in [code] tags please. I'll change a thing for you.

[4l3k]

k mate.

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 (25304, 2, 8, -1, "Kaluak GM sword", "Kaluak GM sword", "Kaluak GM sword", "Kaluak GM sword", 39419, 6, 0, 99999, 9999999999, 17, -1, -1, 255, 255, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0,  4, 99999,  3, 99999,  5, 99999,  6, 99999,  7, 99999,  32, 99999,  1, 99999,  15, 99999,  14, 99999,  12, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 1, 9999999999, 9999999999, 2, 9999999999, 9999999999, 4, 9999999999, 9999999999, 6, 5000000, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0.10, 0, 0, 18060, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 0, "This is for GM's only", 0, 0, 0, 0, 0, 1, 1, 0, 0, 5000000, 0, 99999, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 3312, 0, 0, 0);

[Reflection]

 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, 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 (25304, 2, 8, -1, "Kaluak GM sword", "Kaluak GM sword", "Kaluak GM sword", "Kaluak GM sword", 39419, 6, 0, 99999, 9999999999, 17, -1, -1, 255, 255, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0,  4, 99999,  3, 99999,  5, 99999,  6, 99999,  7, 99999,  32, 99999,  1, 99999,  15, 99999,  14, 99999,  12, 99999, 9999999999, 9999999999, 0, 9999999999, 9999999999, 1, 9999999999, 9999999999, 2, 9999999999, 9999999999, 4, 9999999999, 9999999999, 6, 5000000, 99999999, 99999999, 99999999, 99999999, 99999999, 99999999, 0.10, 0, 0, 18060, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 34696, 2, 0, 0, 0, 0, 35844, 1, 0, 0, 0, 0, 17713, 1, 0, 0, 0, 0, 0, "This is for GM's only", 0, 0, 0, 0, 0, 1, 1, 0, 0, 5000000, 0, 99999, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 3312, 0, 0, 0);

Try that.