jwh1981

Very nice, Thanks again for the help I'm going a full level 1-70 playthrough and I'll report any other bugs in new posts.

I found a way to get them both working. Heres what I did:

1. I rode the working tram to Iron Forge (the farthest one)

2. Once I made it to Iron Forge, the second tram (which would be the closest one in Stormwind) appeared and I rode it back to Stormwind.

3. Once I made it back to Stormwind, I waited and confirmed that both work now.

That appears to have primed whatever logic controls them.

I spoke too soon I found that in the Stormwind Deeprun Tram, only the farthest tram appears and works. The closes to the entrance does not appear at all. Very strange.

This was fixed by @antz in

@antz I updated the core and database. I can confirm gameobjects are present in the system (I checked mailboxes, treasure chests, and milly's grapes). Thank you for all that you do:)

The deep run trams are also missing on MangosOne. I am now on Master (server commit: bb0c091)

Edit: I walked through the tram from Stormwind to Ironforge just to make sure

I am on the current master branch of MangosOne (server commit 94859bd and database commit 8f41391). I am using Debian 10 x86_64 with MariaDB 10.3.22. I found that some items in the world are missing, such as mailboxes and treasure chests. An example of this is the mailbox in Goldshire or the treasure chests in Echo Ridge next to Northshire Abbey. I will note any other world items missing as I find them, unless of course its a fix that would correct all of them.

Thank you for your help

I am on the current master branch of MangosOne (commit 94859bd) and database (commit ac9dcf7). In the human starting area (Northshire Abbey), the baskets of grapes do not appear for the Milly's Harvest quest after I accept the quest from Milly to retrieve them from the fields occupied by the Defias Brotherhood.

I have already extracted a fresh setup of resources to rule out that as the issue. I am on Debian 10 x86_64 with MariaDB 10.3.22. I have been using the getmangos.sh script for installing.

I wanted to add that this issue (for mangostwo) also occurs on mangosone, in case its related to this issue?

I wanted to add that this also appears to be an issue on mangosone. I tried multiple times to resolve this on Debian 10. I tried both MariaDB 10.3 and MySQL 5.7 (separate VM's) and also regenerating my data files a few times. I wanted to add to this post before I submitted another bug: Milly's Harvest (quest) appears to be broken and her grapes do not appear in the vineyard in the human starting zone (Northshire Abbey). Could that be a symptom of this? Thank you!

Hmmmm there doesn't appear to be a way to directly cancel your account. I would suggest emailing the admin(s) at [email protected] for help.

Actually I figured it out on my own. I just needed to apply: z1807_xxxxx_01_mangos_spell_proc_event.sql and z1809_xxxxx_01_mangos_spell_affect.sql. Issue resolved

Hello all,

I was able to install Mangos Zero (and have it fully working) on a test machine last week (Ubuntu 10.04 32bit). However, I've been trying since yesterday to get it up and running on a faster computer. The compilation of Mangos Zero, ScriptDev0, and the Zero Database (including a successful import into mysql) work properly. However, after doing the usual edits to the config files, the maps/dbc/vmaps stuff, etc., I get the following error after trying to start mangos-worldd:

[0 ms] SQL: SET CHARACTER SET `utf8`
Connected to MySQL database [email protected]:3306/zp_world
MySQL client library: 5.1.41
MySQL server ver: 5.1.41-3ubuntu12.10
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
SQL: SELECT required_z1809_xxxxx_01_mangos_spell_affect_event FROM db_version LIMIT 1
query ERROR: Unknown column 'required_z1809_xxxxx_01_mangos_spell_affect_event' in 'field list'
[0 ms] SQL: SELECT * FROM db_version LIMIT 1
The table `db_version` in your [WORLD] database indicates that this database is out of date!

 [A] You have: --> `z1765_xxxxx_01_mangos_spell_affect.sql`

 [b] You need: --> `z1809_xxxxx_01_mangos_spell_affect_event.sql`

You must apply all updates after [A] to [b] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.

I have googled 'z1809_xxxxx_01_mangos_spell_affect_event.sql' but no results were found. I also confirmed that z1809_xxxxx_01_mangos_spell_affect_event.sql does not exist in server\\sql\\updates. Instead, z1809_xxxxx_01_mangos_spell_affect.sql exists.

Has anyone seen this issue before? If so, could I please have some info on how to resolve it?