database [World] database does not match expected structure!

[bansidhe]

Hey all!

I'm new, and I just started building a MaNGOS Zero rel21 server for myself.

Some info first:

Win Server 2008 R2

MySQL 5.6.28 64bit

Compiled with Visual Studio 14 2015 Win64

I used InstallDatabases.bat, but when I run mangosd.exe I get the following text:

[color="#FF0000"]The table `db_version` indicates that your [World] database does not match the e
xpected structure!

 [A] You have database Version: 21
                     Structure: 10
                       Content: 1
                   Description: warden_table_redone

 [b] You need database Version: 21
                     Structure: 11
                       Content: 7
                   Description: Fix BG buffs

You must apply all updates after [A] to [b] to use MaNGOS with this database.
These updates are included in the database/World/Updates folder.[/color]

I guess the batch file didn't give me the latest version?

1: I don't know if I do or don't have the needed files yet. How can I tell? Should they be included when I cloned the database folder with Git?

2: Once I do have the files I need, I might need help importing them. I mean I can run a script and fill out a few questions, but I'm still learning about the whole SQL database thing.

Any help would be greatly appreciated!

[krill]

Hey all!

I'm new, and I just started building a MaNGOS Zero rel21 server for myself.

Some info first:

Win Server 2008 R2

MySQL 5.6.28 64bit

Compiled with Visual Studio 14 2015 Win64

I used InstallDatabases.bat, but when I run mangosd.exe I get the following text:

[color="#FF0000"]The table `db_version` indicates that your [World] database does not match the e
xpected structure!

 [A] You have database Version: 21
                     Structure: 10
                       Content: 1
                   Description: warden_table_redone

 [b] You need database Version: 21
                     Structure: 11
                       Content: 7
                   Description: Fix BG buffs

You must apply all updates after [A] to [b] to use MaNGOS with this database.
These updates are included in the database/World/Updates folder.[/color]

I guess the batch file didn't give me the latest version?

1: I don't know if I do or don't have the needed files yet. How can I tell? Should they be included when I cloned the database folder with Git?

2: Once I do have the files I need, I might need help importing them. I mean I can run a script and fill out a few questions, but I'm still learning about the whole SQL database thing.

Any help would be greatly appreciated!

There is a folder with the updates that you NEED to apply

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

goes the same for Characters and Auth/Realm

[bansidhe]

Thank you for your answer krill!

I'm afraid I need some more help though.. I've never dealt with SQL or compiling code before. I was kinda proud I managed to solve all the little problems on my own up till now

I found that updates folder now. Mine has updates up to 21_11_10. Updates _11 and _12 were missing, but I downloaded them now. But what do I do with the sql files?

This guide getMaNGOS WIKI doesn't explain the how,

and Uh oh... - getMaNGOS WIKI no longer exists or hasn't been made yet?

Also my version is currently 21_11_1, it says I need 21_11_7, do I understand it correctly that I'm meant to do ALL updates (up to 21_11_12 currently) and then recompile the core (like the first link suggests)?

If so, I'm guessing I

- delete the old build folder

- Run MaNGOS_EasyBuild.exe again & follow compilation steps like before

Then, can I skip the config file adjustments and just use the old ones? Or are they changed between build versions?

[edit]

Does recompiling also mean I need to re-clone the server folder from github?

[/edit]

[antz]

You would only normally need to recompile the core if the database version was higher than the expected version !

- In your case, it's the other way around

You have: Rel21_10_1 installed

but you need to apply all the updates from Rel21_10_2 to Rel21_11_7 in numerical order

You will need to load up some sort of MySQL manager app - on windows I use SqlYog, then load up each of the updates and execute them against the mangos world database.

[bansidhe]

Ah right, I did install SQLyog as per instructions in the guide.

I load up the 21_10_02 file, select world on the left (the dropdown at the top of the screen also changes to world)

When I hit F9 to execute I get the following:

1 queries executed, 1 success, 0 errors, 1 warnings

Query: DROP PROCEDURE IF EXISTS `update_mangos`

0 row(s) affected, 1 warning(s)

Execution Time : 0 sec
Transfer Time  : 0 sec
Total Time     : 0 sec

Note Code : 1305
PROCEDURE world.update_mangos does not exist

I tried a few times and also saw an error 1304 I think.

I tried to run mangosd.exe to see if the indicated database version went up to 21_10_02, but it hasn't.

Am I doing something wrong? Forgetting about something? Or did I somehow manage to corrupt my database already so the code won't run?

[antz]

Have you tried CTRL+F9 in SqlYog

[bansidhe]

Have you tried CTRL+F9 in SqlYog

I had not.. Please understand this is my very first time dealing with SQL. I have a lot to learn still!

I'm guessing an SQL file is not considered a single query but a collection of them..

Anyways, when I hit CTRL_F9, I get the following:

* UPDATE FAILED *   Unable to locate DB Version Information

I checked the different databases, character, mangos and realmd all seem to have a "db_version" listed in the Tables, World does not.

I tried finding a solution on the forums but didn't find anything yet. (Someone had the same message, but seemed to have a different problem. I'm not sure)

(There are a few I don't recognise and don't remember creating, like: information_schema, mysql, performance_schema, sakila and test)

[antz]

I have PM'd you so that we can attempt to resolve this quicker