Trouble with custom item for my antrix server.

[phc_chaos]

Okay sorry for spamming here or whatever I need help please.

how do you get this to work? I put it into a database but what does it mean by 'no' in 'field list'?

Query:
Error occured at:2007-09-29 12:30:26
Line no.:15
Error Code: 1046 - No database selectedQuery:
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 (70000,2,8,-1,"Soul Calibur","Soul Calibur","Soul Calibur","Soul Calibur",70000,5,0,0000,0000,21,1,-1,200,70,0,0,0,0,0,0,0,1000,No,0,4,1000,1,1000,7,1000,12,1000,0,0,0,0,0,0,0,0,0, 0,0,0,1,999999,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,17713,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,"This is the Sword of a True Legend",0,0,0,0,0,1,1,0,0,0,0,999/999,0,0,0,0,2,0,8,0,4,0,1585,0,0,0,0)

Error occured at:2007-10-05 13:36:09
Line no.:2
Error Code: 1054 - Unknown column 'No' in 'field list'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 (70000,2,8,-1,"Soul Calibur","Soul Calibur","Soul Calibur","Soul Calibur",70000,5,0,0000,0000,21,1,-1,200,70,0,0,0,0,0,0,0,1000,No,0,4,1000,1,1000,7,1000,12,1000,0,0,0,0,0,0,0,0,0, 0,0,0,1,999999,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,17713,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,"This is the Sword of a True Legend",0,0,0,0,0,1,1,0,0,0,0,999/999,0,0,0,0,2,0,8,0,4,0,1585,0,0,0,0)

Error occured at:2007-10-05 13:36:55
Line no.:2
Error Code: 1054 - Unknown column 'No' in 'field list'

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 (70000,2,8,-1,"Soul Calibur","Soul Calibur","Soul Calibur","Soul Calibur",70000,5,0,0000,0000,21,1,-1,200,70,0,0,0,0,0,0,0,1000,No,0,4,1000,1,1000,7,1000,12,1000,0,0,0,0,0,0,0,0,0, 0,0,0,1,999999,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,17713,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,"This is the Sword of a True Legend",0,0,0,0,0,1,1,0,0,0,0,999/999,0,0,0,0,2,0,8,0,4,0,1585,0,0,0,0)

Error occured at:2007-10-05 13:36:58
Line no.:2
Error Code: 1054 - Unknown column 'No' in 'field list'

sorry for the spam or double post or whatever.
does it need navicat to run? If so please help me get navicat running please.

Thanks again for your help.

+rep for assistance.

phc_chaos :runaway: :confused:

[Tankotron]

Did you make sure that you downloaded the antrix build and not the mangos one? There is an option or that at the bottom of the wow-v page

[phc_chaos]

Did you make sure that you downloaded the antrix build and not the mangos one? There is an option or that at the bottom of the wow-v page

yeah I did that but now I have a problem with navicat.

whenever I try loading slyfoxs custom tier items it gives me and error message saying

[Err] 1050 - Table 'items' already exists
[Msg] Finished - Unsuccessfully
and whenever I log on and do .additem 950041 or whatever it says invalid <id> and also with julianx's shopping mall, vendors wont show up! but the portals do!

[perryhiggins]

did u do add batch file or execute?
if u executed then try adding batch file it SHOULD work ^_^
right click ur server and go on add batch file...its something like
add batch file lol , i forgot but u should reconise it