[Mangos Zero] New bug with latest Mangos Update. Unable to verify database version or its existence

[magic]

Hello,

After successfully installing MangosZero half a dozen times over this month, the latest update has brought with it some new issues.

Logs:

2015-08-31 08:06:17 SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2015-08-31 08:06:17 query ERROR: Unknown column 'structure' in 'field list'

2015-08-31 08:06:17 The table `db_version` in your [World] database is missing or corrupt.

2015-08-31 08:06:17

2015-08-31 08:06:17 [A] You have database Version: MaNGOS can not verify your database version or its existence!

2015-08-31 08:06:17

2015-08-31 08:06:17 You need database Version: 21

2015-08-31 08:06:17 Structure: 1

2015-08-31 08:06:17 Content: 0

2015-08-31 08:06:17 Description: revision_refactor

I can confirm I am using Database Version 21, and that the database does indeed exist. Furthermore updates have been applied.

Has anyone else encountered this issue?

Is there a known workaround or fix?

Thanks for you're help!

Regards,

Magic

[madmax]

Hey,

You need to run 21000_22_db_version.sql on the world database. This will update the version table.

[magic]

Hello,

Resolved, simply forgot to refresh before checking db versions

Magic

[Necrovoice]

I am having the same issue but with realmd

[Foereaper]

Run all the realmd updates

[Deepdishks]

Feeling a bit dumb, but can you please point me how can i update dbs

[Necrovoice]

According to the DB, realmd is updated to the most recent version listed in madmax's prebuilt files[TWO]. 20150722_01_realmcharacters_remove_constraint. But thanks for the tip

[madmax]

Fairly sure you need this https://github.com/mangostwo/database/commit/82730547902d6604c4d6ac977d256faadd3ac64c

I'll update the zip shortly.

[Necrovoice]

That did it my friend. Thanks

[robreg]

yeah it was a bit confusing when I had installed it from scratched. I didn't know why I got a error on unable to verified database version. and I wasn't sure if I'm suppose to applied all the update files and some files tells me that I am missing a column or something. But anyway. after I installed db_version.sql on character, realm, and world. Game to seems to be running.