Jump to content

UDB MySQL Error


Guest WM89

Recommended Posts

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'

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use