[Mangos]an problem with UDB_0.10.3_Core_6240_SD2_473 menu

User Tag List

Results 1 to 9 of 9
  1. #1
    vittwow's Avatar Banned
    Reputation
    9
    Join Date
    May 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Mangos]an problem with UDB_0.10.3_Core_6240_SD2_473

    hi im got an problem with UDB_0.10.3_Core_6240_SD2_473 when im start mangosd and its load so then after when its load creature templates its says this



    Loading creature Templates...
    Error in Creature_template table,probaly sql file format was updated <there should be 65 fields in sql>




    its says that every time im add the UDB to mangos so can some one pelase help me


    and+ im dont know where to find create_tables.conf to scriptdev2 so im think that is the bug? so some one please help me.if some one can they get an +Rep



    and if some one needs to se all who is ben writed when im start mangosd are its here


    2008-08-06 15:48:52 Using configuration file mangosd.conf.
    2008-08-06 15:48:52 MaNGOS/0.12.0-SVN (Revision 6420) (Win32,little-endian) (world-daemon)
    2008-08-06 15:48:52 <Ctrl-C> to stop.


    MM MM MM MM MMMMM MMMM MMMMM
    MM MM MM MM MMM MMM MM MM MMM MMM
    MMM MMM MMM MM MMM MMM MM MM MMM
    MM M MM MMMM MM MMM MM MM MMM
    MM M MM MMMMM MM MMMM MMM MM MM MMM
    MM M MM M MMM MM MMM MMMMMMM MM MM MMM
    MM MM MMM MM MM MM MMM MM MM MMM
    MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
    MM MM MM MMM MM MM MMMMMM MMMM MMMMM
    MM MMM MaNGOS community forums (Powered by Invision Power Board)
    MMMMMM


    2008-08-06 15:48:52 World Database: 127.0.0.1;3306;root;wow;mangos
    2008-08-06 15:48:52 MySQL client library: 5.0.56
    2008-08-06 15:48:52 MySQL server ver: 5.0.45-community-nt
    2008-08-06 15:48:52 Character Database: 127.0.0.1;3306;root;wow;characters
    2008-08-06 15:48:52 MySQL client library: 5.0.56
    2008-08-06 15:48:52 MySQL server ver: 5.0.45-community-nt
    2008-08-06 15:48:52 Login Database: 127.0.0.1;3306;root;wow;realmd
    2008-08-06 15:48:52 MySQL client library: 5.0.56
    2008-08-06 15:48:52 MySQL server ver: 5.0.45-community-nt
    2008-08-06 15:48:52 Realm running as realm ID 1
    2008-08-06 15:48:52 Using UDB 0.10.3 (357) for MaNGOS rev. 6240 with SD2 SQL for rev. 473
    2008-08-06 15:48:52 Using DataDir ./
    2008-08-06 15:48:52 WORLD: VMap support included. LineOfSight:0, getHeight:0
    2008-08-06 15:48:52 WORLD: VMap data directory is: ./vmaps
    2008-08-06 15:48:52 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2008-08-06 15:48:53
    2008-08-06 15:48:53 Loading MaNGOS strings...
    2008-08-06 15:48:53
    2008-08-06 15:48:53 >> Loaded 503 MaNGOS strings
    2008-08-06 15:48:53 Initialize data stores...
    2008-08-06 15:48:55
    2008-08-06 15:48:55 >> Loaded 55 data stores
    2008-08-06 15:48:55
    2008-08-06 15:48:55 Using Autodetected DBC Locale (0).

    2008-08-06 15:48:55 Loading InstanceTemplate
    2008-08-06 15:48:55 >> Loaded 51 Instance Template definitions
    2008-08-06 15:48:55
    2008-08-06 15:48:55 Loading SkillLineAbilityMultiMap Data...
    2008-08-06 15:48:55
    2008-08-06 15:48:55 >> Loaded 7025 SkillLineAbility MultiMap
    2008-08-06 15:48:55 Cleaning up instances...
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Initialized 0 instances
    2008-08-06 15:48:57 Packing instances...
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Instance numbers remapped, next instance id is 600
    2008-08-06 15:48:57 Loading Localization strings...
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 MaNGOS locale strings. DB table `mangos_string` contains no localization.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 Item locale strings. DB table `locales_item` is empty.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
    2008-08-06 15:48:57
    2008-08-06 15:48:57 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
    2008-08-06 15:48:57 Loading Page Texts...
    2008-08-06 15:48:57 >> Loaded 1389 page texts
    2008-08-06 15:48:57
    2008-08-06 15:48:57 Loading Game Object Templates...
    2008-08-06 15:48:57 >> Loaded 13617 game object templates
    2008-08-06 15:48:57
    2008-08-06 15:48:57 Loading Spell Chain Data...
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 1919 spell chain records
    2008-08-06 15:48:58 Loading Spell Elixir types...
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 98 spell elixir definitions
    2008-08-06 15:48:58 Loading Spell Learn Skills...
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 78 Spell Learn Skills from DBC
    2008-08-06 15:48:58 Loading Spell Learn Spells...
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 14 spell learn spells + 500 found in DBC
    2008-08-06 15:48:58 Loading Spell Proc Event conditions...
    2008-08-06 15:48:58 ERROR:Spell 33280 listed in `spell_proc_event` does not exist
    2008-08-06 15:48:58 ERROR:Spell 35092 listed in `spell_proc_event` does not exist
    2008-08-06 15:48:58 ERROR:Spell 35093 listed in `spell_proc_event` does not exist
    2008-08-06 15:48:58 ERROR:Spell 35094 listed in `spell_proc_event` does not exist
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 947 spell proc event conditions
    2008-08-06 15:48:58 Loading Aggro Spells Definitions...
    2008-08-06 15:48:58 >> Loaded 89 aggro generating spells
    2008-08-06 15:48:58
    2008-08-06 15:48:58 Loading NPC Texts...
    2008-08-06 15:48:58
    2008-08-06 15:48:58 >> Loaded 4357 npc texts
    2008-08-06 15:48:58 Loading Item Random Enchantments Table...
    2008-08-06 15:48:59
    2008-08-06 15:48:59 >> Loaded 28408 Item Enchantment definitions
    2008-08-06 15:48:59 Loading Items...
    2008-08-06 15:49:01 >> Loaded 23753 item prototypes
    2008-08-06 15:49:01
    2008-08-06 15:49:01 ERROR:Item (Entry: 849 not correct 20655 display id, must be 44666 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 3380 not correct 47014 display id, must be 51920 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 3386 not correct 47131 display id, must be 51758 (using it).
    2008-08-06 15:49:01 ERROR:Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
    2008-08-06 15:49:01 Loading Item Texts...
    2008-08-06 15:49:01
    2008-08-06 15:49:01 >> Loaded 0 item pages
    2008-08-06 15:49:01 Loading Creature Model Based Info Data...
    2008-08-06 15:49:01 >> Loaded 16891 creature model based info
    2008-08-06 15:49:01
    2008-08-06 15:49:01 Loading Equipment templates...
    2008-08-06 15:49:01 >> Loaded 1849 equipment template
    2008-08-06 15:49:01
    2008-08-06 15:49:01 Loading Creature templates...
    2008-08-06 15:49:02 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).
    Last edited by vittwow; 08-06-2008 at 08:56 AM.

    [Mangos]an problem with UDB_0.10.3_Core_6240_SD2_473
  2. #2
    Dythzer's Avatar Contributor
    Reputation
    271
    Join Date
    May 2008
    Posts
    461
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to apply all the SQL updates for your mangos core. What revision are you using?

  3. #3
    vittwow's Avatar Banned
    Reputation
    9
    Join Date
    May 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    im dont really know what u mean with revision and apply sql updates but can you help me to apply them bacuse im dont know how to do,

    and please answer quick im cant like to wait and this is the first reply after 30min

  4. #4
    Dythzer's Avatar Contributor
    Reputation
    271
    Join Date
    May 2008
    Posts
    461
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From where did you download it? (the mangos server)

  5. #5
    vittwow's Avatar Banned
    Reputation
    9
    Join Date
    May 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    download it?? im comlied it and im followed this guide WoWEmulator.com - MaNGOS Installation Guide but that with scriptdev2 and apply the files im dont understand

  6. #6
    Dythzer's Avatar Contributor
    Reputation
    271
    Join Date
    May 2008
    Posts
    461
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ah thats good. I thought you would know it then.. Anway, to see what revision you're using, start realmd.exe or mangosd.exe and look at the top and it will say something like <Revision 6430> Then go to the SQL folder in mangos source code and apply all SQL updates between 6240(your DB) and your mangos revision.

    EDIT:
    If you don't understand, read this guide: Board Message
    Last edited by Dythzer; 08-06-2008 at 10:22 AM.

  7. #7
    vittwow's Avatar Banned
    Reputation
    9
    Join Date
    May 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    im use Revision 6420

  8. #8
    Dythzer's Avatar Contributor
    Reputation
    271
    Join Date
    May 2008
    Posts
    461
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your current DB is:
    "UDB_0.10.3_Core_6240_SD2_473"

    That means its made for mangos core revision 6240. To use it with revision 6420 (the one you're using), then apply all SQL files in the SQL/ folder from revision 6240 to 6420

    Note: this is only needed for the mangos database, ignore SQL files that starts with character. Example "6360_characters_corpse"

  9. #9
    vittwow's Avatar Banned
    Reputation
    9
    Join Date
    May 2008
    Posts
    82
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks its works now!

Similar Threads

  1. Mangos core- problem with account creation
    By fusion4500 in forum World of Warcraft General
    Replies: 0
    Last Post: 05-04-2009, 08:34 AM
  2. MaNGOS help, Problem with GM commands.
    By Hatinax in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 03-26-2009, 07:14 AM
  3. Problems with AD.exe Mangos
    By erebos in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 10-31-2008, 07:08 PM
  4. [MaNGOS] Problem with mangosd.exe
    By Nightsky92 in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 09-26-2008, 02:10 PM
  5. [Mangos] Database problem with mangos
    By mEtzG3r in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 07-30-2008, 06:40 AM
All times are GMT -5. The time now is 11:48 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