hello small problem

[yashua]

kaduh02:/home/mangos/bin# ./mangos-worldd

MaNGOS/0.16.0 (* * Revision 9847 - *) for Linux_x64 (little-endian) [world-daemon]

<Ctrl-C> to stop.

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

Using configuration file /home/mangos/etc/mangosd.conf.

OpenSSL 1.0.0 29 Mar 2010 (Library: OpenSSL 0.9.8g 19 Oct 2007)

WARNING: Outdated version of OpenSSL lib. Logins to server may not work!

WARNING: Minimal required version [OpenSSL 0.9.8k]

Using ACE: 5.6.6

World Database: -------------;3306;--------;-----------;mangos

Connected to MySQL database at ------------

MySQL client library: 5.0.51a

MySQL server ver: 5.0.21

AUTOCOMMIT SUCCESSFULLY SET TO 1

SQL: SELECT required_9826_01_mangos_spell_script_target FROM db_version LIMIT 1

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

[1 ms] SQL: SELECT * FROM db_version LIMIT 1

Table `db_version` have field `required_9539_01_mangos_spell_bonus_data` but expected `required_9826_01_mangos_spell_script_target`! Not all sql updates applied?

[0 ms] SQL: SET NAMES `utf8`

[0 ms] SQL: SET CHARACTER SET `utf8`

sorry guys if im being a bother im just trying to figure it out looks like theres a few things wrong...

[VladimirMangos]

Error messages output in kst time for ppl reading: Not all sql updates applied?

[yashua]

do i need to run every update 1 by 1? now i feel stupid is that it i just need to run those updates that came in the sql there are like 1000 little sql files in this update folder....

[Schmoozerd]

SQL: SELECT required_9826_01_mangos_spell_script_target FROM db_version LIMIT 1

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

[1 ms] SQL: SELECT * FROM db_version LIMIT 1

Table `db_version` have field `required_9539_01_mangos_spell_bonus_data` but expected `required_9826_01_mangos_spell_script_target`! Not all sql updates applied?

you are at DB revision 9539_01 - you need 9826_01

so either update a good part of the needed revisions by DB updates from your DB provider, or apply all mangos_ updates >= 9539_02 till 9826_01.

[yashua]

hey thank you i just updated my mangos world database it went threw perfectly but how do i check what version the character and the realm database is where would it tell me?

[Patman128]

In the FAQ.

[yashua]

ok I ran into a problem with the database my mangos database is fully up to date now but how do i tell what version my character and realm database is on????? i checked its version it just says it needs the latest version and thats not helpful.

[Patman128]

ok I ran into a problem with the database my mangos database is fully up to date now but how do i tell what version my character and realm database is on????? i checked its version it just says it needs the latest version and thats not helpful.

I just told you, it's in the FAQ.

If you are type 2, you may also need to apply updates to characters or realmd databases. Simply check the character_db_version and realmd_db_version in those databases respectively and apply any necessary updates.

[yashua]

I tryed that already but it didn't help i went to

character_db_version

it says Null

and required_9767_03_characters