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!

[HELP] CANNOT ADD MY NEW CUSTOM ITEM {error log inside}

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
everytime i execute the SQL file of my new item i get this error. im using SQLyog btw.
can anyone please help me out?


Query:
INSERT INTO items (entry, class, subclass, field4, name, 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, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (867777,2,4,-1,"Blade Of Sparta","Blade Of Sparta","Blade Of Sparta","Blade Of Sparta",29698,5,0,1000000,5000000,13,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,4,5000,7,5000,3,5000,1,5000,0,0,0,0,0,0,0,0,0,0,0,0,999,9999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000000,5000000,5000000,5000000,5000000,1.0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,17713,1,0,0,0,0,17713,1,0,0,0,0,17713,1,0,0,0,0,2,"All My Enemies Wish They Were Never Born",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Error occured at:2007-09-28 02:59:06
Line no.:2
Error Code: 1054 - Unknown column 'name' in 'field list'
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
EDIT:i also tried other weapons, i get errors on any new weapons i try and use, currently im using ascent 1662 with NCDB milestone2 DB.
 
Initiate Mage
Joined
Aug 14, 2005
Messages
22
Reaction score
0
ok i did get this error but i fixed it lol i cart member but i think i just delete my old DB and made a new one with ACDB .. also it couse be just MYSQL i got it with this but not with navicat
 
Initiate Mage
Joined
Aug 14, 2005
Messages
22
Reaction score
0
also the name could already betaken?? or there is no Name field .. were did you make the wepon?
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
i made the weapon on
nd the name isnt taken lol, i tried tons of new names to check :(
 
Initiate Mage
Joined
Aug 14, 2005
Messages
22
Reaction score
0
right .. am not sure try making the weapon again maby some of the stats you added are too high??.. also make sure the entry id is not in use
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
i made sure the ID is not in use, its also not a problem with the stats, lol.
im reinstalling everything now, using ascent 1709 with NCDB2
ill keep updated on wats goin on.
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
reinstalled SQLyog, and wamp, and latest ascent, still not working and im getting the same error , i also tried diffrent weapons, i dont understand the problem, its DEFINITELY not the display IDS, cus i made sure.
 
Experienced Elementalist
Joined
Jun 22, 2007
Messages
276
Reaction score
0
WOA ... It works 4 me on NCDB Milestone 0.2 there is 1 error though ... If ya fix it it WILL work! ... Use WOW-Vendetta 2 make the wep!! ... then in the query ...
Code:
INSERT INTO items (entry, class, subclass, field4, [COLOR="Red"]CHANGE  'name' TO 'name1'[/COLOR], 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, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (1000000,2,7,-1,"NoobUlator","NoobUlator","NoobUlator","NoobUlator",1542,4,0,00000,00000,13,-1,-1,1,1,0,0,0,0,0,0,0,1,1,0,7,800,12,800,3,800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,150,150,0,150,150,5,0,0,0,0,0,0,0,0,0,0,10,10,10,10,10,10,1000,0,0,33021,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,1,"HEH! im a noob :o",0,0,0,0,0,1,1,0,0,0,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
WOA ... It works 4 me on NCDB Milestone 0.2 there is 1 error though ... If ya fix it it WILL work! ...
Code:
Query:
INSERT INTO items (entry, class, subclass, field4, [COLOR=Red]"name" MAKE THIS "name1"[/COLOR] , 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, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (867777,2,4,-1,"Blade Of Sparta","Blade Of Sparta","Blade Of Sparta","Blade Of Sparta",29698,5,0,1000000,5000000,13,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,4,5000,7,5000,3,5000,1 ,5000,0,0,0,0,0,0,0,0,0,0,0,0,999,9999,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,5000000,5000000,5000000,5000000 ,5000000,1.0,0,0,18060,1,0,0,0,0,17713,1,0,0,0,0,1 7713,1,0,0,0,0,17713,1,0,0,0,0,17713,1,0,0,0,0,2," All My Enemies Wish They Were Never Born",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0)



KIRA90!!!!!
I THINK I AM IN LOVE WITH YOU<33333333333333333333333333333333
THANKS SO MUCH =]
 
Experienced Elementalist
Joined
Jun 22, 2007
Messages
276
Reaction score
0
lol np :D ... It will work but in your sparta blade ... somewhere theres an error ... so just make sure evrythings not 2 high and in the right place ...
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
nope all i did was add a "1" to name, changed it to name1
and it works perfect ingame, im destroying poop =] lol
 
Experienced Elementalist
Joined
Jun 22, 2007
Messages
276
Reaction score
0
lol :p ... nice xD ... I found what was my error :p ... I missed the last bit of the querry :p
 

vak

Initiate Mage
Joined
Sep 26, 2007
Messages
40
Reaction score
0
lol =]
you should DL my weapn and try it out lol it owns!
it has hand of rag display and dual wield that + stats = ownage =]
 
Initiate Mage
Joined
Jul 24, 2014
Messages
3
Reaction score
0
hey can one of you guys help me im gettin a problem just like that expect it says [Err] 1054 - Unknown column 'dmg_min1' in 'field list'
[Err] INSERT INTO item_template (entry, class, subclass, SoundOverrideSubclass , name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (5567889, 2, 8, -1, "Stupid Sword", 26577, 1, 0, 1, 1, 1, 17, -1, -1, 15, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 5, 8, 5, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);
[Msg] Finished - Unsuccessfully
What do i do please help
 
Lord of the Legion
Joined
Jul 28, 2005
Messages
426
Reaction score
35
hey can one of you guys help me im gettin a problem just like that expect it says [Err] 1054 - Unknown column 'dmg_min1' in 'field list'
[Err] INSERT INTO item_template (entry, class, subclass, SoundOverrideSubclass , name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, 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, RangedModRange, 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, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, StatsCount)
VALUES (5567889, 2, 8, -1, "Stupid Sword", 26577, 1, 0, 1, 1, 1, 17, -1, -1, 15, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 5, 8, 5, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);
[Msg] Finished - Unsuccessfully
What do i do please help

Don't use WoW-V for custom items. They don't support every core and next time, make your own thread instead of bumping a 7 year old topic. WoW-V's structure for that item you're trying to make does not match the database structure.

If you want to make your own items, I suggest looking at the wiki for the core you're using, they usually have the DB structures listed.

I quickly wrote this, it should work for you. Didn't test the syntax but it should be right:

Code:
INSERT INTO item_template (entry, class, subclass, name, displayid, quality, inventorytype, itemlevel, requiredlevel, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, delay, material, sheath, maxdurability) VALUES (5567889, 2, 8, "Stupid Sword", 26577, 1, 17, 15, 1, 3, 5, 0, 5, 8, 5, 1, 1, 1, 100);

You only need to enumerate the fields that won't be default. If you get an error, post back (with the error) cause I probably got something wrong in there.
 
Last edited:
Back
Top