Jump to content
  • 0

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


Keidodjin

Question

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)?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

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....

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use