Jump to content

Recommended Posts

Posted

It appears that I have been loosing not only hair by my entire mind. Been struggling for days trying to get a clean install of Mangos One on a brand new virtual server of Ubuntu 14.04. The compile goes well, and a very successful map extraction. My issue is all around the database import. The first issue it every single set of directions in the Wiki is slightly different and I have tried what appears to be every single one. Here is the issue. While starting to start the realm I get this:

SQL: SELECT required_20150409_Playerbot_and_Warden FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150409_Playerbot_and_Warden' in 'field list'

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

[A] You have: --> `20140607_Realm_Resync.sql`

You need: --> `20150409_Playerbot_and_Warden.sql`

You must apply all updates after [A] to 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.

At this point it is obvious that there are updates missing. After following multiple directions for batch import of both the full database and the updates here is my real question.

I get a lot of this type of error:

* UPDATE SKIPPED * required_19005_10_mangos_command

ERROR 1064 (42000) at line 41527: You have an error in your SQL syntax;

Right away it is noticeable that the missing update Rel19 update and I have pulled Rel20. The other appears to be a bugged update. Every attempt to move backwards to get the missing required update points more missing updates. What did I do wrong and what is the correct way to import that full world database?

Is it required to install the Rel18 & Rel19 updates if they get pulled?

A helpful member sent me a PM and my issue is resolved. All that was needed was this from Rel21:

20150409_Playerbot_and_Warden.sql

The rest is pretty much me not really understanding exactly what the messages mean.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use