[Mangos Zero] Instance triggers not working. Console fails to load the conditions.

[ull3r]

Hey all.

I've set up a server with the newest dev build (rev 21000) august 2015 with playerbots and everything seems to run perfectly fine. The playerbots are kinda derpy, but it's better than none.

A friend of mine was testing it out, just for fun, and we wanted to go into an instance with one of the higher level playerbots, so we teamed up with him, made him follow us and went into Orgrimmar to enter Ragefire Chasm.

When we ran into the portal, all that happened was us hitting the invisible wall. No loading screen or anything.

I've spent the last 2 hours trying to figure out what is happened. The trigger point is there and i can easily teleport to it, but it simply won't port us to the instance.

I tried booting up the server again and i noticed an error, while loading AreaTrigger definitions;

Loading AreaTrigger definitions...
SQL: SELECT id, required_level, required_item, required_item2, required_quest_done, target_map, target_position_x, target_position_y, target_position_z, target_orientation FROM areatrigger_teleport
query ERROR: Unknown column 'required_level' in 'field list'
=>> Loaded 0 area trigger teleport definitions======= 100%

My initial thought was some kind of error in my database, but i simply can't find the little bugger.

I hope you guys can help me out

- Ull3R

[ull3r]

Ah, i've found a fix. A pretty simple one, too!

I simply went into the sql database and manually added the catagories "required_level, required_item, required_item2, required_quest_done" to the areatrigger_teleport table.

It was a random shot, but it seems to have done the trick

I'll provide a picture to others who might run into the same issue.

Note: I'm using a portable version of HeidiSQL for sql editing. Great stuff!

as you can see, i've added the required_level, required_item, required_item2 and required_quest_done to the list. i could probably have changed the datatype, but the SMALLINT setting seems to work just fine, so i'll just leave it at that.

[madmax]

Just a random thought, but did you run all the updates in the download for the database?

And you are only using the database that comes with the download?

It might be hedisql thats causing the issue but not sure, would try again with sqlyog. This issue does not exist for me with the download.

[ull3r]

Just a random thought, but did you run all the updates in the download for the database?

And you are only using the database that comes with the download?

It might be hedisql thats causing the issue but not sure, would try again with sqlyog. This issue does not exist for me with the download.

I used the one that comes with the download and updated to the dev database. I did install all of the updates, but i had lots of errors and warnings whilst doing it.

Anyway, this fix i posted above worked just fine

It might've worked with another SQL editor, but to be honest, i was too lazy to go get another one

[madmax]

I used the one that comes with the download and updated to the dev database. I did install all of the updates, but i had lots of errors and warnings whilst doing it.

Anyway, this fix i posted above worked just fine

It might've worked with another SQL editor, but to be honest, i was too lazy to go get another one

What do you mean updated to the dev database? It only works with the DB and updates it came with...

[ull3r]

What do you mean updated to the dev database? It only works with the DB and updates it came with...

hm, it might've actually been that one.. i'm fairly new to this thing

I got the MangosZero_PlayerBot_Develop21_Release_x32_August2015 zip file and database-develop21 zip file.

Both downloaded from the git page.

I installed the updates from database-develop21, in the correct order.

[madmax]

The download at https://www.getmangos.eu/mangos-zero/download-564-mangos-zero-server-ai-playerbots-develop21-release-x32-august-2015-a.html

This contains a database folder inside it with everything needed. What I'm trying to figure out is did you get just that single file or did you also download the database separately from the github?

If you did the first option then you should be fine and it was a SQL client issue. If the second then you are using a database newer and not intended for the server core and will likely cause issues.

[ull3r]

The download at https://www.getmangos.eu/mangos-zero/download-564-mangos-zero-server-ai-playerbots-develop21-release-x32-august-2015-a.html

This contains a database folder inside it with everything needed. What I'm trying to figure out is did you get just that single file or did you also download the database separately from the github?

If you did the first option then you should be fine and it was a SQL client issue. If the second then you are using a database newer and not intended for the server core and will likely cause issues.

Huh, thats weird. I thought i had to apply the dev database to get completely up to date. Oh well, everything works now.. Except for my teleportation npc, but that's not a major issue

[madmax]

OK since this is resolved I will close this thread.