KGTM
Members-
Posts
2 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
KGTM's Achievements
Newbie (1/3)
0
Reputation
-
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.
-
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?
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®