Mangos SQL Problem

[Toasty!]

After installing everything, when I run mangosd.exe I get this...

World Database: 127.0.0.1;3306;mangos;mangos;mangos
Connected to MySQL database at 127.0.0.1

Login Database: 127.0.0.1;3306;mangos;mangos;realmd
Connected to MySQL database at 127.0.0.1

Realm running as realm ID 1
Using DataDir c:\mangos/ ...
Check existing of map file 'c:\mangos/maps/0004331.map': exist.
Check existing of map file 'c:\mangos/maps/0004832.map': exist.
Check existing of map file 'c:\mangos/maps/0004832.map': exist.
Check existing of map file 'c:\mangos/maps/0013339.map': exist.
Check existing of map file 'c:\mangos/maps/0002828.map': exist.
Check existing of map file 'c:\mangos/maps/0011230.map': exist.
Check existing of map file 'c:\mangos/maps/0013732.map': exist.
Initialize data stores...
==================================================== 100%
>> Loaded 25 data stores


Loading Game Object Templates...
==================================================== 100%
>> Loaded 4179 game object templates
Loading player create info & level stats...
==================================================== 100%
>> Loaded 40 player create definitions

SQL: SELECT `race`,`class`,`itemid`,`amount` FROM `playercreateinfo_item`
query ERROR: Unknown column 'race' in 'field list'
= = 0%
>> Loaded 0 player create items
Error loading `playercreateinfo_item` table or table empty.

SQL: SELECT `race`,`class`,`Spell`,`Active` FROM `playercreateinfo_spell`
query ERROR: Unknown column 'race' in 'field list'
= = 0%
>> Loaded 0 player create spells
Error loading `playercreateinfo_spell` table or table empty.

SQL: SELECT `race`,`class`,`Skill`,`SkillMin`, `SkillMax` FROM `playercreateinfo
_skill`
query ERROR: Unknown column 'race' in 'field list'
= = 0%
>> Loaded 0 player create skills
Error loading `playercreateinfo_skill` table or table empty.

SQL: SELECT `race`,`class`,`button`,`action`,`type`,`misc` FROM `playercreateinf
o_action`
query ERROR: Unknown column 'race' in 'field list'
= = 0%
>> Loaded 0 player create actions
Error loading `playercreateinfo_action` table or table empty.

SQL: SELECT `race`,`class`,`level`,`hp`,`mana`,`str`,`agi`,`sta`,`int`,`spi` FRO
M `player_levelstats`
query ERROR: Table 'mangos.player_levelstats' doesn't exist
= = 0%
>> Loaded 0 level stats definitions
Error loading player_levelstats table or table empty.



Now obviously something is missing, but because I'm new to mangos, I don't know where to start. Could anyone give me some advice to get this thing going?

[MentaL]

[uLtiMabLaDe]

Alright, first of all MAKE SURE your MySQL is running. Second of all make sure you successfully installed SDB 0.5.3 Newest Version. After that your revision is old since it still asks you for your maps directory get a newer core revision, Id suggest 2744 or 2748 for it.

[Tobin]

OK dude. Uhmm are you batching files from the sql folder or from Silver's DB that you got from this forum? If from the sql folder then that maybe your problem. Along with not updating it. I've gotten similar errors from doing that until I figured out that you download Silver's DB separate and batch those files alone.
But you still use the update folder in the sql folder. (I don't think you need it if you get the latest Silver DB though.)
http://forum.ragezone.com/world-warc...-166402-2.html
-Scroll down to the post by urbin.
Also for the latest rev go to Mangos-Files.de
PS: You can find a manual on that site also; it's what I recommend. I don't recommend using the ones on this forum.

[Toasty!]

Alright, I started again from scratch with the link you gave me Tobin and it worked great. Thanks everybody.