[Mangos One] Database version errors

[Nameback]

Hello all, I'm trying to setup my own server and while I've overcome a lot of issues via trial and error I seem to have a issue with the version of my database I've complied. I'm not sure how because I just downloaded the source from Git today. Here's what I see in my server.log file.

2016-04-18 01:01:01 21000 [world-daemon]

2016-04-18 01:01:01 <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-18 01:01:01 Using configuration file mangosd.conf.

2016-04-18 01:01:01 World Database total connections: 2

2016-04-18 01:01:01 MySQL client library: 5.7.12

2016-04-18 01:01:01 MySQL server ver: 5.5.48

2016-04-18 01:01:01 MySQL client library: 5.7.12

2016-04-18 01:01:01 MySQL server ver: 5.5.48

2016-04-18 01:01:01 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2016-04-18 01:01:01 ERROR:query ERROR: Unknown column 'structure' in 'field list'

2016-04-18 01:01:01 ERROR:The table `db_version` in your [World] database is missing or corrupt.

2016-04-18 01:01:01 ERROR:

2016-04-18 01:01:01 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence!

2016-04-18 01:01:01 ERROR:

2016-04-18 01:01:01 ERROR: You need database Version: 21

2016-04-18 01:01:01 ERROR: Structure: 3

2016-04-18 01:01:01 ERROR: Content: 8

2016-04-18 01:01:01 ERROR: Description: dbdocs updates

2016-04-18 01:01:01 ERROR:

2016-04-18 01:01:01 ERROR:Please verify your database location or your database integrity.

Any help would be great! Thanks

[krill]

Can you drop and reload your world DB then update it and report back?

[Nameback]

Can you drop and reload your world DB then update it and report back?

Drop and reload? I'm going to try and take that step by step. I have no prior DB experience so MySQL has been a journey.

1. Drop, I see the option in SQLog. I assume this just means delete? Done.

2. Reload? Do you mean the database setup tool in the Database folder? The command prompt one? I re-created an empty one and had the tool set it up again.

3. Update? Maybe this is the source of my issues, is there an update step? All the tutorials I've seen just say "You're done!" after you run the setup tool I mentioned in step two. How do I update?

EDIT:

I found a quote on this thread https://www.getmangos.eu/general-help-amp-support/10680-develop21-install-issues-bash-install-script-fun.html?highlight=update

Hello!

The present world DB dump is of 21.10.1 version (due to the db_version.sql content found in World/Setup/FullDB). It means that after the full world DB installation, you need to apply only later (newer than 21.10.1) updates from World/Updates/Rel21/ folder. You might as well ignore them for now, since they have structure=10 and the core will start without them.

My Release\database\world\updates only has folders for Rel18,19,20. How to I find the folder for 21 and update accordingly?

EDIT2:

I downloaded the release files in the downloads category here and I found a folder for Rel21. This may sound like a silly question but how do I actually integrate these .sql changes into the database?

[gabrielesani]

You can't just download Rel21 folder and integrate it. If you didn't found the folder probably you cloned the wrong branch from git. Try to start over again, but this time add "-b develop21" at the end of the clone command for both server and database.