Mangos SQL Updates

[FuzzyPillow]

Hello im a newbie far as compiling a mangos core well i got everything down but doing sql updates this is what i get.

2010-01-22 18:49:24 MaNGOS/0.16.0-DEV (* * Revision 9225 - *) for Win32 (little-endian) [world-daemon]
2010-01-22 18:49:24 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM getmangos.com > Home
MMMMMM


2010-01-22 18:49:24 Using configuration file mangosd.conf.
2010-01-22 18:49:24 World Database: 127.0.0.1;3306;root;ascent;mangos
2010-01-22 18:49:24 MySQL client library: 5.0.56
2010-01-22 18:49:24 MySQL server ver: 5.1.41-community
2010-01-22 18:49:24 ERROR:SQL: SELECT required_9222_01_mangos_playercreateinfo_spell FROM db_version LIMIT 1
2010-01-22 18:49:24 ERROR:query ERROR: Unknown column 'required_9222_01_mangos_playercreateinfo_spell' in 'field list'
2010-01-22 18:49:24 ERROR:Table `db_version` have field `required_8803_02_mangos_playercreateinfo_action` but expected `required_9222_01_mangos_playercreateinfo_spell`! Not all sql updates applied?

And this is the table dbversion saids:

UDB 0.11.6 (386) for MaNGOS 8994 with SD2 SQL for rev. 1516

+Rep to anyone that can help me.

[Kiev]

There should be a folder when you download the ManGOS core saying something with SQL. If you execute all those into your database, that might fix it.

[Brucey125]

You have either missed out the updates loacated in the core folder in sql/updates or not done them at all and just put in the DB.

You need to go into the core sql/updates folder and locate the update it says is require and put that in the go up from there untill you hit the latest update then try restarting the server :P should work

[Kiev]

As i stated, but more depth to it.

[FuzzyPillow]

Yea i imported all of the updates besides the ones in the subfolders and i still get this same thing.

[Kiev]

Subfolders tend to be important to i remember.