[HELP] Mangos Database Error

[bianu]

Always when i try make a server, i download a DB file with ~130 mb size value.. and execute like batch file in navicat, but when i try execute Mangosd.exe i get some error in load like:

2007-10-02 22:48:18 Loading Items...
2007-10-02 22:48:19 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 137 fields in sql).

but i've downloaded the same db what is in this topic:

http://forum.ragezone.com/f114/mango...2/index19.html

in answer of t

[MentaL]

[jab416171]

If you can't fix the problem, I'd go with a different repack
or google "Mangos version (your mangos version) sql files"

[Linsys]

From what I understand that error is because your version of Mangos is different then your DB version.

For instance I am running Mangos 4527, and am using SilvermoonRev18. SilvermoonRev18 is made for a lower Mangos version then what I have, specifically Mangos 4479.

So, I install Mangos, then load in the Silvermoon Rev18 SQL, then I look into the updated folder in my Mangos install and will see a lot of updates basically everything with a prefix higher then 4479 needs to be loaded into the Mangos MySQL database as well.

So I had to load in the Silvermoon Rev18 SQL + the following updates:
4480_spell_affect.sql
4481_spell_affect.sql
4482_playercreateinfo.sql
4482_spell_proc_event.sql
4488_db_version.sql
4491_spell_affect.sql
4496_spell_script_target.sql
4498_spell_proc_event.sql
4499_spell_script_target.sql
4501.sql
4503_spell_chain.sql
4503_spell_proc_event.sql
4504_spell_affect.sql
4504_spell_proc_event.sql
4506_spell_learn_spell.sql
4507_quest_template.sql
4510_spell_proc_event.sql
4513_spell_proc_event.sql
4517_spell_affect.sql
4524_spell_proc_event.sql

To find out EXACTLY what Mangos version the Silvermoon databases are relased for can be found on the Project Silvermoon website:
projectsilvermoon.net

It took me a while to find this site, maybe someone should add it to the sticky.