Fork me on GitHub
Wrath of the Lich King Classic to WOTLK char database
Post: #1
I'm not sure how to do this, but I am trying to keep my characters from classic database and update to WOTLK. I keep getting errors and can't seem to find anything that can help me convert. I get the following error:




2016-06-27 00:04:17 SQL: SELECT required_12937_01_characters_pvpstats FROM character_db_version LIMIT 1
2016-06-27 00:04:17 query ERROR: Unknown column 'required_12937_01_characters_pvpstats' in 'field list'
2016-06-27 00:04:17 The table `character_db_version` in your [CHARACTER] database indicates that this database is out of date!
2016-06-27 00:04:17
2016-06-27 00:04:17 [A] You have: --> `z2682_01_characters_pvpstats.sql`
2016-06-27 00:04:17
2016-06-27 00:04:17 [B] You need: --> `12937_01_characters_pvpstats.sql`
2016-06-27 00:04:17
2016-06-27 00:04:17 You must apply all updates after [A] to [B] to use mangos with this database.
2016-06-27 00:04:17 These updates are included in the sql/updates folder.
2016-06-27 00:04:17 Please read the included [README] in sql/updates for instructions on updating.

Iread the README and the FAQ section that describes this errorbut I still seem to be stuck. Any ideas? Confused
Reply
Post: #2
This is a huge gap to update through considering you are skipping over two other expansions. Although I've never done this myself, I believe you would need to apply every 'characters' sql update script in order from the TBC, WOTLK, and CATA cores to be up to date.

A word of warning: the CATA core is not nearly as complete as the other versions, so if you have an active player bas, you are going to be putting them into a far less stable version than what they are currently used to.

If you don't have a player base then there is no need to go through this update process as you can just wipe your databases and start with clean installs using the installation instructions and the CATA core.
Reply
Post: #3
(06-27-2016, 01:06 PM)shnibble Wrote: This is a huge gap to update through considering you are skipping over two other expansions. Although I've never done this myself, I believe you would need to apply every 'characters' sql update script in order from the TBC, WOTLK, and CATA cores to be up to date.

A word of warning: the CATA core is not nearly as complete as the other versions, so if you have an active player bas, you are going to be putting them into a far less stable version than what they are currently used to.

If you don't have a player base then there is no need to go through this update process as you can just wipe your databases and start with clean installs using the installation instructions and the CATA core.

OK i'll give it a try. I'll go download the TBC core.
Reply
Post: #4
I'm a little stuck converting some things. Is there a guide to converting the character database? I was running the mangos-classic\sql\tools characters_convert_z1794_to_s1350B. It finished and then I ran TBC convert as well. Now when I run mangos I get:

2016-06-27 12:43:23 SQL: SELECT required_12937_01_characters_pvpstats FROM character_db_version LIMIT 1
2016-06-27 12:43:23 query ERROR: Unknown column 'required_12937_01_characters_pvpstats' in 'field list'
2016-06-27 12:43:23 The table `character_db_version` in your [CHARACTER] database indicates that this database is out of date!
2016-06-27 12:43:23
2016-06-27 12:43:23 [A] You have: --> `11785_02_characters_instance.sql`
2016-06-27 12:43:23
2016-06-27 12:43:23 [B] You need: --> `12937_01_characters_pvpstats.sql`
2016-06-27 12:43:23
2016-06-27 12:43:23 You must apply all updates after [A] to [B] to use mangos with this database.
2016-06-27 12:43:23 These updates are included in the sql/updates folder.
2016-06-27 12:43:23 Please read the included [README] in sql/updates for instructions on updating.
Reply
Post: #5
Well you've gotten further up to date so that is good Smile

You are now at `11785_02_characters_instance.sql`. You need to go through the archives folder and pickup from there and start applying the sql updates until you are up to `12937_01_characters_pvpstats.sql`. I think there may be a simpler way to do this with an update script of some sort but I'm not entirely sure how those work.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  database issue - creature_equip_template empty RichardGe 1 804 03-27-2017, 05:33 PM
Last Post: RichardGe
Exclamation [CLASSIC] Playerbot database error? Do I have the wrong classic-db? Wingblade 0 617 02-21-2017, 05:01 PM
Last Post: Wingblade
  [Classic] 1.12.1 scriptdev2 errors MadMax765 1 880 01-16-2017, 07:59 PM
Last Post: vault
Question [TBC] Cmangos TBC where to download the latest full database ft2085267 5 3,006 11-23-2016, 04:55 AM
Last Post: demago
  latest cmangos classic with playerbot compile error darkdandy 2 1,261 10-27-2016, 02:34 PM
Last Post: darkdandy
  [CLASSIC] Is there any portal master npc for 1.12 classic ? rikku 1 1,267 06-26-2016, 05:20 AM
Last Post: Vladskywolf
Brick [CLASSIC] Classic code how to build into x64? wildcat007 3 2,258 05-07-2016, 02:50 PM
Last Post: wildcat007
  Classic - Ubuntu - Make errors nexmorbus 8 3,109 04-18-2016, 11:04 PM
Last Post: nexmorbus
  Updating cmangos classic MaxwellsMama 5 3,623 01-29-2016, 01:54 PM
Last Post: ljwlaji
  [CATA] Character Converter ? WotLK -> Cata Goodsie 1 1,390 11-22-2015, 04:30 PM
Last Post: SADraco

Forum Jump:


Users browsing this thread: 1 Guest(s)

Continued MaNGOS | Return to Top | | Lite (Archive) Mode | RSS Syndication