Jump to content

vindir

Members
  • Posts

    4
  • Joined

  • Last visited

    Never
  • Donations

    0.00 GBP 

vindir's Achievements

Newbie

Newbie (1/3)

0

Reputation

  1. @seanb: Ive had the exact same problem. And now i my server is running. What did i do? first: http://unifieddb.svn.sourceforge.net/svnroot/unifieddb/trunk/Updates/0.12.0_additions/ first use these: 388_corepatch_characters_9311_to_9582.sql (here you must select the characters database in sqlyog) 388_corepatch_mangos_9311_to_9582.sql (and here the mangos dtb of course) then use the big 388_updatepack_mangos.sql (selsect the mangos database) the use the next: 389_corepatch_characters_9583_to_9630.sql 389_corepatch_mangos_9583_to_9630.sql and the big one: 389_updatepack_mangos.sql then the next one: 390_corepatch_characters_9631_to_9763.sql 390_corepatch_mangos_9631_to_9763.sql 390_corepatch_realmd_9631_to_9763.sql (select the realmd database of course) big one is next: 390_updatepack_mangos.sql soo now i used the Advanced Creature Intelligence Database for Mangos (Part 16) and nooow: i looked in the database version of mangos and i got UDB 0.12.0 (390) for MaNGOS 9763 with SD2 SQL for rev. 1677 now ive looked in the C:\\Mangos\\sql\\Updates for higher ones (only for mangos) : i scroll down and saw these datas: 9766_01_mangos_spell_proc_event 9767_01_mangos_mangos_string 9767_02_mangos_command 9768_01_mangos_command 9794_01_mangos_mangos_string 9794_02_mangos_command 9803_01_mangos_spell_bonus_data 9826_01_mangos_spell_script_target i used all of these and now it is working. I hope it work for you too. And sry for my bad english.
  2. ok now i have all files updated (i think) know mangosd.exe is compiling untill: "Loading Items... [0 ms] SQL: SELECT MAX(Entry) FROM Item_template [0 ms] SQL: SELECT COUNT(*) FROM item_template [16 ms] SQL: SELECT * FROM item_template Error in Item_template table, probably sql file format was updated (there should be 138 fields in sql)
  3. Me Again. got these error when i start mangos SQL: SELECT required_9590_01_mangos_db_script_string FROM db_version LIMIT 1 query ERROR: Unknown column 'required_9590_01_mangos_db_script_string' in 'field list' Table `db_version` have field `required_8731_01_mangos_creature_template` but expected `required_9590_01_mangos_db_script_string`! Not all sql updates applied? ok i havent updated all databases because when i try to update with the sql in the C:/Mangos/sql/updates i think they don´t update because of this message : Query : ALTER TABLE character_db_version CHANGE COLUMN required_9687_01_characters_character_queststatus_daily required_9692_01_characte... Error Code : 1054 Unknown column 'required_9687_01_characters_character_queststatus_daily' in 'character_db_version' Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 Query : alter table `mail` add column `body` longtext CHARSET utf8 COLLATE utf8_general_ci NULL after `subject` Error Code : 1060 Duplicate column name 'body' Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 this is the error message when i copie the "9010_01_realmd_realmlist.sql" text in the query box and trie to execute the current query with the "realmd" database for example. it happend with every sql in the update folder. Tipps? Thank you
×
×
  • 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