Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mangos Update UDB issues

Initiate Mage
Joined
Jan 26, 2012
Messages
1
Reaction score
0
Continually getting this error, no matter what updates I apply, or even rebuilding DB from scratch. Help! Thanks in advance:)

2012-01-28 21:09:07 SQL: SELECT required_11885_01_mangos_spell_proc_event FROM db_version LIMIT 1
2012-01-28 21:09:07 query ERROR: Unknown column 'required_11885_01_mangos_spell_proc_event' in 'field list'
2012-01-28 21:09:07 The table `db_version` in your [WORLD] database indicates that this database is out of date!
2012-01-28 21:09:07
2012-01-28 21:09:07 [A] You have: --> `11831_02_mangos_command.sql`
2012-01-28 21:09:07
2012-01-28 21:09:07 You need: --> `11885_01_mangos_spell_proc_event.sql`
2012-01-28 21:09:07
2012-01-28 21:09:07 You must apply all updates after [A] to to use mangos with this database.
2012-01-28 21:09:07 These updates are included in the sql/updates folder.
2012-01-28 21:09:07 Please read the included [README] in sql/updates for instructions on updating.
 
Lord of the Legion
Joined
Jul 28, 2005
Messages
426
Reaction score
35
You need to apply the updates sql/updates in the CORE directory (Not the DB directory) in the proper order, starting with 11831_02_mangos_command.sql all the way to 11885_01_mangos_spell_proc_event.sql in order. It won't allow you to apply an update that isn't required yet or already has been applied.
 
Joined
May 19, 2007
Messages
440
Reaction score
78
I tried YTDB and UDB I get (such) error, but I cannot import or execute "updates" correctly. Always some error popups.

E: Alter table command was some error, because it popped up something about it many times. I opened Workbench and I did like command bat said and now it's working.
 
Last edited:
Back
Top