[Help] Error loading in items

[Agent Orange]

Hey guys im getting a error when i try loading my weapons in to my DB if you could help thanks
Error Code

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,1141,0,7598,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"" */

Item 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, 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 (99991,2,16,-1,"Warsong Throwing Blade","Warsong Throwing Blade","Warsong Throwing Blade","Warsong Throwing Blade",4289,5,0,0000,0000,25,-1,-1,80,80,0,0,0,0,0,0,0,0,1,0, 3,44, 7,56, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,406,510,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,6,6,6,6,6,1500,0,0,15820,1,0,0,0,0,15467,,0,0,1141,0,7598,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,2,0,4,0,8,0,0,0,0,0);

[Vindicated]

Either the SQL code your trying to import is old, or your items table is old. Most likely the items query.

[Zudrik]

See if it makes a difference like this.

INSERT INTO items VALUES ('99991','2','16','-1','Warsong Throwing Blade','Warsong Throwing Blade','Warsong Throwing Blade','Warsong Throwing Blade','4289','5','0','0000','0000','25','-1','-1','80','80','0','0','0','0','0','0','0','0','1','0','3','44','7','56','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','406','510','0','0','0','0','0','0','0','0','0','0','0','0','0','0','6','6','6','6','6','6','1500','0','0','15820','1','0','0','0','0','15467','','0','0','1141','0','7598','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','2','0','4','0','8','0','0','0','0','0');

[Agent Orange]

See if it makes a difference like this.

INSERT INTO items VALUES ('99991','2','16','-1','Warsong Throwing Blade','Warsong Throwing Blade','Warsong Throwing Blade','Warsong Throwing Blade','4289','5','0','0000','0000','25','-1','-1','80','80','0','0','0','0','0','0','0','0','1','0','3','44','7','56','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','406','510','0','0','0','0','0','0','0','0','0','0','0','0','0','0','6','6','6','6','6','6','1500','0','0','15820','1','0','0','0','0','15467','','0','0','1141','0','7598','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','2','0','4','0','8','0','0','0','0','0');

i get a error

Column count doesn't match value count at row 1

and im using wow-v.com so im not sure if there out of date

[Zudrik]

Try using the other download batch? Lol Idk ><

[latruwski]

i get a error

Column count doesn't match value count at row 1

and im using wow-v.com so im not sure if there out of date

Its your DB that is out of date or the wow-v shizzle
Try updating ur DB and if that is not working then wow-v is out of date... but seriously you should consider making items without wow-v

[Agent Orange]

i found out what was wrong i for got to put on equip