Navicat 8 Executing Batch Files menu

Shout-Out

User Tag List

Results 1 to 6 of 6
  1. #1
    Ltleontis54321's Avatar Member
    Reputation
    7
    Join Date
    Dec 2007
    Posts
    23
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Navicat 8 Executing Batch Files

    Hey i tried to make my own weapons and armor with wow-v and i get them download them to my desktop and go into navicat execute them to mangos and it comes up with:

    [Err] 1146 - Table 'mangos.items' doesn't exist
    [Err] 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 (5278,2,7,-1,"Tight Sword","Tight Sword","Tight Sword","Tight Sword",5279,6,0,55550000,10000000,21,-1,-1,255,255,0,0,0,0,0,0,0,2,2,0, 1,1000, 3,1000, 4,1000, 5,1000, 6,1000, 7,1000, 12,1000, 13,1000, 14,1000, 0,0,4999,5000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000,0.50,0,0 ,35844,1,0,0,0,0,18060,1,0,0,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,0,0,0,0,0,0,1," ",0,0,0,0,0,1,1,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------
    Ive googled it and i cant find anything i got the mangos server from this website its a 2.1.1 - 2.1.2 server and its been running really good no glithes and all it all ran fine until this happened.
    Could anyone help? TY

    Navicat 8 Executing Batch Files
  2. #2
    Noobcraft's Avatar Member
    Reputation
    141
    Join Date
    Aug 2007
    Posts
    598
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    darune94s 1-2-3 signiture reply

    1.you use ascent
    2.you downloaded this for mangos
    3.if you dont know what to do from here on then you sir needs to go back to school


    basicly just download ir for ascent new rev and you be ok



  3. #3
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1192
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yea are you using ascent?
    If you need me you have my skype, if you don't have my skype then you don't need me.

  4. #4
    Nubbadon's Avatar Member
    Reputation
    12
    Join Date
    Aug 2007
    Posts
    141
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If ya guys read i belive u will see that he's using ManGOS...

    Anyways u might have made it so it dont have any model to disepel...

  5. #5
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1192
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    kk, do u have the table items in ur database?
    If you need me you have my skype, if you don't have my skype then you don't need me.

  6. #6
    Ltleontis54321's Avatar Member
    Reputation
    7
    Join Date
    Dec 2007
    Posts
    23
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hmm wierd i got this guide from the ManGOS Server and it looked like mangos but ill try to get ascent sql file TY


    Ok i got the ascent .sql file and now im getting

    [Err] 1146 - Table 'mangos.items' doesn't exist
    [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, 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 (5278,2,0,-1,"Martin Thunder","Martin Thunder","Martin Thunder","Martin Thunder",5279,6,0,16990000,15640000,13,-1,-1,255,255,0,0,0,0,0,0,0,2,2,0, 1,1000, 3,1000, 4,1000, 5,1000, 6,1000, 7,1000, 12,1000, 13,1000, 14,1000, 0,0,1000,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000,.5,0,0,3 5844,1,0,0,0,0,18060,1,0,0,0,0,34696,2,0,0,0,0,17713,1,0,0,0,0,0,0,0,0,0,0,0,"", 0,0,0,0,0,1,3,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------
    Last edited by Ltleontis54321; 03-30-2008 at 12:59 PM.

Similar Threads

  1. Help with executing custom item batch file to heidi sql?
    By Drelanarus in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 04-27-2008, 11:47 AM
  2. I Get This Error When I Run Execute Batch File On Navicat
    By BillyBob31 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 03-01-2008, 07:28 AM
  3. [Guide] Executing SQL files faster - Importing DB faster
    By latruwski in forum WoW EMU Guides & Tutorials
    Replies: 16
    Last Post: 01-25-2008, 01:01 PM
  4. How to Execute SQL Files To Your DB With Pictures
    By C.C. in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 11-24-2007, 07:21 PM
  5. NCDB rev 662 (1 executeable SQL file)
    By Viter in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 11-23-2007, 11:56 AM
All times are GMT -5. The time now is 12:58 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search