mangos zero Error when trying to update db

[lurr]

2017-01-16 07:25:06 ERROR:The table `db_version` indicates that your [World] database does not match the expected structure!
2017-01-16 07:25:06 ERROR:
2017-01-16 07:25:06 ERROR:  [A] You have database Version: 21
2017-01-16 07:25:06 ERROR:                      Structure: 12
2017-01-16 07:25:06 ERROR:                        Content: 1
2017-01-16 07:25:06 ERROR:                    Description: AutoBroadcast
2017-01-16 07:25:06 ERROR:
2017-01-16 07:25:06 ERROR:   You need database Version: 21
2017-01-16 07:25:06 ERROR:                      Structure: 11
2017-01-16 07:25:06 ERROR:                        Content: 73
2017-01-16 07:25:06 ERROR:                    Description: Script_Binding
2017-01-16 07:25:06 ERROR:
2017-01-16 07:25:06 ERROR:You must apply all updates after [A] to to use MaNGOS with this database.
2017-01-16 07:25:06 ERROR:These updates are included in the database/World/Updates folder.

 

I've have tried adding that missing sql. Didn't do anything. Whats wrong?

[H0zen]

The issue you have simply states your database and core are not updated at the same level (in your case, you updated the database to the latest version, but not the source code for mangosd).

To solve this, you have 2 options:

1. Leave the source code untouched, recreate the database and don't apply the update World/Updates/Rel21/Rel21_12_01_autobroadcast.sql
2. Leave your database untouched, update the server source code to the latest version and rebuild

[mpfans]

update the source code and rebuild.

>git pull origin master

[lurr]

Thanks, is it possible to export current world,realmd and characters and then reimport it to the new build? Or will that create even more errors?

[H0zen]

If you choose to update the source code, you don't need to alter the current database (chars, world, realmd). The only issue is the mangosd.conf version is changed in the latest build and you have to reconfigure your server using the new format.

[antz]

also see:

 

[lurr]

Okey, thank you!

[madmax]

Marking this as resolved. Feel free to open a new topic should you need further help.