vindir

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

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)

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

NVM , i should read