[Mangos Zero] Visual Studio Express 2010 compile issue

[kiwi girl]

Thanks Foereaper for your help in the other thread. I have managed to get to the compiling stage. I have performed this in debug mode, as suggested, and two errors have occurred. Out of the following files that I should see:

lua_scripts folder

ace.dll

ahbot.conf.dist

libmysql.dll

mangosd.conf.dist

mangosd.exe

realmd.conf.dist

realmd.exe

I only have the folder, ace.dll, and ahbot.conf.dist. I also have the three pdb files. After adding the git path to my Windows environment, this is the first stage at which I am encountering an issue. I don't know what happened with libmysql.dll as I can't find it listed in the Visual Studio output. However, the message says that 1 was skipped (see bottom of this message), so maybe it was that.

The underlying error seems to be the same for the mangosd and realmd. When I try to post the errors, I keep getting a posting error that I have 16 images in my message. I assume it's picking up on a character combination, as I have tried Notepad++ to strip anything underlying from what I am trying to post, with no success. I've attached the build output instead.

new 1.txt

[Foereaper]

Which architecture of MySQL do you have installed? 32 bit or 64 bit? And are you compiling in 64 or 32 bit mode? According to your above log, your MySQL architecture does not match the architecture you are attempting to compile in.

[kiwi girl]

Thanks, that was exactly the problem. The 32-bit MySQL installer installed both 32- and 64-bit, which I thought was not going to be an issue. It was. I followed the custom installation directions here How To Install MySQL Server 5.6 on Windows 7 Development Machine and redid my install and compile, which has now worked fine.

[Foereaper]

Glad to hear, if you bump into any other issues, feel free to ask for help

[kiwi girl]

Thanks, almost done! I cannot connect to the server. I have assumed I need to run realmd.exe and mangosd.exe before I run WOW.exe so that the environment is set up.

I'm having the following issue with both executables, which seems to be caused by a missing database version:

realm-list.log content:

2015-08-30 15:32:07 21000 [realm-daemon]

2015-08-30 15:32:07 <Ctrl-C> to stop.

2015-08-30 15:32:07 Using configuration file realmd.conf.

2015-08-30 15:32:07 Login Database total connections: 2

2015-08-30 15:32:07 MySQL client library: 5.6.26

2015-08-30 15:32:07 MySQL server ver: 5.6.26-log

2015-08-30 15:32:07 MySQL client library: 5.6.26

2015-08-30 15:32:07 MySQL server ver: 5.6.26-log

2015-08-30 15:32:07 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2015-08-30 15:32:07 ERROR:query ERROR: Table 'realmd.db_version' doesn't exist

2015-08-30 15:32:07 ERROR:The table `db_version` in your [Realmd] database is missing or corrupt.

2015-08-30 15:32:07 ERROR:

2015-08-30 15:32:07 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence!

2015-08-30 15:32:07 ERROR:

2015-08-30 15:32:07 ERROR: You need database Version: 21

2015-08-30 15:32:07 ERROR: Structure: 1

2015-08-30 15:32:07 ERROR: Content: 0

2015-08-30 15:32:07 ERROR: Description: revision_refactor

2015-08-30 15:32:07 ERROR:

2015-08-30 15:32:07 ERROR:Please verify your database location or your database integrity.

world-database.log

2015-08-30 15:17:38 SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2015-08-30 15:17:38 query ERROR: Unknown column 'structure' in 'field list'

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

2015-08-30 15:17:38

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

2015-08-30 15:17:38

2015-08-30 15:17:38 You need database Version: 21

2015-08-30 15:17:38 Structure: 1

2015-08-30 15:17:38 Content: 0

2015-08-30 15:17:38 Description: revision_refactor

2015-08-30 15:17:38

2015-08-30 15:17:38 Please verify your database location or your database integrity.

2015-08-30 15:28:03 SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2015-08-30 15:28:03 query ERROR: Unknown column 'structure' in 'field list'

2015-08-30 15:28:03 The table `db_version` in your [World] database is missing or corrupt.

2015-08-30 15:28:03

2015-08-30 15:28:03 [A] You have database Version: MaNGOS can not verify your database version or its existence!

2015-08-30 15:28:03

2015-08-30 15:28:03 You need database Version: 21

2015-08-30 15:28:03 Structure: 1

2015-08-30 15:28:03 Content: 0

2015-08-30 15:28:03 Description: revision_refactor

2015-08-30 15:28:03

2015-08-30 15:28:03 Please verify your database location or your database integrity.

world-server.log

2015-08-30 15:28:03 21000 [world-daemon]

2015-08-30 15:28:03 <Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: https://getmangos.eu / // -_) '_/ _ \

Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/

2015-08-30 15:28:03 Using configuration file mangosd.conf.

2015-08-30 15:28:03 World Database total connections: 2

2015-08-30 15:28:03 MySQL client library: 5.6.26

2015-08-30 15:28:03 MySQL server ver: 5.6.26-log

2015-08-30 15:28:03 MySQL client library: 5.6.26

2015-08-30 15:28:03 MySQL server ver: 5.6.26-log

2015-08-30 15:28:03 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1

2015-08-30 15:28:03 ERROR:query ERROR: Unknown column 'structure' in 'field list'

2015-08-30 15:28:03 ERROR:The table `db_version` in your [World] database is missing or corrupt.

2015-08-30 15:28:03 ERROR:

2015-08-30 15:28:03 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence!

2015-08-30 15:28:03 ERROR:

2015-08-30 15:28:03 ERROR: You need database Version: 21

2015-08-30 15:28:03 ERROR: Structure: 1

2015-08-30 15:28:03 ERROR: Content: 0

2015-08-30 15:28:03 ERROR: Description: revision_refactor

2015-08-30 15:28:03 ERROR:

2015-08-30 15:28:03 ERROR:Please verify your database location or your database integrity.

[Foereaper]

This means your database is out of date. You need to run the database updates located inside the database folder you cloned previously. We recently switched to a new revisioning system, so the updates you need to run are:

World:

- 21000_18_Update_for_quest_502_and_5203

- 21000_19_Fix_Kobald_Laborers

- 21000_20_dbdocs_update

- 21000_21_script_binding_fixes

- 21000_22_db_version

Character:

- 21000_01_warden_action

- 21000_02_db_version

Realm:

- 20150816_01_db_version

Apply the updates in the specific order.

[kiwi girl]

Thanks again for your help. I've applied the updates and have now moved onto the next issue, which is missing maps - no vmaps or mmaps files were constructed with ExtractResources.sh, although the other folders constructed fine. I didn't realise at the time that the mmaps and vmaps folders were empty. I have been running movemap-generator.exe in order to population the mmaps folder as neither ExtractResources.sh nor MoveMapGen.sh worked for me.

[madmax]

Pretty sure you need to run ExtractResources.sh and select what you want to make.