Jump to content

Confused about the updates


Auntie Mangos

Recommended Posts

Hello everyone, i have a question thats probebly been asked over 500 million times, but i gotta ask anyway, i tried searching the forums but couldn't really find the answer to this question.

I know that some of you will be pissed at me and tell me to f***ing look better but i hope that the rest of you will be willing to help me.

I'm following this guide http://getmangos.eu/community/viewtopic.php?id=13121

And i've added the databases but im stuck on the update part.

Am i supposed to update the databases with the sql files found in.

http://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/Updates/0.12.0_additions/

Or am i supposed to use the sql files in Mangos/sql/updates

Most of you will probebly think that this is a retarded question, but remember that this is my first time doing this, and it's not always so easy to see the solution that is right in front of your nose.

Thank you for your help and your time.

Link to comment
Share on other sites

  • 40 years later...

I've now added the updates.

Which is

First

388_corepatch_characters_9311_to_9582

then

388_corepatch_mangos_9311_to_9582

then

388_updatepack_mangos

389_corepatch_characters_9583_to_9630

389_corepatch_mangos_9583_to_9630

etc

etc

etc

Now when i try to start the server, i get this error.

2010-09-05 17:02:07 Using configuration file mangosd.conf.

2010-09-05 17:02:07 World Database: 127.0.0.1;3306;root;xxxxxx;mangos

2010-09-05 17:02:07 MySQL client library: 5.1.49

2010-09-05 17:02:07 MySQL server ver: 5.1.50-community

2010-09-05 17:02:07 ERROR:SQL: SELECT required_10430_01_mangos_spell_chain FROM db_version LIMIT 1

2010-09-05 17:02:07 ERROR:query ERROR: Unknown column 'required_10430_01_mangos_spell_chain' in 'field list'

2010-09-05 17:02:07 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2010-09-05 17:02:07 ERROR:

2010-09-05 17:02:07 ERROR: [A] You have: --> `10257_01_mangos_command.sql`

2010-09-05 17:02:07 ERROR:

2010-09-05 17:02:07 ERROR: You need: --> `10430_01_mangos_spell_chain.sql`

2010-09-05 17:02:07 ERROR:

2010-09-05 17:02:07 ERROR:You must apply all updates after [A] to to use mangos with this database.

2010-09-05 17:02:07 ERROR:These updates are included in the sql/updates folder.

2010-09-05 17:02:07 ERROR:Please read the included [README] in sql/updates for instructions on updating.

And when i try to apply 10430_01_mangos_spell_chain.sql i get this error from SQLyog

Query : ALTER TABLE db_version CHANGE COLUMN required_10427_01_mangos_spell_proc_event required_10430_01_mangos_spell_chain bit

Error Code : 1054

Unknown column 'required_10427_01_mangos_spell_proc_event' in 'db_version'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

---------------------------------------------------

0 row(s) affected

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

---------------------------------------------------

o.O

Link to comment
Share on other sites

2010-09-05 17:02:07 ERROR: [A] You have: --> `10257_01_mangos_command.sql`

So from your mangos/sql/updates folder, you will need to add all the files, from:- 10263_01_mangos_pool_creature.sql and onwards until you reach 10430_01_mangos_spell_chain.sql

Yes it is confusing and long winded at first, but once you do that, I suggest you update at least once a week.

I do it once a week and it only takes about 30 minutes to re-grab, compile, compile sd2, then do the few updates.

Link to comment
Share on other sites

I'm actually a bit confused about this myself. For example, when I first installed my database, I got a similar error. "You must apply all updates after [A] to to use mangos with this database."

However, included with my database were several sql updates. I ran them in order, and after that everything seemed to work fine. I assume if I'm not getting errors, all's well? Or do I also need to run the sql updates in the mangos folder, not just the ones that came with the database?

I guess the overall question I'm asking is: what's the purpose of the mangos sql updates? Are those just to change the structure of the mangos database, or do they also add content to it?

Link to comment
Share on other sites

What kind of content does the default, basic mangos database contain?

I'm assuming it doesn't contain info like quests and mobs and spawns, because before I installed a third party database, I was running around in an empty world.

I'm assuming also the default mangos database contains spell/class info, because I often see updates to the core related to spells.

How is the "game" split up between the main database and the third party database? If I'm using a third party database, do I need to also apply the mangos sql updates?

Link to comment
Share on other sites

The sql update files that comes with mangos are empty structures for the database,

and contain no data.

What the third party databases does, is to add content to the game,

like mobs, scripted events (SD2) and so on.

The third party databases are not part of mangos,

and not always up to date with mangos,

since mangos gets updated almost on a daily basis, and that's way more frequently than what the content databases does.

That is one reason you need to apply the mangos updates if you have applied a content database,

since it's not always up to date with the core you're using.

Take it like this,

UDB latest update contains the structures and "content" for mangos rev. 10258,

and mangos is currently at rev. 10468.

There have been plenty of database updates between mangos rev. 10258 to 10468,

and since mangos is not sentient or anything, it's been hardcoded how the database structure is,

and how to retrieve data from it,

and if that database structure is not the way it's supposed to be (ex. at rev. 10258),

it can't get all the data from the database.

Hint, if you're using UDB, and applied all UDB updates to 10258,

and you've downloaded the latest mangos core,

you must always apply all the mangos sql updates to the mangos database,

starting from the first sql update next to 10258.

Howerver, if you've downloaded mangos rev. 10258,

you only need to apply the UDB full database and updates to your mangos database,

since the core supports that rev.

Link to comment
Share on other sites

Guest
This topic is now 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