[Mangos Two] Database problem when starting server

[cloudfox]

hi all,

i download MangosTwo_Develop21_Release_x32_August2015.zip recently and .

i execute ./Database/InstallDatabases.bat .it's all done successfully. but error occured when i start realmd.exe .

it says **SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

query ERROR: Table 'realmd2.db_version' doesn't exist

The table `db_version` in your [Realmd] database is missing or corrupt.**

then i execute ./Database/mangos_full_db.sql into realmd schema

now the error messege is **SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

query ERROR: Unknown column 'structure' in 'field list'

The table `db_version` in your [Realmd] database is missing or corrupt.**

i found this sql is diff from de db_version create sql in columns.

and this is the creation sql **CREATE TABLE `db_version` (

`version` varchar(120) DEFAULT NULL,

`creature_ai_version` varchar(120) DEFAULT NULL,

`cache_id` int(10) DEFAULT '0',

`required_21000_09_quest_9447_incorrect_speech` bit(1) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';**

that sql doesn't have "structure" column

is the dbsql files in zip dont match server3.35?

thanks!

[Talendrys]

The SQL that you are giving is the SQL for the db_version table into the world database. There should be another one for the realm which has another structure.

[cloudfox]

thank you for reply!

but i still can't find db_version's sql for realm in zip.

and i rerun InstallDatabases.bat for twice still no db_version in realm

my os is win10. did i miss some step?

[Shaorin]

did you pull it form Github? try use this one:_

https://github.com/mangostwo/database -b develop21 --recursive

or

https://github.com/mangostwo/database -b master --recursive

this are for the newest core. and you need "Git Shell" to pull it. YOU CANT download it, if you do it whould gt all the find and you need tloof it in the github its canb be down but better to pull. if you get a older source hmmmmm thens its ahrder how this helps

[Corsol]

If you want to try a new installation method try this: https://www.getmangos.eu/community-projects/10482-mangos-universal-installer-post75507.html#post75507

It's my new install tool that can help you from download to game data extraction only pushing some buttons.

Hope to help.

[cloudfox]

If you want to try a new installation method try this: https://www.getmangos.eu/community-projects/10482-mangos-universal-installer-post75507.html#post75507

It's my new install tool that can help you from download to game data extraction only pushing some buttons.

Hope to help.

thank you very much! i will your way

[Blazebot]

hi all,

i download MangosTwo_Develop21_Release_x32_August2015.zip recently and .

i execute ./Database/InstallDatabases.bat .it's all done successfully. but error occured when i start realmd.exe .

it says **SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

query ERROR: Table 'realmd2.db_version' doesn't exist

The table `db_version` in your [Realmd] database is missing or corrupt.**

then i execute ./Database/mangos_full_db.sql into realmd schema

now the error messege is **SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

query ERROR: Unknown column 'structure' in 'field list'

The table `db_version` in your [Realmd] database is missing or corrupt.**

i found this sql is diff from de db_version create sql in columns.

and this is the creation sql **CREATE TABLE `db_version` (

`version` varchar(120) DEFAULT NULL,

`creature_ai_version` varchar(120) DEFAULT NULL,

`cache_id` int(10) DEFAULT '0',

`required_21000_09_quest_9447_incorrect_speech` bit(1) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';**

that sql doesn't have "structure" column

is the dbsql files in zip dont match server3.35?

thanks!

Hello there, I had the same problem with Mangos Zero Server - Develop21 Release, x32 - August 2015. For some reason, it looks like the databases provided in both mangos zero and mangos two, version 0.21 - have errors or they are simply the incorrect versions.

I had to download the correct database starting a Git Bash window and using

Git clone --recursive -b develop21 https://github.com/mangoszero/database

Then I deleted the databases "characters", "mangos" and "realmd" from the mysql console, even though that was probably not needed.

Then I ran the script "InstallDatabases.bat" and it filled the database.

Then I could start the server. The only minor difference to 0.20 is that the maps folders (dbc/maps/vmaps/mmaps) have to be inside the server folder, not inside the sub-folder "data".

[cloudfox]

Hello there, I had the same problem with Mangos Zero Server - Develop21 Release, x32 - August 2015. For some reason, it looks like the databases provided in both mangos zero and mangos two, version 0.21 - have errors or they are simply the incorrect versions.

I had to download the correct database starting a Git Bash window and using

Git clone --recursive -b develop21 https://github.com/mangoszero/database

Then I deleted the databases "characters", "mangos" and "realmd" from the mysql console, even though that was probably not needed.

Then I ran the script "InstallDatabases.bat" and it filled the database.

Then I could start the server. The only minor difference to 0.20 is that the maps folders (dbc/maps/vmaps/mmaps) have to be inside the server folder, not inside the sub-folder "data".

ok, thx very much ! I will try your way to get correct db!