[Mangos Zero] [Solved] SQL error when I try to update the world database

[johngear]

Hi,

I'm trying to start mangosd.exe after running realmd.exe and I get this error:

2016-04-26 16:52:13 20007 [world-daemon]

2016-04-26 16:52:13 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: getMaNGOS | The home of MaNGOS - Home / // -_) '_/ _ \

Wiki: MaNGOS Wiki * GitHub /___\___|_| \___/

2016-04-26 16:52:13 Using configuration file mangosd.conf.

2016-04-26 16:52:13 World Database total connections: 2

2016-04-26 16:52:13 MySQL client library: 5.5.37

2016-04-26 16:52:13 MySQL server ver: 5.5.49-log

2016-04-26 16:52:13 MySQL client library: 5.5.37

2016-04-26 16:52:13 MySQL server ver: 5.5.49-log

2016-04-26 16:52:13 ERROR:SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1

2016-04-26 16:52:13 ERROR:query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list'

2016-04-26 16:52:13 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!

2016-04-26 16:52:13 ERROR:

2016-04-26 16:52:13 ERROR: [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql`

2016-04-26 16:52:13 ERROR:

2016-04-26 16:52:13 ERROR: You need: --> `20007_01_Rel20_Release_Prep.sql`

2016-04-26 16:52:13 ERROR:

2016-04-26 16:52:13 ERROR:You must apply all updates after [A] to to use mangos with this database.

2016-04-26 16:52:13 ERROR:These updates are included in the sql/updates folder.

2016-04-26 16:52:13 ERROR:Please read the included [README] in sql/updates for instructions on updating.

So I decided to try and update the database through the given instruction.

20007_18_Deadmines_Mr_Smite_Corrections.sql imports fine but when I try to execute 20007_01_Rel20_Release_Prep.sql I get this mysql error:

Query:

ALTER TABLE db_version CHANGE COLUMN required_20004_01_Fix_UnitClass_Errors_Introduced_In_Rel19 required_20007_01_Rel20_Release_Prep BIT

Error occured at:2016-04-26 16:57:31

Line no.:1

Error Code: 1054 - Unknown column 'required_20004_01_Fix_UnitClass_Errors_Introduced_In_Rel19' in 'db_version'

I'm running mysql 5.5.49 community edition server on Windows 10 64bit

Also is there some place I can find updated documentation about the installation process?

[antz]

may I suggest you clone the develop21 branch of mangoszero server and database as it's had over a years worth of updates added to it.

[johngear]

may I suggest you clone the develop21 branch of mangoszero server and database as it's had over a years worth of updates added to it.

Haha did not see that there was a R21 version.

Anyway runs like a dream now thanks for the help