database realmd.exe crash

talrain85 · June 14, 2015

Hi there,

I'm setting up a fresh Mangos Zero server.

I've compiled successfully using this documentation: https://www.getmangos.eu/frequently-asked-questions/9876-getting-amp-compiling-mangos-server.html

And loaded the realmloaddb.sql query from: https://github.com/mangos/Realm_DB/blob/master/Setup/realmdLoadDB.sql

But when I open realmd.exe, I get:

SQL: SELECT required_20140607_Realm_Resync FROM realmd_db_version LIMIT 1
query ERROR: Unknown column 'required_20140607_Realm_Resync' in 'field list'
The table `realm_db_version` in your [REALMD] database indicates that this database is out of date!

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

[b] You need: --> `20140607_Realm_Resync.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.
Please read the included [README] in sql/updates for instructions on updating.

However, my /database/realm folder is empty whereas my /world and /characters folders contain another folder called "updates" (I see no sql/updates folder in any of my of files).

How should I proceed? Is there a place to manually get realmd updates?

Also, if I've used the above documentation to compile (it says it's for release 19), am I to use Rel19 folder for world updates?

Thanks!

Olion · June 14, 2015

I think you should just change the realmd database version to the one required by the core, for instance, executing the following on your realmd database:

ALTER TABLE `realmd_db_version` CHANGE COLUMN `20150409_Playerbot_and_Warden` `20140607_Realm_Resync` bit(1) DEFAULT NULL;

The Rel20 core contains neither warden nor playerbot, so realmLoadDB.sql is wrong. For the additional functionality, you have to switch to "develop21" branch on the both repos. 20150409_Playerbot_and_Warden.sql is the first update in Rel21 folder, if the branch is active.

The manual you referred to is outdated: 03-07-2014 vs Mar 22, 2015 for release of the Rel20. A better instructions are present here, though I cannot say, do they correspond to the current state of the repositories.

talrain85 · June 15, 2015

Thanks Olion!

Realmd is running. If anyone in the future finds this useful the names actually take a 'required_' prefix:

ALTER TABLE `realmd_db_version` CHANGE COLUMN `required_20150409_Playerbot_and_Warden` `required_20140607_Realm_Resync` bit(1) DEFAULT NULL;

When running mangos.exe, I was prompted to update the world database from 20007_18 to 20007_01. This confused me as it seemed to be chronologically backwards. Should I start with 20007_17 and work back down to 20007_01? Sorry for the stickler question, but I don't want to mess up my world database by doing it in reverse.

Thank you

talrain85 · June 16, 2015

Disregard. I changed the version again and got it working. Thanks!

Olion · June 16, 2015

I changed the version again and got it working.

Good

All these problems are due to a too smart system enforcing the syncronisation of the core and DB. It is under modifications now to become less smart and less stupid at the same time

DB updates fall into two categories:

changing the table structure - absolutely necessarily for the core to start. These will fail on a reapplication try, either silently or not.
changing the data, i.e. concrete fixes, - which may be missing. These are (well, should be...) written as reapplicable.

You barely can break the DB applying the updates. However, they better be not applied in the reverse order.

BTW the required DB version strings are written in this core file.

Sign In

database realmd.exe crash

Question

talrain85

Link to comment

Share on other sites

4 answers to this question

Recommended Posts

Olion

Link to comment

Share on other sites

talrain85

Link to comment

Share on other sites

talrain85

Link to comment

Share on other sites

Olion

Link to comment

Share on other sites

Archived

Recently Browsing 0 members

Contact Us

Repositories

Support

Wiki

Browse

Activity

My Activity Streams

Important Information