I have a problem when i connect to my mangos server

Results 1 to 8 of 8
  1. 10-12-06 #1
    cr3ad
    Newbie cr3ad is offline
    MemberRank
    Dec 2006 Join Date
    5Posts

    I have a problem when i connect to my mangos server

    Hello can you help me please? I have a problem with my server mangos. I have follow your tutorial in this site but when i connect to my server, it show me again the list of server. It make the same in localhost or a localnetwork

    i have some error message when i launch mangosd.exe,

    2006-12-10 13:57:49 World Database: 127.0.0.1;3306;root;mangos;mangos
    2006-12-10 13:57:49 Login Database: 127.0.0.1;3306;root;mangos;realmd
    2006-12-10 13:57:49 Realm running as realm ID 1
    2006-12-10 13:57:50 Using DataDir c:\Mangos/ ...
    2006-12-10 13:57:50 Initialize data stores...
    2006-12-10 13:57:50
    2006-12-10 13:57:50 >> Loaded 25 data stores
    2006-12-10 13:57:50
    2006-12-10 13:57:50 Loading Game Object Templates...
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 4179 game object templates
    2006-12-10 13:57:51 Loading player create info & level stats...
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 40 player create definitions
    2006-12-10 13:57:51 ERROR:SQL: SELECT `race`,`class`,`itemid`,`amount` FROM `playercreateinfo_item`
    2006-12-10 13:57:51 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 0 player create items
    2006-12-10 13:57:51 ERROR:Error loading `playercreateinfo_item` table or table empty.
    2006-12-10 13:57:51 ERROR:SQL: SELECT `race`,`class`,`Spell`,`Active` FROM `playercreateinfo_spell`
    2006-12-10 13:57:51 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 0 player create spells
    2006-12-10 13:57:51 ERROR:Error loading `playercreateinfo_spell` table or table empty.
    2006-12-10 13:57:51 ERROR:SQL: SELECT `race`,`class`,`Skill`,`SkillMin`, `SkillMax` FROM `playercreateinfo_skill`
    2006-12-10 13:57:51 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 0 player create skills
    2006-12-10 13:57:51 ERROR:Error loading `playercreateinfo_skill` table or table empty.
    2006-12-10 13:57:51 ERROR:SQL: SELECT `race`,`class`,`button`,`action`,`type`,`misc` FROM `playercreateinfo_action`
    2006-12-10 13:57:51 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 0 player create actions
    2006-12-10 13:57:51 ERROR:Error loading `playercreateinfo_action` table or table empty.
    2006-12-10 13:57:51 ERROR:SQL: SELECT `race`,`class`,`level`,`hp`,`mana`,`str`,`agi`,`sta`,`int`,`spi` FROM `player_levelstats`
    2006-12-10 13:57:51 ERROR:query ERROR: Table 'mangos.player_levelstats' doesn't exist
    2006-12-10 13:57:51
    2006-12-10 13:57:51 >> Loaded 0 level stats definitions
    2006-12-10 13:57:51 ERROR:Error loading player_levelstats table or table empty.

    can you help me please?
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    I have a problem when i connect to my mangos server
  3. 10-12-06 #2
    mostafa_afus
    Member mostafa_afus is offline
    MemberRank
    Jul 2006 Join Date
    USALocation
    44Posts
    ok well you have wrong DB ,- common Problem- you patched SQL DB File and update any of update files in sql directory in your mangos directory ,

    re install DB and read complete Readme file in sql directory
    Reply With Quote Reply With Quote
  4. 10-12-06 #3
    mostafa_afus
    Member mostafa_afus is offline
    MemberRank
    Jul 2006 Join Date
    USALocation
    44Posts
    ok well you have wrong DB ,- common Problem- you patched SQL DB File and update any of update files in sql directory in your mangos directory ,

    re install DB and read complete Readme file in sql directory
    Reply With Quote Reply With Quote
  5. 10-12-06 #4
    cr3ad
    Newbie cr3ad is offline
    MemberRank
    Dec 2006 Join Date
    5Posts
    ok thx i go test this
    Reply With Quote Reply With Quote
  6. 10-12-06 #5
    cr3ad
    Newbie cr3ad is offline
    MemberRank
    Dec 2006 Join Date
    5Posts
    ok i have install all now when i launch the server i have

    2006-12-10 16:59:02 World Database: 127.0.0.1;3306;root;mangos;mangos
    2006-12-10 16:59:02 Login Database: 127.0.0.1;3306;root;mangos;realmd
    2006-12-10 16:59:02 Realm running as realm ID 1
    2006-12-10 16:59:02 Using DataDir c:\mangos\ ...
    2006-12-10 16:59:02 Initialize data stores...
    2006-12-10 16:59:03
    2006-12-10 16:59:03 >> Loaded 24 data stores
    2006-12-10 16:59:03
    2006-12-10 16:59:03 Loading Game Object Templates...
    2006-12-10 16:59:03 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 19 fields in sql).

    it's the same problem?
    Reply With Quote Reply With Quote
  7. 10-12-06 #6
    anatem
    Elite Member anatem is offline
    Member +Rank
    Oct 2006 Join Date
    169Posts
    yes. make fresh install of db with latest core and database updates and you'll be ok
    Reply With Quote Reply With Quote
  8. 11-12-06 #7
    cr3ad
    Newbie cr3ad is offline
    MemberRank
    Dec 2006 Join Date
    5Posts
    Bigbig thanks to you my server work :D

    but i can't connect to my server with a other computer on my local network i can connect on the server only with a client on the server

    have you an idea for correct this?



    (sorry for my english)
    Reply With Quote Reply With Quote
  9. 11-12-06 #8
    cr3ad
    Newbie cr3ad is offline
    MemberRank
    Dec 2006 Join Date
    5Posts
    ok it's all right, all work

    many thx to you for yours suggest!
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement