Zone.exe Crash
 

I had my server up and running well, then out of nowhere I'm getting zone.exe crashes left and right.

This happened while I was attempting to add a buffing NPC to poknowledge. Can someone tell me what is wrong and how to fix this please?

You definitely need to provide more information as to what you are/were doing.

From that stack trace, it looks like something is wrong with a crt calling convention...

Do you have all of the appropriate run-time libraries installed?


I wrote that code myself and have never had that error come up during any of my server up-time, nor has it been reported by the many people who run bots servers.

I was trying to add an NPC to the Plane of Knowledge that you could Hail, then respond to him and he would cast some buffs on you.

Rather than using typical player buffs, I was attempting to have him cast a couple of buffs that appeared to be unused but were in the same vein as player spells. (I was trying to edit them to have ridiculous durations.)

The two spells, specifically, were Endeavor (10152) and Refraction of Light (8464).

When I had the NPC casting them, there was something wrong. He would put a type of Engulfing Darkness and Bard HP/Mana Regen song on my character that would last 27 minutes. And I could click them both off, despite the Engulfing Darkness type one being red and damaging my character.

I tried for a little while to figure out what was wrong with the buffs because I didn't see anything different with them than with typical player spells... Then I tried copying them in the database and giving them new spell ID numbers. After I did that, I updated the ID numbers in my NPC's quest to buff.

After that, I tried rebooting the server and found out that I couldn't zone into PoK. That's when I checked everything and realized that zone.exe was now crashing every time it started. Naturally, I tried undoing everything that I'd just done, but it didn't fix anything.

Everything was working flawlessly before this.

Bots were trying to load your custom spell(s) and crashed the zone.

If that's the case...

Not real sure as to why this would cause a crash: https://github.com/EQEmu/Server/blob...mmand.cpp#L128

Spells should have valid entries up to SPDAT_RECORDS..unless, I'm missing something.

Did you re-run shared_memory?

I didn't know to do that. Running shared_memory.exe appears to have fixed the problem. Thank you!

Okay, so the server is running again, but now I'm experiencing a new problem.

The guild window no longer works and upon logging into the game, I'm getting...

If someone can guide me in fixing this, I should be all set.

Run this query and report the results:

EDIT:

Curious notation..
No space between c and LEFT...

The lack of a space was probably because I typed that one by hand, from eyeballing it in the EQ chat window.

I did find the ref at: https://github.com/EQEmu/Server/blob..._base.cpp#L869

..and it does appear to be correct.


You don't appear to have any views in place..much less the proper ones.

And since those are missing, you're probably missing the functions as well.


I hate giving manual instructions because of the many nuances involved..and they're not things easily scripted...

But, assuming that everything else is up-to-date..you can try running this: http://wiki.eqemulator.org/i?Module=...Paste=V9CISaf7

I tried the copy and paste method and this is what it gave me:

What does
..show?

It looks like you haven't had bots going at all yet..if so...


Run eqemu_server.pl manually..

Go into database, then run the drop bots schema..

Exit back to main..

And re-run the setup bots schema..

..and see what that gives you.

I had bots running on the server a couple days ago. I tried removing them with the prompts like you said, but it looks like that had trouble. Reinstalling afterward didn't fix the error.

Is there a way to backup all of the changes I've made to the server and reinstall? So far I've added a few new race/class combos and a couple of starter quest NPC/Guildmasters. (Nothing too major.)

Try this...


Manually delete each table that is prefixed with 'bot' - skipping any table that gives an error, then go back through and try deleting those.

There is an order to do it in and it is applied in the drop_bots.sql file.

I'm not sure if the heal rotation tables are in the 'drop' file..so, that may be part of the problem.

Essentially, you do not want any 'bots' tables in your database - though, you can leave the views and functions since they are cleared out by the install script.


Finally, change the value of `bots_version` to '0' in the `db_version` table.


You shouldn't need to re-install everything to get a working server :/


EDIT: Once you manually remove all traces of bots, the installer should work properly.

I just ran a non-bot windows server using the update script to install bots.
It went smoothly, but something else I did AFTER I installed the bots, I ran
check_bot_db_updates and it pulled a couple in. All works fine.

This is the updates it grabbed afterwards:

I did everything you specified. I deleted all of the files and ran the installer. Bots are working on my server, but that error isn't going away and I can't use the guild window. (It won't update and show characters.)

Where does this table come from?

Edit: Also, the bots version was already set to 0.

It also won't let me create new bots because it says it can't check name availability... So I'm assuming that missing file had something to do with that.

The 'vw_bot_character_mobs' is (supposed to be) in the Views part of your database.
That is seperate from 'Tables' You should have a total of 5 tables under Views.
If any of the vw's are missing, I am not sure why the installer didn't insert them for you.
I tested this whole bot installer from the script and it all worked fine for me on a win 7 box.
Did you try running any and all database updates in the update script ?

You can manually run the queries found here: https://github.com/EQEmu/Server/tree.../bots/required
(You should have them locally in your source code folder..just match up the paths.)

They should be installed in the order listed in the manifest - starting with 9000: https://github.com/EQEmu/Server/blob...e_manifest.txt


There are a couple of other changes that need to be applied as well..but, until you get all of those in, without errors, we won't address that.