Mangos

Results 1 to 14 of 14
  1. #1
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts

    Mangos

    ok i installed mangos... realmd is fine... but mangosd has a problem...

    heres what it say
    Code:
    2007-01-29 21:24:00 Error loading `playercreateinfo` table or table empty.
    2007-01-29 21:24:24 Error loading `playercreateinfo` table or table empty.
    2007-01-29 21:33:04 Error loading `playercreateinfo_item` table or table empty.
    2007-01-29 21:33:04 Error loading `playercreateinfo_spell` table or table empty.
    2007-01-29 21:33:04 Error loading `playercreateinfo_skill` table or table empty.
    2007-01-29 21:33:04 Error loading `playercreateinfo_action` table or table empty.
    2007-01-29 21:33:04 Error loading player_levelstats table or table empty.
    2007-01-29 21:33:23 Error loading `playercreateinfo_item` table or table empty.
    2007-01-29 21:33:23 Error loading `playercreateinfo_spell` table or table empty.
    2007-01-29 21:33:23 Error loading `playercreateinfo_skill` table or table empty.
    2007-01-29 21:33:23 Error loading `playercreateinfo_action` table or table empty.
    2007-01-29 21:33:23 Error loading player_levelstats table or table empty.
    2007-01-29 21:36:35 Error loading `playercreateinfo_item` table or table empty.
    2007-01-29 21:36:35 Error loading `playercreateinfo_spell` table or table empty.
    2007-01-29 21:36:35 Error loading `playercreateinfo_skill` table or table empty.
    2007-01-29 21:36:35 Error loading `playercreateinfo_action` table or table empty.
    2007-01-29 21:36:35 Error loading player_levelstats table or table empty.
    That was my DBErrors

    and here is my Server.log

    Code:
    2007-01-29 21:36:34 World Database: 127.0.0.1;3306;root;mango;mangos
    2007-01-29 21:36:34 Login Database: 127.0.0.1;3306;root;mango;realmd
    2007-01-29 21:36:34 Realm running as realm ID 1
    2007-01-29 21:36:34 Using DataDir C:/mangos/ ...
    2007-01-29 21:36:34 Initialize data stores...
    2007-01-29 21:36:34 
    2007-01-29 21:36:34 >> Loaded 28 data stores
    2007-01-29 21:36:34 
    2007-01-29 21:36:34 Loading Game Object Templates...
    2007-01-29 21:36:35 >> Loaded 4004 game object templates
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 Loading player create info & level stats...
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 40 player create definitions
    2007-01-29 21:36:35 ERROR:SQL: SELECT `race`,`class`,`itemid`,`amount` FROM `playercreateinfo_item`
    2007-01-29 21:36:35 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 0 player create items
    2007-01-29 21:36:35 ERROR:Error loading `playercreateinfo_item` table or table empty.
    2007-01-29 21:36:35 ERROR:SQL: SELECT `race`,`class`,`Spell`,`Active` FROM `playercreateinfo_spell`
    2007-01-29 21:36:35 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 0 player create spells
    2007-01-29 21:36:35 ERROR:Error loading `playercreateinfo_spell` table or table empty.
    2007-01-29 21:36:35 ERROR:SQL: SELECT `race`,`class`,`Skill`,`SkillMin`, `SkillMax` FROM `playercreateinfo_skill`
    2007-01-29 21:36:35 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 0 player create skills
    2007-01-29 21:36:35 ERROR:Error loading `playercreateinfo_skill` table or table empty.
    2007-01-29 21:36:35 ERROR:SQL: SELECT `race`,`class`,`button`,`action`,`type`,`misc` FROM `playercreateinfo_action`
    2007-01-29 21:36:35 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 0 player create actions
    2007-01-29 21:36:35 ERROR:Error loading `playercreateinfo_action` table or table empty.
    2007-01-29 21:36:35 ERROR:SQL: SELECT `race`,`class`,`level`,`hp`,`mana`,`str`,`agi`,`sta`,`int`,`spi` FROM `player_levelstats`
    2007-01-29 21:36:35 ERROR:query ERROR: Table 'mangos.player_levelstats' doesn't exist
    2007-01-29 21:36:35 
    2007-01-29 21:36:35 >> Loaded 0 level stats definitions
    2007-01-29 21:36:35 ERROR:Error loading player_levelstats table or table empty.

    can someone help me fix this?

    thanx :D... and how do u make a website with mangos... or is it possible?


  2. #2
    Lord of the Legion Darkicon is offline
    Grand MasterRank
    Jul 2005 Join Date
    El Segundo, CALocation
    504Posts
    You didn't execute the SQLs, you only executed one of the SQLs. One of them is for the structure of the SQL, and the other is for all the data.

  3. #3
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    eh... huh?


    so what do i do?... i Executed 50.sql (for Mangos for the SBD)
    and executed Relmd.sql (for realmd :P)

    so what do u say i do now?

  4. #4
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    ok... i see many Mangos servers up and people have gotten them to work... so i dont know what i did wrong.. ima try and re-restore the 050.sql update (SDB) and see if that works... any other suggestions... or just start over?

  5. #5
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Search your mangos folder for SQLs and list them here, and we'll gladly guide you as to which ones and in which order you should execute.

  6. #6
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts

  7. #7
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Hmm.. Do you get any errors when you execute 50.sql?

  8. #8
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    nope no errors... just takes forever to go thru

  9. #9
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Hmm... well, the error is saying that there are no playercreate tables, so try using the mangos.sql, instead of the 50.sql, then work from there.

  10. #10
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    hmmm... that one gives me an error

  11. #11
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Dump your mangos DB first, then execute the mangos.sql. It shouldn't give you an error then.

  12. #12
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    still gives me an error :(

  13. #13
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    i was looking at sumptin... and this is the only tru error i get
    Code:
    2007-01-30 17:01:41 Error loading `playercreateinfo_item` table or table empty.
    2007-01-30 17:01:41 Error loading `playercreateinfo_spell` table or table empty.
    2007-01-30 17:01:41 Error loading `playercreateinfo_skill` table or table empty.
    2007-01-30 17:01:41 Error loading `playercreateinfo_action` table or table empty.
    2007-01-30 17:01:41 Error loading player_levelstats table or table empty.
    .. the rest were just me trying several times

  14. #14
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    ok i redid it... and i am no longer getting errors like the one above me....

    this is ALL im receiving now...


    Code:
    2007-01-30 19:24:17 World Database: 127.0.0.1;3306;root;mangos;mangos
    2007-01-30 19:24:17 Login Database: 127.0.0.1;3306;root;mangos;realmd
    2007-01-30 19:24:17 Realm running as realm ID 1
    2007-01-30 19:24:17 Using DataDir c:/mangos/ ...
    2007-01-30 19:24:17 Initialize data stores...
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 28 data stores
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 Loading Game Object Templates...
    2007-01-30 19:24:18 >> Loaded 4004 game object templates
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 Loading player create info & level stats...
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 40 player create definitions
    2007-01-30 19:24:18 ERROR:SQL: SELECT `race`,`class`,`itemid`,`amount` FROM `playercreateinfo_item`
    2007-01-30 19:24:18 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 0 player create items
    2007-01-30 19:24:18 ERROR:Error loading `playercreateinfo_item` table or table empty.
    2007-01-30 19:24:18 ERROR:SQL: SELECT `race`,`class`,`Spell`,`Active` FROM `playercreateinfo_spell`
    2007-01-30 19:24:18 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 0 player create spells
    2007-01-30 19:24:18 ERROR:Error loading `playercreateinfo_spell` table or table empty.
    2007-01-30 19:24:18 ERROR:SQL: SELECT `race`,`class`,`Skill`,`SkillMin`, `SkillMax` FROM `playercreateinfo_skill`
    2007-01-30 19:24:18 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 0 player create skills
    2007-01-30 19:24:18 ERROR:Error loading `playercreateinfo_skill` table or table empty.
    2007-01-30 19:24:18 ERROR:SQL: SELECT `race`,`class`,`button`,`action`,`type`,`misc` FROM `playercreateinfo_action`
    2007-01-30 19:24:18 ERROR:query ERROR: Unknown column 'race' in 'field list'
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 0 player create actions
    2007-01-30 19:24:18 ERROR:Error loading `playercreateinfo_action` table or table empty.
    2007-01-30 19:24:18 ERROR:SQL: SELECT `race`,`class`,`level`,`hp`,`mana`,`str`,`agi`,`sta`,`int`,`spi` FROM `player_levelstats`
    2007-01-30 19:24:18 ERROR:query ERROR: Table 'mangos.player_levelstats' doesn't exist
    2007-01-30 19:24:18 
    2007-01-30 19:24:18 >> Loaded 0 level stats definitions
    2007-01-30 19:24:18 ERROR:Error loading player_levelstats table or table empty.
    and idea how to fix er?



Advertisement