Mangos

Results 1 to 14 of 14
  1. 30-01-07 #1
    ScreWe
    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?
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    Mangos
  3. 30-01-07 #2
    Darkicon
    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.
    Reply With Quote Reply With Quote
  4. 30-01-07 #3
    ScreWe
    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?
    Reply With Quote Reply With Quote
  5. 30-01-07 #4
    ScreWe
    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?
    Reply With Quote Reply With Quote
  6. 30-01-07 #5
    Yamachi
    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.
    Reply With Quote Reply With Quote
  7. 30-01-07 #6
    ScreWe
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    Reply With Quote Reply With Quote
  8. 30-01-07 #7
    Yamachi
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Hmm.. Do you get any errors when you execute 50.sql?
    Reply With Quote Reply With Quote
  9. 30-01-07 #8
    ScreWe
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    nope no errors... just takes forever to go thru
    Reply With Quote Reply With Quote
  10. 30-01-07 #9
    Yamachi
    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.
    Reply With Quote Reply With Quote
  11. 30-01-07 #10
    ScreWe
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    hmmm... that one gives me an error
    Reply With Quote Reply With Quote
  12. 30-01-07 #11
    Yamachi
    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.
    Reply With Quote Reply With Quote
  13. 30-01-07 #12
    ScreWe
    Newbie ScreWe is offline
    MemberRank
    Jan 2007 Join Date
    16Posts
    still gives me an error :(
    Reply With Quote Reply With Quote
  14. 30-01-07 #13
    ScreWe
    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
    Reply With Quote Reply With Quote
  15. 31-01-07 #14
    ScreWe
    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?
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement