database how to use same realmd database for zero and one???

[kris914g]

hey im trying to use same realmd database but then i try to use the realmd databse from mangosone to zero i got this:

2014-09-07 15:56:52 MaNGOS Zero/0.19.0 (* * Revision 2518 - *) for Win32 (little-endian) [realm-daemon]

2014-09-07 15:56:52 <Ctrl-C> to stop.

2014-09-07 15:56:52 Using configuration file realmd.conf.

2014-09-07 15:56:52 Login Database total connections: 2

2014-09-07 15:56:52 MySQL client library: 5.5.37

2014-09-07 15:56:52 MySQL server ver: 5.5.39

2014-09-07 15:56:52 MySQL client library: 5.5.37

2014-09-07 15:56:52 MySQL server ver: 5.5.39

2014-09-07 15:56:52 ERROR:SQL: SELECT required_20140607_Realm_Resync FROM realmd_db_version LIMIT 1

2014-09-07 15:56:52 ERROR:query ERROR: Unknown column 'required_20140607_Realm_Resync' in 'field list'

2014-09-07 15:56:52 ERROR:The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

2014-09-07 15:56:52 ERROR:

2014-09-07 15:56:52 ERROR: [A] You have: --> `z2426_01_realmd_relations.sql`

2014-09-07 15:56:52 ERROR:

2014-09-07 15:56:52 ERROR: You need: --> `20140607_Realm_Resync.sql`

2014-09-07 15:56:52 ERROR:

2014-09-07 15:56:52 ERROR:You must apply all updates after [A] to to use mangos with this database.

2014-09-07 15:56:52 ERROR:These updates are included in the sql/updates folder.

2014-09-07 15:56:52 ERROR:Please read the included [README] in sql/updates for instructions on updating.

and then i try to do it conversely it says :

2014-09-07 16:00:48 MaNGOS One/0.18 (* * Revision 2057 - *) for Win32 (little-endian) [realm-daemon]

2014-09-07 16:00:48 <Ctrl-C> to stop.

2014-09-07 16:00:48 Using configuration file realmd.conf.

2014-09-07 16:00:48 Login Database total connections: 2

2014-09-07 16:00:48 MySQL client library: 5.1.49

2014-09-07 16:00:48 MySQL server ver: 5.5.39

2014-09-07 16:00:48 MySQL client library: 5.1.49

2014-09-07 16:00:48 MySQL server ver: 5.5.39

2014-09-07 16:00:48 ERROR:SQL: SELECT required_z2426_01_realmd_relations FROM realmd_db_version LIMIT 1

2014-09-07 16:00:48 ERROR:query ERROR: Unknown column 'required_z2426_01_realmd_relations' in 'field list'

2014-09-07 16:00:48 ERROR:The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

2014-09-07 16:00:48 ERROR:

2014-09-07 16:00:48 ERROR: [A] You have: --> `20140607_Realm_Resync.sql`

2014-09-07 16:00:48 ERROR:

2014-09-07 16:00:48 ERROR: You need: --> `z2426_01_realmd_relations.sql`

2014-09-07 16:00:48 ERROR:

2014-09-07 16:00:48 ERROR:You must apply all updates after [A] to to use mangos with this database.

2014-09-07 16:00:48 ERROR:These updates are included in the sql/updates folder.

2014-09-07 16:00:48 ERROR:Please read the included [README] in sql/updates for instructions on updating.

what can i do?

[Talendrys]

Not sure you can do this. You can share a realmd process between several instances of Zero but not accross Mangos versions.

[madmax]

Not sure you can do this. You can share a realmd process between several instances of Zero but not accross Mangos versions.

You can.

[MENTION=2745]kris914g[/MENTION]

If you have the realmd database updated fully and running with zero, you may need to add an additional colum to the version table in order to fool the other cores to work with it, we are in the process of syncing them all.

As for updates, Zero is the most up-to-date - database updates are always in the server repo https://github.com/mangoszero/server/tree/master/sql/updates

If you are using the Rel20 (most up-to-date branch) of zero then those updates are of course under that branch https://github.com/mangoszero/server/tree/Rel20/sql/updates

[kris914g]

Madmax.

Thats sounds great thanks Madmax, i'm not a expert to update the databases from Mangos ;( and i i have no idea how to update the databases, because the system alwase have a new method to update the database, so maby you could help all the mangos users so why not make a full updated sampel of the realmd database so its possible to use the same database, for all the mangos versions

[madmax]

if you like, i dont mind coming on teamviewer and doing this for you? you will need skype though. if you want todo this private message me your skype id

[kris914g]

thanks i would be happy if you could helmp me and i have send my skype id in pm

[kris914g]

Thanks for the help!!! Madmax thats a big help