[Mangos Zero] How do I correctly update my Mangos Zero mangos0 DB?

[fischerlol]

Hi,

I recently followed a guide on how to install Mangos and it all went well untill now. Apparently my database is out of date and I have no clue how to fix that. I applied the updates in rel21 and in Rel20_to_BaseRel21_Updates.

I got the core and the database from the following guide

This is the error I am getting after applying the above updates:

2016-05-03 15:27:21 21000 [world-daemon]

2016-05-03 15:27:21 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: getMaNGOS | The home of MaNGOS - Home / // -_) '_/ _ \

Forum / Wiki: getMaNGOS | The home of MaNGOS - Home /___\___|_| \___/

2016-05-03 15:27:21 Using configuration file mangosd.conf.

2016-05-03 15:27:21 World Database total connections: 2

2016-05-03 15:27:21 MySQL client library: 5.6.25

2016-05-03 15:27:21 MySQL server ver: 5.6.25-log

2016-05-03 15:27:21 MySQL client library: 5.6.25

2016-05-03 15:27:21 MySQL server ver: 5.6.25-log

2016-05-03 15:27:21 ERROR:The table `db_version` indicates that your [World] database does not match the expected structure!

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR: [A] You have database Version: 21

2016-05-03 15:27:21 ERROR: Structure: 1

2016-05-03 15:27:21 ERROR: Content: 19

2016-05-03 15:27:21 ERROR: Description: SD3_Updates

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR: You need database Version: 21

2016-05-03 15:27:21 ERROR: Structure: 11

2016-05-03 15:27:21 ERROR: Content: 7

2016-05-03 15:27:21 ERROR: Description: Fix BG buffs

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR:You must apply all updates after [A] to to use MaNGOS with this database.

2016-05-03 15:27:21 ERROR:These updates are included in the database/World/Updates folder.

Thanks in advance

[krill]

Hi,

I recently followed a guide on how to install Mangos and it all went well untill now. Apparently my database is out of date and I have no clue how to fix that. I applied the updates in rel21 and in Rel20_to_BaseRel21_Updates.

I got the core and the database from the following guide

This is the error I am getting after applying the above updates:

2016-05-03 15:27:21 21000 [world-daemon]

2016-05-03 15:27:21 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: getMaNGOS | The home of MaNGOS - Home / // -_) '_/ _ \

Forum / Wiki: getMaNGOS | The home of MaNGOS - Home /___\___|_| \___/

2016-05-03 15:27:21 Using configuration file mangosd.conf.

2016-05-03 15:27:21 World Database total connections: 2

2016-05-03 15:27:21 MySQL client library: 5.6.25

2016-05-03 15:27:21 MySQL server ver: 5.6.25-log

2016-05-03 15:27:21 MySQL client library: 5.6.25

2016-05-03 15:27:21 MySQL server ver: 5.6.25-log

2016-05-03 15:27:21 ERROR:The table `db_version` indicates that your [World] database does not match the expected structure!

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR: [A] You have database Version: 21

2016-05-03 15:27:21 ERROR: Structure: 1

2016-05-03 15:27:21 ERROR: Content: 19

2016-05-03 15:27:21 ERROR: Description: SD3_Updates

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR: You need database Version: 21

2016-05-03 15:27:21 ERROR: Structure: 11

2016-05-03 15:27:21 ERROR: Content: 7

2016-05-03 15:27:21 ERROR: Description: Fix BG buffs

2016-05-03 15:27:21 ERROR:

2016-05-03 15:27:21 ERROR:You must apply all updates after [A] to to use MaNGOS with this database.

2016-05-03 15:27:21 ERROR:These updates are included in the database/World/Updates folder.

Thanks in advance

database/World/Updates/Rel21 at develop21 * mangoszero/database * GitHub

It wants database/Rel21_11_7_bg_buffs_fix.sql at develop21 * mangoszero/database * GitHub

but you don't have it applied.

If you DID apply it and it is still throwing that, you may need to redo the DB.

[fischerlol]

database/World/Updates/Rel21 at develop21 * mangoszero/database * GitHub

It wants database/Rel21_11_7_bg_buffs_fix.sql at develop21 * mangoszero/database * GitHub

but you don't have it applied.

If you DID apply it and it is still throwing that, you may need to redo the DB.

I redid the database and installed the updates in Rel21 and now it is somewhat working. I have a few errors in the mangosd but it still starts up the server

Should I be worried about these errors? : (log)

[antz]

The last stage before a full release is a cleanup of any startup errors.

As we are really close to the release, an update was added over the weekend with clears a majority of them up now.