Mangosd crashes at start

[tenor123]

Hello,

I just compiled my first mangoszero server. Ok, so first i start realmd and it starts like it should. But then i click on mangosd and it coleses... Can any one help me to fix this?

Error log:

2015-07-19 18:32:02 Using configuration file mangosd.conf.
2015-07-19 18:32:02 World Database total connections: 2
2015-07-19 18:32:02 MySQL client library: 5.5.37
2015-07-19 18:32:02 MySQL server ver: 5.6.25-log 
2015-07-19 18:32:02 MySQL client library: 5.5.37
2015-07-19 18:32:02 MySQL server ver: 5.6.25-log 
2015-07-19 18:32:03 ERROR:SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1
2015-07-19 18:32:03 ERROR:query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list'
2015-07-19 18:32:03 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2015-07-19 18:32:03 ERROR:
2015-07-19 18:32:03 ERROR:  [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`
2015-07-19 18:32:03 ERROR:
2015-07-19 18:32:03 ERROR:  [b] You need: --> `20007_01_Rel20_Release_Prep.sql`
2015-07-19 18:32:03 ERROR:
2015-07-19 18:32:03 ERROR:You must apply all updates after [A] to [b] to use mangos with this database.
2015-07-19 18:32:03 ERROR:These updates are included in the sql/updates folder.
2015-07-19 18:32:03 ERROR:Please read the included [README] in sql/updates for instructions on updating.

Sorry if my problem is dumb, but i am new to these things and i just wanna make server for me and my friends...

Thanks

[trimken]

Update your world database from 20007_18_Deadmines_Mr_Smite_Corrections.sql to 20007_01_Rel20_Release_prep.sql - https://github.com/mangoszero/database/tree/release20/World/Updates/Rel20

[tenor123]

Hi,

I tired to apply all updates as you said, but when it comes to 20007_01_Rel20_Release_prep.sql, HeidiSQL gives me error:

/* SQL Error (1054): Unknown column 'required_20004_01_Fix_UnitClass_Errors_Introduced_In_Rel19' in 'db_version' */

/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0.000 sec. */

I tried to add the update that's mentioned in error message, but still nothing happends... What should i do?

[Olion]

You might find the appropriate discussion here, as well as the two solution variants.