MangosOne can't find sql files in updates folder that i needed

[jesst3r]

Using the latest revision of MangosOne, from the git.

And here is i'm encountered a problem...that there is no _certain_ sql files in git repository, described in the console exception.

Here is example of realmd output:

The table `realmd_db_version` in your [REALMD] database indicates that this data
base is out of date!

 [A] You have: --> `10008_01_realmd_realmd_db_version.sql`

 [b] You need: --> `z2426_01_realmd_relations.sql`

You must apply all updates after [A] to [b] to use mangos with this database.
These updates are included in the sql/updates folder.

There are NO sql file with a name like this one "z2426_01_realmd_relations.sql", (synced from the git repo: https://github.com/mangosone/server/tree/master/sql )

Second example:

Output from mangosd

 [A] You have: --> `11785_01_mangos_instance_encounters.sql`

 [b] You need: --> `s2054_mangos_command.sql`

There is no sql file with name "11785_01_mangos_instance_encounters.sql".

So i even cannot a build a chain for sql files, because i don't even know from where to start...

Where can i get those files, and (maybe) another ones, that possibly missed?

Beforehand thank you.

[Hikari]

Seems like you installed the database from a different source.

If you install the realmd database by using the realmd.sql file from the MaNGOS One server repository, then it is up to date and don't require any updates from the update folder.

Similar with the world (mangosd) database.

If you install the world (mangosd) database from the MaNGOS One database repository it is almost up to date. The only update missing is s2054_mangos_command.sql, which you'll find in your server/sql/updates directory.

[jesst3r]

Seems like you installed the database from a different source.

If you install the realmd database by using the realmd.sql file from the MaNGOS One server repository, then it is up to date and don't require any updates from the update folder.

Similar with the world (mangosd) database.

If you install the world (mangosd) database from the MaNGOS One database repository it is almost up to date. The only update missing is s2054_mangos_command.sql, which you'll find in your server/sql/updates directory.

Thank you, for your help!

Well, regarding mangosd error...

Found, that error appears when after i'm loading udb database right after querying initial mangos.sql script.

[A] You have: --> `11785_01_mangos_instance_encounters.sql`

You need: --> `s2054_mangos_command.sql`

Which database (blizzlike) is better to use with latest revision of mango

[Hikari]

Well, UDB is certainly more blizzlike, because it is further developed and has more fixes in it. But if I remember correctly UDB has stopped its support for mangos and probably won't work properly.

Sure, you can persuade the mangos core to start with and using UDB. But this may cause unexpected errors.

[jesst3r]

Well, UDB is certainly more blizzlike, because it is further developed and has more fixes in it. But if I remember correctly UDB has stopped its support for mangos and probably won't work properly.

Sure, you can persuade the mangos core to start with and using UDB. But this may cause unexpected errors.

Hmm..okie. Sooo... which database should I use then?

[antz]

UDB database for MangosOne is much older than our current database.

Looking at the issue you are facing...

If you load the blank database from https://github.com/mangosone/server you will end up with version "s2054_mangos_command".

If you load the database from https://github.com/mangosone/database you will end up with version "s2034_12522_01_mangos_db_script_string"

Then applying the update sql s2054_mangos_command.sql from https://github.com/mangosone/server/sql/updates.

you should end up with version "s2054_mangos_command.sql".

This should be correct to start up the server

I have no idea how you ended up with 11785_01_mangos_instance_encounters as that revision is from MangosTwo and from over two years ago.

[jesst3r]

UDB database for MangosOne is much older than our current database.

Looking at the issue you are facing...

If you load the blank database from https://github.com/mangosone/server you will end up with version "s2054_mangos_command".

If you load the database from https://github.com/mangosone/database you will end up with version "s2034_12522_01_mangos_db_script_string"

Then applying the update sql s2054_mangos_command.sql from https://github.com/mangosone/server/sql/updates.

you should end up with version "s2054_mangos_command.sql".

This should be correct to start up the server

I have no idea how you ended up with 11785_01_mangos_instance_encounters as that revision is from MangosTwo and from over two years ago.

thank you, for your help!

[Unkle Nuke]

Many people still make the mistake of trying to use UDB as the world database for MaNGOS. After all, it was the official database provider for our project for several years.

Perhaps we need to add a notation to our site and wiki:

UDB is now part of another project and no longer compatible with MaNGOS!

Please be sure to use the database provided by our developers, included with the source for each of our servers!

We also need a similar note for ScriptDev2.