Confused about the updates

[Auntie Mangos]

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.

[select]

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

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

[NickoNiklas]

Read the error message "You must apply all updates after [A] to [B]...",

not "Only apply ".

This means you start with the first sql update that comes after [A],

that's for the mangos DB.

[EARTHWALKER]

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.

[Ipreferpapaya]

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?

[EARTHWALKER]

If you are getting no errors applying the sql's, then yes, all is well.

Also, that is a YES, to using the mangos sql updates. They add a bit of both to coincide with any changes to the core.

[Ipreferpapaya]

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?

[NickoNiklas]

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.

[Ipreferpapaya]

Thank you very much! This all makes a lot more sense now.

So for example, a character made on a UDB database would get messed up if you suddenly switched to the Silvermoon database.

[Schmoozerd]

actually no.

The DB-providers like UDB, YTDB, PSDB provide content for the world-database, this has no impact on the character DB

[Ipreferpapaya]

But don't characters have items, which depend on the world db?

[Patman128]

But don't characters have items, which depend on the world db?

If they reuse some old item IDs, then maybe.