mangos help

[treetree]

I have made a yad mangos and i get this error message when

it runs with ytdb or udb.

2010-10-11 21:14:06 Loading Creature templates...

2010-10-11 21:14:07 ERROR:Error in creature_template table, probably sql file format was updated (there should be 88 fields in sql).

2010-10-11 21:00:34 MaNGOS/0.17.0-DEV (* * Revision 10553 - *) for Win32 (little-endian) [realm-daemon]

2010-10-11 21:00:34 <Ctrl-C> to stop.

idk why it says that I updated all the things

ty for your help

treetree

[TheLuda]

That is exactly what you are supposed to do. Obviously your database is of lower version than your mangos installation.

Thus... open your database in your favourite tool, like phpMyAdmin, etc. Check the db_version table. If you prefer the command line, you can issue this command in the MySQL console:

DESCRIBE db_version;

The last field listed (a bit field) states at which revision your database is. If this field e.g. is named required_10503_04_mangos_gameobject_respawn, check through the SQL update folder in the mangos sources.

The next revision listed there is 10537_01_mangos_command.sql. Run this file on the database, and then continue with the next revision number.

Updates usually have are named like revision_database_typeofchange.sql, where database either is mangos (aka world database), character (for your character data), or realmd for your realm authentication server.

That should be it.

[treetree]

ty,mangos for your promt reply

I think the problem was that my mangos was 10553 3.3.5 and I was

extracting 3.3.5a dbc and maps so it was not happy with the db

because it was expecting a 3.3.5 db structure.

idk because I need to change my wow to 3.3.5 to test this.

how can I find out the wow version needed from the mangos

core release number.

tree

[Auntie Mangos]

See src/game/SharedDefines.h. Search the file for a line like this one

#define EXPECTED_MANGOSD_CLIENT_BUILD        {12340, 0}

[FeRkEl]

ty,mangos for your promt reply

I think the problem was that my mangos was 10553 3.3.5 and I was

extracting 3.3.5a dbc and maps so it was not happy with the db

because it was expecting a 3.3.5 db structure.

idk because I need to change my wow to 3.3.5 to test this.

how can I find out the wow version needed from the mangos

core release number.

tree

3.3.5a is right client version,

it seems more that you need to patch your MySQL Database

tha table db_version tells you what was the latest SQL patch applied...

MfG

[treetree]

See src/game/SharedDefines.h. Search the file for a line like this one

#define EXPECTED_MANGOSD_CLIENT_BUILD        {12340, 0}

// will only support WoW, WoW:TBC and WoW:WotLK 3.3.5a client build 12340...

oh,ok that solved that problem ty

idk i must be doing something wrong

I downloaded the latest mangos and sd2 and it worked np

,but when i use this other core ^ ^ it says

the creature template is wrong structure must have 88 fields error.

I have no idea why it is doing that

something is the wrong version

I must be extracting the wrong dbc and maps or something

with the wrong extractor or it wants a different db.

idk blabla from tree

nvm I found the problem the core is weird ty for you help

tree