[Mangos Zero] Need help with DB

[purownage]

Hi everyone, I keep getting error everytime I compile MaNGOS EVERYTIME ITS DB_VERSION so can you guys help me out with this :

2016-03-28 18:19:28 20007 [realm-daemon]

2016-03-28 18:19:28 <Ctrl-C> to stop.

2016-03-28 18:19:28 Using configuration file realmd.conf.

2016-03-28 18:19:29 Login Database total connections: 2

2016-03-28 18:19:32 MySQL client library: 5.5.40

2016-03-28 18:19:32 MySQL server ver: 5.6.29-log

2016-03-28 18:19:33 MySQL client library: 5.5.40

2016-03-28 18:19:33 MySQL server ver: 5.6.29-log

2016-03-28 18:19:33 ERROR:SQL: SELECT required_20140607_Realm_Resync FROM realmd_db_version LIMIT 1

2016-03-28 18:19:33 ERROR:query ERROR: Table 'realmd.realmd_db_version' doesn't exist

2016-03-28 18:19:33 ERROR:SQL: SELECT * FROM realmd_db_version LIMIT 1

2016-03-28 18:19:33 ERROR:query ERROR: Table 'realmd.realmd_db_version' doesn't exist

2016-03-28 18:19:33 ERROR:The table `realmd_db_version` in your [REALMD] database is missing or corrupt.

2016-03-28 18:19:33 ERROR:MaNGOS can not find the version info needed to check that the db is up to date.

2016-03-28 18:19:33 ERROR:

2016-03-28 18:19:33 ERROR:This revision of mangos requires a database updated to:

2016-03-28 18:19:33 ERROR:`20140607_Realm_Resync.sql`

2016-03-28 18:19:33 ERROR:

2016-03-28 18:19:33 ERROR:Reinstall your [REALMD] database with the included sql file in the sql folder.

I've try few thing and I keep having this error :

1 queries executed, 0 success, 1 errors, 0 warnings

Query: ALTER TABLE db_version CHANGE COLUMN required_z2426_01_realmd_relations required_20140607_Realm_Resync BIT

Error Code: 1054

Unknown column 'required_z2426_01_realmd_relations' in 'db_version'

Execution Time : 0 sec

Transfer Time : 0 sec

Total Time : 0.001 sec

[Olion]

In a way, you try to combine the Release20 core with Develop21 database. The table mentioned was renamed between 20th and 21th versions. Unfortunately I cannot pinpoint the cause with the presented info. Things are complicated by the submodule logic Mangos uses in the repos. However the DB repo looks correctly in the sense it points to a different commits of the Realm subrepo for different (20, 21) versions. For a start, ensure your core and DB repos to be at the same versions (branches) both, either release20 or develop21; this must include the submodule index.