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

User Tag List

Results 1 to 2 of 2
  1. #1
    vak's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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,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)

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


    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.

    [HELP] CANNOT ADD MY NEW CUSTOM ITEM {error log inside}
  2. #2
    vak's Avatar Member
    Reputation
    1
    Join Date
    Sep 2007
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    nvm i fixed the error.
    were it says name i added a 1 so i did "name1"
    and it worked =]

Similar Threads

  1. Need help! Client crashes with new custom editted models.
    By drsmoothness in forum WoW ME Questions and Requests
    Replies: 0
    Last Post: 05-09-2010, 09:44 PM
  2. [Help]Cannot add premuim server to wowstatus
    By griim in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 02-20-2010, 08:06 AM
  3. I cannot add, use or see the custom items i create. +REP for helpers
    By Wheeze201 in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 08-14-2008, 02:10 PM
  4. Custom Item Error
    By newfang in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 04-26-2008, 01:55 AM
  5. How do I add my own custom items?
    By Reserved in forum World of Warcraft Emulator Servers
    Replies: 9
    Last Post: 01-08-2008, 05:04 PM
All times are GMT -5. The time now is 07:10 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search