Jump to content

KGTM

Members
  • Posts

    2
  • Joined

  • Last visited

    Never
  • Donations

    0.00 GBP 

KGTM's Achievements

Newbie

Newbie (1/3)

0

Reputation

  1. I've used mangos sql file dumps for "characters" and "realmd". Then i've updated as long SQLYog stated no problems in the batch (from UDB updates). But i will try to update as long it is needed, and i will report something. Thks.
  2. Hello everybody. Long time no see since mangos was at "mangosproject". Well i wanted to try out Wrath, so i came and did the usual, you know. Complie. Config. etc.. But then it came the SQL problems as usual. Note: No compiler errors and warnings. Win XP SP3 fully updated. Nothing else then mangos stuff in the HD. Conf files in the right place and properly configured. Map extraction OK. WoW + BC + Wrath 3.13 MySql server 5. Well configured and communicates with Mangos. --- Then it came the database. Well i've created the default databases (mangos, realmd, characters). Then according to the manual i had to run the sql dump files in the Mangos Dir/sql directory. So i did. Everything ok. Then i went to unifieddb to get the latest core (mangos) sql dump file. Mangos Core SQL Dump: "UDB_0.11.5_Core_7681_SD2_1012.sql" I've updated my mangos db with it. No problems. Then came the update part, updating the databases with sql dump files "related to my core". List of files in the update folder: Folder name: "0.11.5_additions" "380_corepatch_characters_7682_to_7894.sql" "380_corepatch_mangos_7682_to_7894.sql" "380_corepatch_realmd_7682_to_7894.sql" "380_updatepack_mangos.sql" "381_corepatch_characters_7895_to_8029.sql" "381_corepatch_mangos_7895_to_8029.sql" "381_corepatch_realmd_7895_to_8029.sql" "381_updatepack_mangos.sql" "382_corepatch_characters_8030_to_8280.sql" "382_corepatch_mangos_8030_to_8280.sql" "382_updatepack_mangos.sql" Updates to realmd and characters databases no problems. But mangos as some problems. This what i did for mangos db: I've created mangos in mysql server. [OK] Used "mangos.sql" in the Mangos Source folder to do a update from sql dump file to my mangos DB. [OK] Updated my Mangos DB with the Core Sql Dump. [OK] "UDB_0.11.5_Core_7681_SD2_1012.sql" Then i updated the mangos DB with: "380_corepatch_mangos_7682_to_7894.sql". [OK] Then: "380_updatepack_mangos.sql" [ERROR] After many tries i managed to get a "solution" for the update. I've deleted content from mangos DB. And i skipped the part where i should use the "mangos.sql" form the SQL directory in the Mangos Source Folder. Then updated my mangos with the core. Then the update order: "380_corepatch_mangos_7682_to_7894.sql" "380_updatepack_mangos.sql" "381_corepatch_mangos_7895_to_8029.sql" "381_updatepack_mangos.sql" "382_corepatch_mangos_8030_to_8280.sql" "382_updatepack_mangos.sql" That way, just by skipping the mangos.sql file the update process worked with no problems (at least SQLyog didn't repported any). Then i was all happy. I have started realmd.exe [OK] Then mangos.exe [issues] // Reported some SQL problems but mangos.exe was running. Created my account on the game. Started W*W; Login; Then i ways creating a new char, give her a name, the "Create". He reported sucess. And went to the My Chars View. And none char was there. I've restarted W*W and still no char there. I went to mangos and he reported some SQL errors, he could find the table "characters.character_battleground_data"; Here goes the DBErrors.log: 2009-08-24 21:55:47 SQL: SELECT version, creature_ai_version, cache_id FROM db_version LIMIT 1 2009-08-24 21:55:47 query ERROR: Unknown column 'cache_id' in 'field list' 2009-08-24 21:55:48 SQL: UPDATE character_battleground_data SET instance_id = 0 2009-08-24 21:55:48 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist 2009-08-24 21:56:36 Table `achievement_criteria_data` not have expected data for criteria (Entry: 3680 Type: 76) for achievement 1157. 2009-08-24 21:56:36 Table `achievement_criteria_data` not have expected data for criteria (Entry: 9798 Type: 76) for achievement 2772. 2009-08-24 21:57:46 SQL: DELETE FROM character_battleground_data WHERE guid='1' 2009-08-24 21:57:46 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist 2009-08-24 21:57:56 SQL: UPDATE character_battleground_data SET instance_id = 0 2009-08-24 21:57:56 SQL ERROR: Table 'characters.character_battleground_data' doesn't exist Any suggestions?
×
×
  • 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