[Mangos] Character Creation Troubles

[Ahren]

Everything up to the point of character creation is fine, but once I get to that, all created characters are naked, and have no spells.

I looked through my logs to find this:

2006-11-08 17:30:11 ERROR:SQL: SELECT `itemid`,`amount` FROM `playercreateinfo_item` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT `Spell`,`Active` FROM `playercreateinfo_spell` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT `Skill`, `SkillMin`, `SkillMax` FROM `playercreateinfo_skill` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT

It's right those columns don't exist in my database. I'm using Mangos 2614 and SDB 0.5.2 Rev 272. Should I be using something different? I had a similar problem with my realmdb database but it was simple to fix, whereas this would require a lot of fixing so i'm assuming that I have something wrong here.

[MentaL]

[draculas]

Everything up to the point of character creation is fine, but once I get to that, all created characters are naked, and have no spells.

I looked through my logs to find this:

2006-11-08 17:30:11 ERROR:SQL: SELECT `itemid`,`amount` FROM `playercreateinfo_item` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT `Spell`,`Active` FROM `playercreateinfo_spell` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT `Skill`, `SkillMin`, `SkillMax` FROM `playercreateinfo_skill` WHERE `race` = '2' AND `class` = '1'
2006-11-08 17:30:11 ERROR:query ERROR: Unknown column 'race' in 'where clause'
2006-11-08 17:30:11 ERROR:SQL: SELECT

It's right those columns don't exist in my database. I'm using Mangos 2614 and SDB 0.5.2 Rev 272. Should I be using something different? I had a similar problem with my realmdb database but it was simple to fix, whereas this would require a lot of fixing so i'm assuming that I have something wrong here.

The same here.
Thank you for help !

[merzliakov]

Apply to DB sql updates from mangos sql/updates directory.