[Solved] [Zero] > [One] Characters database update issue

[Keidodjin]

Hello,

Im trying to update my selfcompiled MangosZero Server to MangosOne while keeping the Characters and realmd Databases.

I have already redone the gameworld and scriptdev2 databases, but i have problems with the manual update of the Characters databases:

2013-08-01 16:21:10 MaNGOS One/0.12.2 (* * Revision 2040 - *) for Win32 (little-endian) [world-daemon]

2013-08-01 16:21:10 <Ctrl-C> to stop.

2013-08-01 16:21:10

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

2013-08-01 16:21:10 Using configuration file mangosd.conf.

2013-08-01 16:21:10 World Database total connections: 2

2013-08-01 16:21:10 MySQL client library: 5.1.49

2013-08-01 16:21:10 MySQL server ver: 5.6.13

2013-08-01 16:21:10 MySQL client library: 5.1.49

2013-08-01 16:21:10 MySQL server ver: 5.6.13

2013-08-01 16:21:10 Character Database total connections: 2

2013-08-01 16:21:10 MySQL client library: 5.1.49

2013-08-01 16:21:10 MySQL server ver: 5.6.13

2013-08-01 16:21:10 MySQL client library: 5.1.49

2013-08-01 16:21:10 MySQL server ver: 5.6.13

2013-08-01 16:21:10 ERROR:SQL: SELECT required_s1350_11716_09_characters_mail FROM character_db_version LIMIT 1

2013-08-01 16:21:10 ERROR:query ERROR: Unknown column 'required_s1350_11716_09_characters_mail' in 'field list'

2013-08-01 16:21:10 ERROR:The table `character_db_version` in your [CHARACTER] database indicates that this database is out of date!

2013-08-01 16:21:10 ERROR:

2013-08-01 16:21:10 ERROR: [A] You have: --> `z1794_s1350_11716_09_characters_auction.sql`

2013-08-01 16:21:10 ERROR:

2013-08-01 16:21:10 ERROR: [b ] You need: --> `s1350_11716_09_characters_mail.sql`

2013-08-01 16:21:10 ERROR:

2013-08-01 16:21:10 ERROR:You must apply all updates after [A] to [b ] to use mangos with this database.

2013-08-01 16:21:10 ERROR:These updates are included in the sql/updates folder.

2013-08-01 16:21:10 ERROR:Please read the included [README] in sql/updates for instructions on updating.

What is the first Update after "z1794_s1350_11716_09_characters_auction.sql" (since this is the lates version of MangosZero)?

[Keidodjin]

Promlem solved, I had to rename the Column of the character_db_version table within the characters database from "required_z1794_s1350_11716_09_characters_auction.sql" to "required_z1597_s1099_02_characters_pet_aura". So i was able to use the "characters_convert_z1597_to_s1099.sql" which lays inside of my old "MangosZero\mangos\sql\tools" folder. After that i was able to just further use the updates of my new Server "MangosOne\mangos\sql\updates"

I hope this was somewhat understandable....

[lfxgroove]

Glad that you found the solution! I was uncertain on whether one could upgrade from zero to one or not. Adding a link to this thread in the FAQ, thanks!