[Mangos One] Errors Updating MySQL Databases

[Nameback]

So I've learned a ton in my time here and I'm SO CLOSE to having my server up and running, I just have one issue. When I'm using SQLyog to try and update my databases it keeps throwing errors. Realmd is fine, it's Characters and the World server that are both giving me trouble. The worst part is I have all the appropriate updates SQLyog just doesn't like applying them, I could try via the command line but I don't want to break anything after coming this far.

Here's the errors:

Characters:

uery:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:00:35

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:00:52

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:01:09

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_21000_00_Release_021_Initial` `required_21000_01_warden_action` bit

Error occured at:2016-04-27 13:02:21

Line no.:2

Error Code: 1054 - Unknown column 'required_21000_00_Release_021_Initial' in 'character_db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN `required_21000_01_Release21_initial` `required_21000_02_warden_checks` BIT

Error occured at:2016-04-27 14:15:58

Line no.:1

Error Code: 1054 - Unknown column 'required_21000_01_Release21_initial' in 'db_version'

Query:

-- Apply the Version Change from Old Version to New Version

ALTER TABLE realmd_db_version CHANGE COLUMN `required_20150412_warden_db_log` `required_20150412_auth_realmlist` BIT

Error occured at:2016-04-27 14:57:24

Line no.:4

Error Code: 1146 - Table 'realmd.realmd_db_version' doesn't exist

Query:

ALTER TABLE realmd_db_version CHANGE COLUMN `required_20150420_warden_db_log` `required_20150722_01_realmcharacters_remove_constraint` BIT

Error occured at:2016-04-27 14:57:53

Line no.:4

Error Code: 1146 - Table 'realmd.realmd_db_version' doesn't exist

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20001_02_dbdocs_Update` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 16:44:53

Line no.:2

Error Code: 1146 - Table 'characters.character_db_version' doesn't exist

Then World, when I try to go from 21_3_3 to 21_3_4, because you do need to go sequentially correct?

uery:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:00:35

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:00:52

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20005_01_characters_pvpstats` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 13:01:09

Line no.:2

Error Code: 1054 - Unknown column 'required_20005_01_characters_pvpstats' in 'character_db_version'

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_21000_00_Release_021_Initial` `required_21000_01_warden_action` bit

Error occured at:2016-04-27 13:02:21

Line no.:2

Error Code: 1054 - Unknown column 'required_21000_00_Release_021_Initial' in 'character_db_version'

Query:

ALTER TABLE db_version CHANGE COLUMN `required_21000_01_Release21_initial` `required_21000_02_warden_checks` BIT

Error occured at:2016-04-27 14:15:58

Line no.:1

Error Code: 1054 - Unknown column 'required_21000_01_Release21_initial' in 'db_version'

Query:

-- Apply the Version Change from Old Version to New Version

ALTER TABLE realmd_db_version CHANGE COLUMN `required_20150412_warden_db_log` `required_20150412_auth_realmlist` BIT

Error occured at:2016-04-27 14:57:24

Line no.:4

Error Code: 1146 - Table 'realmd.realmd_db_version' doesn't exist

Query:

ALTER TABLE realmd_db_version CHANGE COLUMN `required_20150420_warden_db_log` `required_20150722_01_realmcharacters_remove_constraint` BIT

Error occured at:2016-04-27 14:57:53

Line no.:4

Error Code: 1146 - Table 'realmd.realmd_db_version' doesn't exist

Query:

ALTER TABLE character_db_version CHANGE COLUMN `required_20001_02_dbdocs_Update` `required_21000_00_Release_021_Initial` bit

Error occured at:2016-04-27 16:44:53

Line no.:2

Error Code: 1146 - Table 'characters.character_db_version' doesn't exist

This is the error the server log is throwing in general

2016-04-27 17:20:23 21000 [world-daemon]

2016-04-27 17:20:23 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

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

| |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade

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

___

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

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

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

2016-04-27 17:20:23 Using configuration file mangosd.conf.

2016-04-27 17:20:23 World Database total connections: 2

2016-04-27 17:20:24 MySQL client library: 5.7.12

2016-04-27 17:20:24 MySQL server ver: 5.5.48

2016-04-27 17:20:25 MySQL client library: 5.7.12

2016-04-27 17:20:25 MySQL server ver: 5.5.48

2016-04-27 17:20:25 ERROR:The table `db_version` indicates that your [World] database does not match the expected version!

2016-04-27 17:20:25 ERROR:

2016-04-27 17:20:25 ERROR: [A] You have database Version: 21

2016-04-27 17:20:25 ERROR: Structure: 3

2016-04-27 17:20:25 ERROR: Content: 3

2016-04-27 17:20:25 ERROR: Description: server_startup_fixes

2016-04-27 17:20:25 ERROR:

2016-04-27 17:20:25 ERROR: You need database Version: 21

2016-04-27 17:20:25 ERROR: Structure: 3

2016-04-27 17:20:25 ERROR: Content: 8

2016-04-27 17:20:25 ERROR: Description: dbdocs updates

2016-04-27 17:20:25 ERROR:

2016-04-27 17:20:25 ERROR:You are missing content updates or you have content updates beyond the expected core version.

2016-04-27 17:20:25 ERROR:It is recommended to run ALL database updates up to the required core version.

2016-04-27 17:20:25 ERROR:These updates are included in the database/World/Updates folder.

2016-04-27 17:20:25 Character Database total connections: 2

2016-04-27 17:20:26 MySQL client library: 5.7.12

2016-04-27 17:20:26 MySQL server ver: 5.5.48

2016-04-27 17:20:27 MySQL client library: 5.7.12

2016-04-27 17:20:27 MySQL server ver: 5.5.48

2016-04-27 17:20:27 ERROR:The table `db_version` indicates that your [Character] database does not match the expected structure!

2016-04-27 17:20:27 ERROR:

2016-04-27 17:20:27 ERROR: [A] You have database Version: 21

2016-04-27 17:20:27 ERROR: Structure: 1

2016-04-27 17:20:27 ERROR: Content: 0

2016-04-27 17:20:27 ERROR: Description: revision_refactor

2016-04-27 17:20:27 ERROR:

2016-04-27 17:20:27 ERROR: You need database Version: 21

2016-04-27 17:20:27 ERROR: Structure: 2

2016-04-27 17:20:27 ERROR: Content: 1

2016-04-27 17:20:27 ERROR: Description: match_client_limits

2016-04-27 17:20:27 ERROR:

2016-04-27 17:20:27 ERROR:You must apply all updates after [A] to to use MaNGOS with this database.

2016-04-27 17:20:27 ERROR:These updates are included in the database/Character/Updates folder.

[antz]

Ok.... The world database is at an acceptable level to start the core.

The character Database requires some updates:

Rel21_2_1_match_client_limits.sql

from database/Character/Updates/Rel21 at develop21 * mangosone/database * GitHub

once we get that working, then we can look at the other issues.