Navicat items and NPC errors when attempting to add, please help.

[Chickencowman]

Hey, I recently made an ArcEmu server for 3.5.5a, and I have been trying to add items to my database through Navicat, and for every item I get an error. I also tried to add an NPC, and that got an error too. I've tried making my own on V-WoW and I tried adding in one of the premade items, both not working. These are the full errors for both, excuse the ridiculous item name and everything, it was a test.

Self-Made item:
[Err] 1062 - Duplicate entry '4999999' for key 1
[Err] INSERT INTO items (entry, class, subclass, field4, name1, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSpell, 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, randomsuffix, 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, ArmorDamageModifier, itemstatscount)
VALUES (4999999, 2, 4, -1, "The Hammer of the Gods", 41638, 6, 0, 303060, 3000000, 13, -1, -1, 200, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 250, 7, 40, 46, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 640, 920, 0, 200, 300, 4, 0, 20, 20, 0, 0, 20, 0, 2000, 0, 0, 53642, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, "Forged in the deepest caverns of the Earth by the elder gods, Ryan and Tristin.", 0, 0, 0, 0, 0, 1, 1, 0, 0, 20, 0, 400, 0, 0, 0, 0, 1, 0, 8, 0, 1, 0, 3312, 0, 0, 0, 10);
[Msg] Finished - Unsuccessfully

WoW-V Item:
[Err] 1054 - Unknown column 'name2' in 'field list'
[Err] 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 (59999, 4, 1, -1, "Tribal Tattoo - Black", "Tribal Tattoo - Black", "Tribal Tattoo - Black", "Tribal Tattoo - Black", 47080, 1, 0, 0, 0, 4, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "A black tribal tattoo covering most of the body and arms.", 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10);
[Msg] Finished - Unsuccessfully

NPC I made:
[Err] 1054 - Unknown column 'unk4' in 'field list'
[Err] insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
values ('303030', "Tristin", "Pretty Cool Guy", '', '0', '7', '25', '2', '0', '0', '23005', '23005', '23005', '23005', '1', '1', '1', '0');
[Msg] Finished - Unsuccessfully

I've checked over and over that the duplicate entries were in fact not duplicates. I've searched through the items database, as well as tried to add them to my character on the server.
The way I added all of these items were by right clicking my 'world' database, clicked Execute SQL File, and then chose the file from the SQL I downloaded from WoW-V. Help would be much appreciated, this is really frustrating. Thanks in advance!

[stoneharry]

The structure of the SQL queries is different to that of the database, for example:

INSERT INTO `cars` VALUES ('Golf', '502');

Would not work if the only column was car name. The 502 would have nowhere to go.

You need to compare the query with your database and see what is different, see if you can altar it to what is correct. Your error is saying that unk4 is not in the database but it is trying to insert into it.

[Harambeqt]

[Err] 1062 - Duplicate entry '4999999' for key 1


Check if an Item with entry id "4999999" already exists.

[Chickencowman]

[Err] 1062 - Duplicate entry '4999999' for key 1


Check if an Item with entry id "4999999" already exists.

I have several times, I know there isn't a duplicate item with that id.

---------- Post added at 04:30 PM ---------- Previous post was at 04:29 PM ----------

The structure of the SQL queries is different to that of the database, for example:

INSERT INTO `cars` VALUES ('Golf', '502');

Would not work if the only column was car name. The 502 would have nowhere to go.

You need to compare the query with your database and see what is different, see if you can altar it to what is correct. Your error is saying that unk4 is not in the database but it is trying to insert into it.

Aah. Okay, I'll look at that, if not, NPCs really aren't that important. Do you know what's wrong with the other two item errors?

[Facerolling]

Try a number a little smaller than 4999999, I suggest maybe 56000.