Fyre

Hi @mvoogd!

Unfortunately, MangosTwo does not support PlayerBots.

There was some work done in the form of a PR on the GitHub Repo - but it was still a work in progress by the author and has not been finished.

Good morning!

I've seen this issue come up a few times in the past. 

It looks like the updates have all been applied to the database, but the db_version hasn't been updated.

Use the following command in your MariaDB:

```
INSERT INTO db_version (version, `structure`, content, description, comment) VALUES(22, 1, 1, 'Release 22', 'Release 22');
```

Then you could be good to go.

When you build the project, it generates a number of tools. Mmaps, VMaps, map extractors/generators/etc.

Are you saying that you're only missing the one? Or do you not have any of them?

I'm recording a list of the status of various quests in M3 for the Twilight Highlands.

---------------------------------------------------------------------

Thanks to help from:

• Crispy81 (Quest Testing/Bug Hunting)

---------------------------------------------------------------------

Total Quests in This Area: UNKNOWN

---------------------------------------------------------------------

[26788] Cementing Our Victory - Working

[27299] Torn Ground - Working - The "Tentacles of Iso'rath" were invisible (no ModelID assigned to them). Added ModelIDs. (Fixed: Commit 8ffdafe)

[27300] Pushing Back - Working 

[27302] Simple Solutions - Working 

[27303] Mercy for the Bound - Working 

[27375] The Weeping Wound - Working

[27376] The Maw of Iso'rath - Broken - Cannot mount gryphon to join the attack.

[27377] Devoured - Broken - Event doesn't start.

[27378] The Worldbreaker - Broken - Cannot join/start the event.

[27379] The Terrors of Iso'rath - Broken - The Shaman cannot be saved, unable to complete quest objectives.

[27380] Nightmare - Broken - Shaman's do not assist or buff player when defeating Brain of Iso'rath. Making quest impossible to complete.

[27485] Warm Welcome - To Be Tested

[27486] Warm Welcome - Broken - NPC doesn't recognize proximity to player, quest cannot be turned in.

[27491] Kor'kron Drop - Broken - Jon-Jon Jellyneck does not have any menu text to complete the quest. (Quest Footage: https://www.youtube.com/watch?v=_8sJwgYAN00

[27494] Move the Mountain - To Be Tested

[27495] Move the Mountain - Broken - Detonating the explosives does nothing, quest doesn't update. No quest giver to hand in.

[27497] Call in the Artillery - Broken - When using the Artillery Flare, it doesn't call an artillery bombardment.

[27503] Up to the Citadel - Broken - Speaking to the Commander does nothing.

[27505] Draconic Mending - Broken - Menders cannot be defended, counter doesn't register any defended menders.

[27506] Life From Death - Broken - Planting seed on a corpse does nothing.

[27508] Far From the Nest - Broken - Eggs cannot be interacted with, cannot be picked up.

[27509] Breach in the Defenses - Broken - Note cannot be planted.

[27583] The Northern Flank - Working

[27584] Blood in the Surf - Working

[27586] Shells on the Sea Shore - Working

[27590] Signal the Attack - Broken - Unable to use the Attack Signal on top of the towers.

[27606] Blast Him! - Semi-working - Use Heth'Jatari Conch (Item: 61928) between the 2 flags on the beach (this works). This should spawn Fathom-Lord Heth'Jatar at the water's edge (he spawns at your location instead of near the water.). There should be incoming mortar barrage that kills him (this is not working). (Quest Footage: https://www.youtube.com/watch?v=JdPHLRAJRQU) // Also, there is already a Fathom-Lord Heth'Jatar spawned on the beach (fixed: Commit d557d5a).

[27609] Four Heads are Better than None - Working

[27688] Distract Them For Me -To Be Tested

[27689] Distract Them For Me - Broken - Target mobs do not exist; not spawned.

[27690] Narkrall, the Drake-Tamer - Working

[27700] Dragon, Unchained - To Be Tested

[27701] Dragon, Unchained - Broken - No chains holding dragon, so cannot complete quest.

[27702] Coup De Grace - To Be Tested

[27703] Coup De Grace - Broken - Not scripted, no dragons battling in the sky. No quest mobs falling to the ground to execute.

[27720] Mr. Goldmine's Wild Ride - Broken - There is no mine cart to ride.

[27744] Rune Ruination - Working - Script added to destroy Rune of Earth. (fixed: https://github.com/mangosthree/database/pull/111)

[27747] Total War - Broken - Thundermar Ale Keg is clickable, but not doing anything else. It should provide a kill credit (NPC: 46551) and cast an explosive spell/graphic (Quest Footage: https://www.youtube.com/watch?v=CYpeW8NCSXU). Possible fix may include: Spawning a NPC 46551 at every Thundermar Ale Keg location (ID: 206195), then gobject should kill the NPC for the kill credit.

[27750] War Forage - Working

[27751] Crushing the Wildhammer - Working

[27787] Skullcrusher the Mountain - To Be Tested

[27788] Skullcrusher the Mountain - Broken - No cinematic to backhand player. Altar's not able to be interreacted with and no scripting prompting player to do so.

[27863] The Crucible of Carnage: The Bloodeye Bruiser! - Broken - Hurp'derp does spawn in the ring but should start at the far end and run towards the center. Gurgthock does not give a spiel about the incoming fight. Killing Hurp'derp does not result in completion. (Quest Footage: https://www.youtube.com/watch?v=o-t3fpwl24E

[27929] Drag 'em Down - Broken - There are Thundermar War Gryphon flying in the air, and you can use the Barbed Flesh Hook but it doesn't pull the gryphon riders to the ground. // Also, there are Thundermar Gryphon Riders floating in the air.

[27945] Paint it Black - Working - ~ 1/20 drop rate. As expected.

[27947] A Vision of Twilight - Working

[27951] We All Must Sacrifice - Working - There were no "Shaman of the Black" spawned in the area, but there are a number spawned in a nearby village (fixed: Commit bef2ec1).

[27954] The Eyes Have It - Semi-working... The quest can be turned in. However, the "Eye of Twilight" gameobject is not spawned - which is required for the next quest (27955).

[27955] Eye Spy - Broken - The "Eye of Twilight" gameobject is not spawned, so the quest cannot be completed.

[28038] Blood in the Highlands - Semi-working... I handed in the quest, but didn't get any gold/reward or even quest completion notification. Something felt incomplete. 

[28041] Bait and Throttle - Working

[28043] How to Maim Your Dragon - Broken - Laying down bait does nothing.

[28092] If the Key Fits - Broken - Not scripted, gob squad doesn't follow you.

[28093] Pressing Forward - Broken - Doesn't recognize player proximity, so can't be handed in. Potentially not having gob squad with the player is the problem.

[28097] The Gates of Grim Batol - Broken - No NPC to hand quest into. Warlord Krogg is not there.

[28108] If the Key Fits - To Be Tested

[28109] Pressing Forward - To Be Tested

[28123] The Demon Chain - Broken - Item cannot be acquired, NPC has no interaction options and cannot be attacked.

[28170] Night Terrors - Broken - Cannot be started. NPC Ucheck has no text or option to switch to spirit realm.

[28171] And The Sky Streaked Red - Broken - Unable to join the assault.

[28176] Following the Young Home - Broken - Eggs cannot be targeted, so they never hatch. Cannot infiltrate lair. Quest cannot be completed.

[28247] Last of Her Kind - Broken - Never lands, and isn't targetable.

[28758] Battle of Life and Death - Broken - Cannot mount drake to do the quest.

[28871] Crushing the Wildhammer - To Be Tested

[28872] Total War - Broken - See [27747] Total War // This should only be available after [27747] Total War is completed, this is a Daily Quest (fixed: Commit 1e22dfb).

[28873] Another Maw to Feed - Working  // This should only be available after [27750] War Forage is completed, this is a Daily Quest (fixed: Commit: 5f53dad).

[28874] Hook 'em High - Broken - See [27929] Drag 'em Down // This should only be available after [27929] Drag 'em Down is completed, this is a Daily Quest (fixed: Commit ebd50d2).

[28875] Bring Down the High Shaman - To Be Tested

[28885] Mr. Goldmine's Wild Ride - Broken - There is no mine cart to ride.

This has been patched.

https://github.com/mangosthree/database/commit/710f247bbc3b98c2e050a3c2706be4b031b11f46

This appears to be related to an event that is triggered at this time of year.

You can type ingame: .event stop 48

And that will resolve it.

I'm going to see what I can do to investigate the reason for the event and hopefully we can apply some fixes.

Excellent - thank you for reporting your issue! And I'm glad the fix worked.
Going to get this fix integrated naturally so it doesn't raise again for people in the future.  

Wish you the best - if you need any other support, reach out via the Forums (or Discord)!

Which strategy did you go with? The first one?

Okay. I see that it failed on 07 now in that screenshot.

I copied this from a Discord post a while ago. But I believe you could try one of the 2 following things:

Add the following line to the failing update .SQL script:
SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');

Or you can also resolve it by turning off strict mode.

Looks like you have Rel 22 03 06. 

And you tried to install the updates at Rel 22 03 08. You need to do Rel 22 03 07 first.

4 hours ago, KillRIde said:

Ok I've got some good news. It works now after deleted and reinstall the database.

wmonitor shows me a lot of info

 

But when I connect using "player" account, I'm directly disconnected and wmonitor stops.

Then I can reconnect but I have a loop on the realmlist. I select my realm and it disconnect and come back to the realmlist

I can add that mangos crash but realm is still running. I don't know where to find logs about this.

Glad that it has progressed!

Are you setting up a locally hosted server or public facing?

If public facing, double check your realmlist table entry in the realmd/auth database to ensure that you've correctly assigned the address. Sometimes users (especially those using heidisql as a GUI) week edit the default value instead of the data value.

Did you pull the database from GitHub? Or from the getmangos website?

1 minute ago, KillRIde said:

I guess I'm close to the issue.

 

How can I apply this?

Yeah you're close but you have to do them in order, you can't just apply the latest one.

See my solution above about merging them into one file, then you can apply that at once.

2 minutes ago, KillRIde said:

And I still have this

 

I also checked to manually update it but I have re121 and 122 not 22

 

That is an L, not a 1.

So you do have Rel22.

But in the first picture it is showing your CHARACTER database as out of date, you're in your world database folder.

When you go into the Updates/Rel22 folder, you can merge the SQL files to one and then run a command to manually import into your database.

cat *.sql > updateall.sql

mariadb -d character0 < updateall.sql

You may need to change the character0 to whatever you called your database.

I'm also doing this from memory on my phone, so there may be syntax errors or missing parameters.

4 minutes ago, KillRIde said:

Actually I can log into the game but the server is offline.

Alright - so then that means that you have properly updated database if it proceeded.
If you can login, but get stuck at "Connected". that likely means that you built the mangosd with OpenSSL 3.0 instead of 1.1.

We just had another member with similar issues yesterday.
Take a look at: 

Meltie walks through how to change to OpenSSL 1.1, and then there are some comments below for how to upgrade gcc IF necessary.

1 hour ago, KillRIde said:

Hi guys,

I'm new here and I tried to run my first server.

Here is the issue I have.

The table `db_version` indicates that your [Character] database does not match the expected structure!

  [A] You have database Version: 22
                      Structure: 2
                        Content: 1
                    Description: Add_field_comments

  [B] The core needs database Version: 22
                            Structure: 4
                              Content: 1
                          Description: Add_Quest_Tracker_Table

You must apply all updates after [A] to [B] to use MaNGOS with this database.
These updates are included in the database/Character/Updates folder.
 

Thanks for the help

Hey!

This is saying that you need to update your databases.
When you do the initial setup/install of the databases, it does not always include the latest updates that have been created.
If you use the InstallDatabases.bat (Windows) or InstallDatabases.sh (Linux), you will see an option "N" that can be used to do database updates.

If you would prefer to manual updates, then you can find them in the "Characters" folder, "Updates", "Rel22" and you'll find all of the ones that you need to update.

Hope that helps!

Good evening!

Was this the guide that you tried to follow: 

 Make sure you read through this sub-post VERY carefully as a missed step can result in failure: 

If so, try deleting the server files and re-cloning them and take another shot at it from scratch.

14 hours ago, Перминов Алексей said:

Thanks for the answer! Yes, this is the repack I use.

The manual approach does not scare me, it scares me more that I don’t understand, but what exactly should I transfer?

I need to transfer characters with their history, i.e. quests, routes, explorations, etc. Items can be restored using .give item or similar.

OK. We have 3 databases.

Characters, realm, world

This is where my knowledge ends. Which tables and how to transfer, unfortunately, I do not know yet.

MaNGOS and vMangos are two different emulators and have different table structures.

It's really not as easy as transferring data from one table to another. You would need to look at the columns for each - determine what are similar and what are different, and then "translating" that information into the other.

MaNGOS world database documentation: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangoszeroworlddb/

MaNGOS realm database documentation: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/realmdb/

MaNGOS character database documentation: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/characterdb/mangoszerochardb/

vMaNGOS wiki: https://github.com/vmangos/wiki

Good evening!

The vmaps/mmaps folders most definitely should have contents. it looks like the script didn't populate the vmaps correctly - and that causes the mmaps not to populate since it's dependent on the former.

Have you taken a look at this tutorial: 

The guide above should walk you through the manual commands for extracting the maps, vmaps, and mmaps. You shouldn't need to restart the whole process, just re-do the maps, vmaps, mmaps portion using the commands in there.

I have not tried installing on Ubuntu 23.04 ARM either - so your mileage may vary on this.

Other possibly helpful guides:

Hello!

If you're using the 1.12 vMaNGOS by Brotalnia, then it may be difficult to migrate to MangosOne.

vMaNGOS is based off of CMangos, which is a fork off of MaNGOS.

There are a number of database differences that will likely require a manual approach and to my knowledge there are no tools out there to convert from one to the other.

My guess is that there would be many tables that would need to be transferred (all of them?) since they all play an important part in the function of a server.

Excellent! Let me know if there's any issues.

If you have Discord, feel free to jump into our channel and I'll be able to assist faster. 🙂

Give this a try.

dump-mangos3-202306100728.sql

This is what I did:
Opened Git Bash: git clone https://github.com/mangosthree/database m3db
(this creates a folder/directory called m3db).

Opened up the directory and ran "InstallDatabases.bat"

Left all of the default settings and clicked "N".

These were the settings that I used:
 

Then it goes through the process of creating the three databases and populating them with the default values.

Then it applied all of the updates for Character : Rel21_05_001 through Rel22_03_002. World DB Rel22_03_003 through Rel 22_04_005.

For GameEvents - it may be an issue with the date stamp and null codes?

This was something that was applied to other MaNGOS cores:: https://github.com/mangos/Realm_DB/pull/5

Not sure if you're using MariaDB instead of MySQL - but I think that helps too.

Tonight I can take a look at that SQL file specifically. Perhaps there's an error in it.

Hello,

You can apply updates manually through your database viewer. The instructions will depend on which one you use specifically. For example, I use DBeaver, and I can right click the database and "Execute Script."

You can also update using command line. When I use Linux, I use a command like: mysql -u mangos -pmangos -d world3 < update_name.sql

Hopefully that helps guide you on the right path.