Trying to upload a vendor and I continue to get this error. Please help. menu

User Tag List

Results 1 to 5 of 5
  1. #1
    robbversion1's Avatar Member
    Reputation
    4
    Join Date
    Oct 2008
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Trying to upload a vendor and I continue to get this error. Please help.

    Any help would be appreciated. Thanks
    I'm running ArcEmu latest rev. 1897 NDCB CORE 46

    [Err] 1054 - Unknown column 'mountdisplayid' in 'field list'
    [Err] INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (180001, 80, 80, 814, 99999, 99999, 99999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    [Msg] Finished - Unsuccessfully

    Trying to upload a vendor and I continue to get this error. Please help.
  2. #2
    Ground Zero's Avatar ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Then just remove "Mountdisplayid" column and remove the entry too...Easy?
    So it would be...


    INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (180001, 80, 80, 814, 99999, 99999, 99999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);

  3. #3
    robbversion1's Avatar Member
    Reputation
    4
    Join Date
    Oct 2008
    Posts
    34
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yea tried that and got error:

    [Err] 1054 - Unknown column 'equipmodel1' in 'field list'
    [Err] INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (180001, 80, 80, 814, 99999, 99999, 99999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------

    I not sure whats going on. Maybe its somethings wrong with the database i'm using...

  4. #4
    Ground Zero's Avatar ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No Your choosing the wrong download option when you download it. -.-

    Choose the one your on

    Either that or you havnt updated the Database with "Sql_Updates" in your ArcEmu Folder.

  5. #5
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yea i suggest you update your DB to match the structure of the query you are using...

Similar Threads

  1. Trying to start a server, but coming up with an error. Please help! :)
    By Dead243 in forum World of Warcraft General
    Replies: 0
    Last Post: 08-20-2008, 07:08 PM
  2. Game Master Vendors and Items
    By LTGH in forum World of Warcraft Emulator Servers
    Replies: 79
    Last Post: 12-15-2007, 03:24 PM
  3. Making a Gold Vendor and Item
    By cylas in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 11-18-2007, 04:18 AM
  4. Vendors and Teleports
    By lzwink in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 11-17-2007, 12:03 PM
  5. Few model changes. please help :) , tryed self and failed
    By luddo9 in forum WoW ME Questions and Requests
    Replies: 12
    Last Post: 07-04-2007, 12:32 PM
All times are GMT -5. The time now is 10:55 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