Help Please. Mangos Wiki Installation Outdated???

[animakrayg]

I'm trying to setup my own 2.4.3 MangosOne server and I'm following the guide at the wiki: https://www.getmangos.eu/wiki/Installation%20Guides/Windows/Installing-MaNGOS-on-Windows.md

But I can't get it to work, first off,

git clone git://github.com/mangosone/server.git mangos

cd mangos/src/bindings

git clone git://github.com/mangosone/scripts.git scripts

The "cd mangos/src/bindings" says Directory not found so do i just make a bindings folder in src then do "git bash here"?

Second

We now need to modify the mangos build process to load in the script library

7) edit CMakeLists.txt in this folder

change

# add_subdirectory(scripts)

to

add_subdirectory(scripts)

There is no "# add_subdirectory(scripts)" row in the text file, so I can't change it...

Ive been trying all week at making servers and to no avail have i got one working. If someone could update the wiki or fill me in as to what to do i would greatly appreciate it.

[Olion]

The build system was changed several times in the later months. The manual mentioned below is outdated, use this one please, changing mangoszero to mangosone where appropriate. If you have cloned the repos already, you might continue from the step with "InstallDatabases.bat".

However, I think there is no fully coherent install manual yet.

[animakrayg]

Well i got a little further. Now i am having trouble with installDatabases.bat after doing all the world\setup\fulldb stuff it tries to load the character database character1 then gives me

Error 1031 <HY000> at line 110: Table storage engine for 'game_event_status' doesnt have this option.

Then it moves onto Loading Realm Database realmd

Error 1031 <HY000> at line 25: Table storage engine for 'realmd_dbversion' doesnt have this option

Error 1146 <42S02> at line 1: Table 'realmd.realmlist' doesnt exist

I am lost dont know if thats ok and to just move forward or stop n wait for help. So id rather not goof up and have to start over.

[Olion]

The problem cannot be ignored.

Probably your version of SQL server is not fully compliant to the MySQL mentioned in the manual. Some Windows applications like to install silently an SQL server (usually MSSQL) for their own needs. Ensure that you're using the MySQL server. Different SQL servers may coexist if using different ports; didn't you change the default port number 3306 during MySQL installation? It would be a bad idea to do that because the installation system is mostly not ready for it.

Technically, the following combination of the CREATE TABLE options is not allowed:

ENGINE=InnoDB  ROW_FORMAT=FIXED

However no one of the developers (all using MySQL) bumped into this problem AFAIK. If the problem persists after ensuring you're using MySQL server, then the simplest workaround I see is to remove the ROW_FORMAT=FIXED option from the lines with ENGINE=InnoDB manually with an editor for realmLoadDB.sql and characterLoadDB.sql files.

[animakrayg]

Was i supposed to change the 3306? i have seen some people running it on 3310 didnt know if it was important.

ok i got passed that i think. Now i am at the part with scripts. I have no bindings folder for some reason. So i made one and git bashed here the

git clone --recursive mangosArchives/MangosOne_scripts_old · GitHub. ok this changed for some reason.

what am i supposed to do here?

and this when i try to build scriptvc120.sln

Error 1 error MSB6006: "cmd.exe" exited with code 3. C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V120\Microsoft.CppCommon.targets 170 5 ScriptDev2

[animakrayg]

All right! So Olion instead of making a TBC server i decided to make a Vanilla server. Now i have downloaded the database and server files.

I am using the guide you linked me. https://www.getmangos.eu/wiki/Installation%20Guides/Windows/MaNGOS%20Zero%20Rel20.md

I get to installdatabases.bat and everything runs smooth until it gets to this

Creating Character Database character0

Loading Character Database character0

ERROR 1031 <HY000> at line 1423: Table Storage engine for 'game_event_status' doesnt have this option

Creating Realm Database realmd

Loading Realm Database realmd

Error 1031 <HY000> at line 25: Table storage engine for realm_db_version' doesnt have this option

I dunno how to fix it.

Also I am using MySql Community Server 5.7 if that helps.

[Olion]

Also I am using MySql Community Server 5.7 if that helps.

Omg where did you get it? The latest stable release of MySQL Community Server is 5.6.25. If using cutting-edge (ye more "development") software releases, be prepared for a lot of unpredictable issues with no help from community just due to the negligible number of users.

So, the question, why my MySQL server of the version:

Ver 5.1.55-community for Win32 on ia32 (MySQL Community Server (GPL))

does accept the undocumented option combination Engine=InnoDB ROW_FORMAT=FIXED, while yours (5.7) seemingly does not, should be routed to the MySQL developers. I proposed already a way to fix this.

If the problem persists after ensuring you're using MySQL server, then the simplest workaround I see is to remove the ROW_FORMAT=FIXED option from the lines with ENGINE=InnoDB manually with an editor for realmLoadDB.sql and characterLoadDB.sql files.

[animakrayg]

I downloaded the version your using now and am gonna test it.

also i got 5.7 from the DL link in the Windows Installation guide.

[animakrayg]

OK everything is working so far i just need the extractors. I have the .sh files but no extractors.

[wolverine]

With all due respect to the staff, but if a guide is out of date, why are we holding on to it? Or is this a case of update it if you feel that strongly about it?

[Olion]

also i got 5.7 from the DL link in the Windows Installation guide.

Not really. The link leads to the stable 5.6 version. However, it will not help probably: MySQL developer's move to a stricter conventions is expectable.

OK everything is working so far i just need the extractors. I have the .sh files but no extractors.

IF you have the core repo, then build it. In the release20 branch, there should be BuildTools VS solution file (see win/ folder) allowing to build the extractors only. Also you could build everything with BuildEverything solution.

With all due respect to the staff, but if a guide is out of date, why are we holding on to it? Or is this a case of update it if you feel that strongly about it?

The brief answer is a usual one for open-sources, "please do it better if you can".

A longer answer: several systems were changed substantially this year, in particular, the build system - two or three times. Each "staff" member has a very limited power as the result of an individual mix of incompetency and limited time spent for the project. The "team", unfortunately, does not exist as such.

[Foereaper]

More specifically on the guides:

As olion mentioned, several changes have been done, especially to the build system, over the past year or so. The reason we cannot remove the "old" guides is because those guides are still applicable to the "stable" releases, even though they are possibly not applicable to the development branches. Another issue is the new build system is still under works to be transferred to the rest of the core versions, and more changes could possibly arise during the implementation of the said build system. Thus, we'd end up with several guides covering several different versions with minor or major differences, instead of waiting for all the versions to catch up and then writing a proper guide that works across all versions. That's pretty much why the guides are in the state they are in, for now they'll be a mess until the build system has been rolled out to all the different versions and the development branches have been tested and marked stable.