UDB MySQL Error

[WM89]

I need a little help...

When I try to execute my UDB update files, I keep getting this error...

Someone, please help me ?

Here is a image http://yfrog.com/j4errorfp

[YuruY]

Open Error File ...

[WM89]

Query:

ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-04-28 11:37:22

Line no.:2

Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-04-28 11:37:49

Line no.:2

Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-04-28 12:03:32

Line no.:2

Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9250_01_characters_character required_9339_01_characters_group bit

Error occured at:2010-04-28 12:14:51

Line no.:2

Error Code: 1054 - Unknown column 'required_9250_01_characters_character' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN required_9630_01_characters_characters required_9632_01_characters_characters bit

Error occured at:2010-04-28 12:32:34

Line no.:2

Error Code: 1054 - Unknown column 'required_9630_01_characters_characters' in 'character_db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9309_01_mangos_quest_template required_9310_01_mangos_spell_elixir bit

Error occured at:2010-04-28 13:07:03

Line no.:1

Error Code: 1054 - Unknown column 'required_9309_01_mangos_quest_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9309_01_mangos_quest_template required_9310_01_mangos_spell_elixir bit

Error occured at:2010-04-28 13:07:20

Line no.:1

Error Code: 1054 - Unknown column 'required_9309_01_mangos_quest_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-04-28 13:14:49

Line no.:2

Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9309_01_mangos_quest_template required_9310_01_mangos_spell_elixir bit

Error occured at:2010-04-28 13:15:57

Line no.:1

Error Code: 1054 - Unknown column 'required_9309_01_mangos_quest_template' in 'db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN required_9310_01_mangos_spell_elixir required_9312_01_mangos_quest_template bit

Error occured at:2010-04-28 13:53:07

Line no.:2

Error Code: 1054 - Unknown column 'required_9310_01_mangos_spell_elixir' in 'db_version'

[NickoNiklas]

Check the UDB forum on how to update the UDB database.

The UDB update you are trying to run, does not work with your database,

you must apply the correct ones, in the correct order.

For example (with the current UDB database for mangos rev. 9763),

for a clean install, you must first create the mangos database,

apply the "UDB_0.12.0_mangos_9582_SD2_1639.sql" to the mangos db,

then continue with the UDB updates starting with "388_corepatch_mangos_9311_to_9582.sql" and "388_updatepack_mangos.sql",

and then "389_corepatch_mangos_9583_to_9630.sql" and "389_updatepack_mangos.sql".

And so on until you have reached the current mangos rev. you are using (either by UDB updates or by some extra mangos sql updates if needed).

But this is all explained in the UDB forum,

so I won't go into details.