yes i tried it, still had the same issue
yes i tried it, still had the same issue
Updated the guide to use the C(ontinued)MaNGOS core. Everything is still the same, just changed the GIT address.
If you use the original MaNGOS core (Not CMaNGOS), you no longer need to install SD2 (I don't know if that's also true for CMaNGOS). MaNGOS now packages SD2 inside the core. I do believe SD2-ACID is also no longer needed as well.
I am having a little issue with the vmaps.
Compiled the 3 .exes as release ( C:\mangos\contrib\extractor, C:\mangos\contrib\vmap_assembler, C:\mangos\contrib\vmap_extractor\win), moved them to the wow folder and called vmapExtractor and this is the output.
C:\Program Files (x86)\World of Warcraft>vmapExtractor.exe
Extract for VMAP004. Beginning work ....
Game path: Data\
Found locale 'enGB'
Adding data files from locale directories.
Scanning patch levels from data directory.
Scanning patch levels from locale directories.
Locale: enGB
Opening Data\enGB/locale-enGB.MPQ
Opening Data\enGB/expansion-locale-enGB.MPQ
Error opening archive 'Data\enGB/expansion-locale-enGB.MPQ': Does file really exist?
Opening Data\enGB/lichking-locale-enGB.MPQ
Error opening archive 'Data\enGB/lichking-locale-enGB.MPQ': Does file really exist?
Opening Data\common.MPQ
Error opening archive 'Data\common.MPQ': Does file really exist?
Opening Data\common-2.MPQ
Error opening archive 'Data\common-2.MPQ': Does file really exist?
Opening Data\expansion.MPQ
Error opening archive 'Data\expansion.MPQ': Does file really exist?
Opening Data\lichking.MPQ
Error opening archive 'Data\lichking.MPQ': Does file really exist?
Read LiquidType.dbc file...Fatal error: Invalid LiquidType.dbc file format!
C:\Program Files (x86)\World of Warcraft>md vmaps
A subdirectory or file vmaps already exists.
C:\Program Files (x86)\World of Warcraft>vmap_assembler.exe buildings vmaps
using buildings as source directory and writing output to vmaps
Could not read dir_bin file!
exit with errors
C:\Program Files (x86)\World of Warcraft>pause
Press any key to continue . . .
Just to make sure, is your client v3.3.5a? I've only ever seen those errors when either trying to extract from the wrong client or a corrupt client.
Ye I seem to have a newer version.
Last edited by optimadam; 09-06-14 at 11:46 PM.
I am having the same issue as previous users --
------ Rebuild All started: Project: ScriptDev2, Configuration: Release Win32 ------
Extracting revision
precompiled.cpp
c:\mangos-git\src\bindings\scriptdev2\include\sc_creature.h(134): error C2061: syntax error : identifier 'AIEventType'
c:\mangos-git\src\bindings\scriptdev2\include\sc_creature.h(73): error C3668: 'ScriptedAI::HealedBy' : method with override specifier 'override' did not override any base class methods
c:\mangos-git\src\bindings\scriptdev2\include\sc_creature.h(134): error C3668: 'ScriptedAI::ReceiveAIEvent' : method with override specifier 'override' did not override any base class methods
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
Tried redownloading with Git; tried VC++ 2008 and 2010 (vcxx90 for 2008 and vcxxx100 for 2010) with same results; rebuild, rebooted, etc... anyone help?
Sorry it took me so long to get back to you guys about the SD2 problem. It appears MaNGOS (Not CMaNGOS) is no longer compatible with ScriptDev2. Use the scripts library in the GIT repo for the core. Note that some of the MaNGOS cores now have the scripts already built-in to the core, so you do not need to independently download and compile the scripts.
Last edited by Darkicon; 29-01-15 at 12:14 AM.
Hi, I'm joined this WoW mangos community yesterday (in Ragezone I'm old lol) I want to update this guide, and put some images, maybe a video but patience with the video because and not a good english speaker lol, so any suggestions for the new guide are welcome!
I followed your guides step by step,but something went wrong.
When I executed the characters.sql files,it gave me these messages:
[Err] 1031 - Table storage engine for 'group_member' doesn't have this option
[Err] /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
and excuting the realmd.sql files:
[Err] 1031 - Table storage engine for 'realmd_db_version' doesn't have this option
[Err] -- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (x86_64)
this seems like it is for debian,not windows.Where should I get the realmd.sql for windows 7?
By the way,I used mangosthree.
I tried download mangos.sql,characters.sql,and realmd.sql in cmangos/mangos-cata/sql/base.
the realmd.sql part test no problem,but the characters.sql is still have problems.
[Err] 1031 - Table storage engine for 'group_member' doesn't have this option
[Err] /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
Last edited by fayfay111020201; 20-12-15 at 02:48 PM.
Sorry for the late reply, fayfay. Not sure if you got your problem fixed or not, but likely your problem was a bad release. They usually get fixed within a few hours of release. Sometimes a dev will fix one thing and break another or forget something, causing issues like yours. Usually fetching an older release or waiting until the devs fix what they broke will alleviate errors.
So, a couple of things:
1.) Navicat fails to import sql files if there is no database for the sql file. Right clicking and executing the SQL file is met with an almost instant query termination with the following error "Failed to Execute SQL. No Database." So you need to create the database now.
2.) When executing these SQL files, mangos and character will have well over 500+ errors. Even though it says it's unsuccessful, you need to close your connection to the database object then reconnect to the database object and you will see the tables populate. At this time I am unable to determine if this is an issue or not because I am unable to complete the process due to the third issue...
3.) The guide calls for a batch file to run that, well, doesn't exist. Under the "Populating Databases" section, your instructions state to "Run install_Windows.bat" However no directory is mentioned. After searching my C:\ drive for *.bat and sorting by name, I have confirmed that the batch file you're referencing does not exist. Was this step part of the CMangos installation?
Usually these guides are pretty comprehensive however they MUST be followed step by step. When you start referencing files that don't exist or leave out steps, you're going to cause the process to come to a screeching halt. Where is that install_Windows.bat file supposed to be located? What is it for?
I am going to just continue the process. I have bigger fish to fry (like finding a working client) and if I have to blow the entire server away, whatever.
- - - Updated - - -
So I am unable to populate the mangos database due to the tables that caused those 500+ errors being missing. Attempting to populate the database ends immediately.
Five tables populated. This cannot be normal. There seems to be an issue with these SQL files however I cannot tell you what it is. I only know how this process is supposed to look when everything works correctly. Executing SQL files are not supposed to throw that many errors.
Last edited by Pagefault404; 03-10-16 at 03:20 PM.
1 and 2: Try executing "sql\create_mysql.sql" first. That might solve the problem. Also try executing the SQL file on the individual database instead of the root connection, as the SQL files may no longer point directly to the appropriate database.
3. MaNGOS has changed the name and location of this file. It's now in "\_tools\MaNGOSdb_Installer.bat." But before running that, run "make_full_db.bat" in that same folder.
MaNGOSdb_installer.bat is simply a utility that automatically populates your world database rather than having to do it through an SQL client, and make_full_db.bat simply creates a single SQL file from all the tables in \_full_db\. And unfortunately sometimes things get changed around so my guide needs to be tweaked a bit. That was really fun back a couple of years ago when MaNGOS split and things got really messy.
If you have anymore problems, post back, I'll get back to you as soon as I can.
Dude. That batch file. That was the single piece I needed. My Database installation is continuing at the moment. I will let you know if I run into another snag
Isn't it easier to have the system read an ini file for the ip address and other location instead of recompiling? Saves the admin time from recompiling.
Reply With Quote