[Mangos Zero] [Solved] Database error

[Andrene]

When I try to update the data bases to resolve

2016-04-20 19:00:36 ERROR:The table `db_version` indicates that your [Realmd] database does not match the expected version!
2016-04-20 19:00:36 ERROR:
2016-04-20 19:00:36 ERROR:  [A] You have database Version: 21
2016-04-20 19:00:36 ERROR:                      Structure: 1
2016-04-20 19:00:36 ERROR:                        Content: 2
2016-04-20 19:00:36 ERROR:                    Description: dbdocs update
2016-04-20 19:00:36 ERROR:
2016-04-20 19:00:36 ERROR:  [b] You need database Version: 21
2016-04-20 19:00:36 ERROR:                      Structure: 1
2016-04-20 19:00:36 ERROR:                        Content: 0
2016-04-20 19:00:36 ERROR:                    Description: revision_refactor
2016-04-20 19:00:36 ERROR:
2016-04-20 19:00:36 ERROR:You are missing content updates or you have content updates beyond the expected core version.
2016-04-20 19:00:36 ERROR:It is recommended to run ALL database updates up to the required core version.
2016-04-20 19:00:36 ERROR:These updates are included in the database/Realmd/Updates folder.
2016-04-20 19:00:36 ERROR:No valid realms specified.

I get ERROR 1146 (42S02) at line 4: Table 'realmdzero.realmd_db_version' doesn't exist

[antz]

Since your database is newer than your realmd process, you need to grab the latest code and recompile realmd

[Andrene]

I got realmd to work. But mangosd isnt working.

2016-04-22 06:38:56 ERROR:The table `db_version` indicates that your [World] database does not match the expected version!
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:  [A] You have database Version: 21
2016-04-22 06:38:56 ERROR:                      Structure: 1
2016-04-22 06:38:56 ERROR:                        Content: 9
2016-04-22 06:38:56 ERROR:                    Description: Backports part2
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:  [b] You need database Version: 21
2016-04-22 06:38:56 ERROR:                      Structure: 1
2016-04-22 06:38:56 ERROR:                        Content: 0
2016-04-22 06:38:56 ERROR:                    Description: revision_refactor
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:You are missing content updates or you have content updates beyond the expected core version.
2016-04-22 06:38:56 ERROR:It is recommended to run ALL database updates up to the required core version.
2016-04-22 06:38:56 ERROR:These updates are included in the database/World/Updates folder.
2016-04-22 06:38:56 Character Database total connections: 2
2016-04-22 06:38:56 MySQL client library: 5.6.26
2016-04-22 06:38:56 MySQL server ver: 5.7.11-log 
2016-04-22 06:38:56 MySQL client library: 5.6.26
2016-04-22 06:38:56 MySQL server ver: 5.7.11-log 
2016-04-22 06:38:56 ERROR:The table `db_version` indicates that your [Character] database does not match the expected structure!
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:  [A] You have database Version: 21
2016-04-22 06:38:56 ERROR:                      Structure: 5
2016-04-22 06:38:56 ERROR:                        Content: 1
2016-04-22 06:38:56 ERROR:                    Description: characters_pvpstats
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:  [b] You need database Version: 21
2016-04-22 06:38:56 ERROR:                      Structure: 1
2016-04-22 06:38:56 ERROR:                        Content: 0
2016-04-22 06:38:56 ERROR:                    Description: revision_refactor
2016-04-22 06:38:56 ERROR:
2016-04-22 06:38:56 ERROR:You must apply all updates after [A] to [b] to use MaNGOS with this database.
2016-04-22 06:38:56 ERROR:These updates are included in the database/Character/Updates folder.

Im guessing i have to do the same thing i did for realmd?

[Andrene]

New Error...

2016-04-22 17:45:58 Using configuration file mangosd.conf.
2016-04-22 17:45:58 World Database total connections: 2
2016-04-22 17:45:58 MySQL client library: 5.6.26
2016-04-22 17:45:58 MySQL server ver: 5.7.11-log 
2016-04-22 17:45:58 MySQL client library: 5.6.26
2016-04-22 17:45:58 MySQL server ver: 5.7.11-log 
2016-04-22 17:45:58 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1
2016-04-22 17:45:58 ERROR:query ERROR: Unknown column 'structure' in 'field list'
2016-04-22 17:45:58 ERROR:The table `db_version` in your [World] database is missing or corrupt.
2016-04-22 17:45:58 ERROR:
2016-04-22 17:45:58 ERROR:  [A] You have database Version: MaNGOS can not verify your database version or its existence!
2016-04-22 17:45:58 ERROR:
2016-04-22 17:45:58 ERROR:  [b] You need database Version: 21
2016-04-22 17:45:58 ERROR:                      Structure: 1
2016-04-22 17:45:58 ERROR:                        Content: 0
2016-04-22 17:45:58 ERROR:                    Description: revision_refactor
2016-04-22 17:45:58 ERROR:
2016-04-22 17:45:58 ERROR:Please verify your database location or your database integrity.

Picture of db_version for the [World] DB Imgur: The most awesome images on the Internet

[antz]

ok, thats odd.... I would replace your mangosd.exe with the latest version as well

[Andrene]

Now the exe loads further. New Error time!!!

2016-04-28 17:26:36 
2016-04-28 17:26:36 Loading Creature templates...
2016-04-28 17:26:37 ERROR:Error in creature_template table.Perhaps the table structure was changed. There should be 70 fields in the table.

[Andrene]

Got it to work. Just had to re-create the World Database.

[antz]

Glad you got it working