MaNGOS Two Database Issues

[arlyon]

Basically the basic database works (from fresh install without any NPCs, items etc.) but as soon as I try to install a full database it comes up with a db_version problem (the log I'm posting is from the Project Silvermoon DB)

2013-02-26 11:55:15 ERROR:SQL: SELECT required_12370_02_mangos_npc_vendor_template FROM db_version LIMIT 1
2013-02-26 11:55:15 ERROR:query ERROR: Unknown column 'required_12370_02_mangos_npc_vendor_template' in 'field list'
2013-02-26 11:55:15 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date!
2013-02-26 11:55:15 ERROR:
2013-02-26 11:55:15 ERROR:  [A] You have: --> `12279_01_mangos_creature_template.sql`
2013-02-26 11:55:15 ERROR:
2013-02-26 11:55:15 ERROR:  [b] You need: --> `12370_02_mangos_npc_vendor_template.sql`
2013-02-26 11:55:15 ERROR:
2013-02-26 11:55:15 ERROR:You must apply all updates after [A] to [b] to use mangos with this database.
2013-02-26 11:55:15 ERROR:These updates are included in the sql/updates folder.
2013-02-26 11:55:15 ERROR:Please read the included [README] in sql/updates for instructions on updating.

I've tried to apply the update specified but to no avail. I truly am completely lost with this.. Any help is much appreciated! -arlyon

[Christian Schamara]

i cant see a problem the core have the right sql rev https://github.com/mangostwo/server/blob/master/src/shared/revision_sql.h

db its all ok and updates all ok

[japtenks]

In your sql editor/reader (in my case I'm using hedi) load the sql file 12370_02_mangos_npc_vendor_template.sql.

It should open in a query box. Then execute the sql query.

It should update your db_version table, and mangos should load.