Zone.exe has stopped working on server launch
 

I tried a new pull/recompile tonight and I got this error: Zone.exe has stopped working. I looked in the logs and I did see a MySQL error in one of the zone log files. It stated:

[MySQL Error] 1146: Table 'peq.commands' doesn't exist SELECT command, access FROM commands.

I have run the required SQL for changing the command table to commands_old and I have the current table command_settings but peq.commands does NOT exist in my db.

This error keeps repeating itself over and over until I kill the server. My build from 11/23/15 works fine with no errors and I got no errors on the compile from tonight either. Using VS 2012 on 32bit version.

Any ideas what might cause this?

Thanks,
Mortow

hmm have you tried doing a fresh pull for the whole build and compiling from that one? Might be a missing sql or something that got missed.

I have not tried that. I have always just done a git pull on my source folder, rerun cmake then compile. I have been letting Akka's updater pull and install all the required updates. I may try a complete fresh pull tomorrow evening. Thanks for info.

The code base should be up-to-date for using the new `command_settings` table.


[Building on what Nightrider84 said..]

If you're getting that message, you may not have the latest source code, compiled binaries (copied?) .. or maybe you added custom code that overwrote the new?


The table `commands` should not exist any longer in your database.

That table was renamed to `commands_old` and the new `command_settings` table should be active.


If any of those conditions don't exist, post back and we'll try to figure out what's going on :)

Commands table has been renamed to command_old and the new table command_settings is there. The only custom code.I have is in the pets.cpp file. I added different models for the beastlord pets. Should I just delete everything from my source folder and do a git clone instead of just doing a git pull?

More likely the individual tables in command_settings didn't populate correctly. I'd suggest doing a git clone and getting a whole new source. There should be around 253 rows in your command_settings table.

Also the pet.cpp folder having custom code in it shouldn't make much of a difference. I use something similar in my server aswell.

I will give that a try tonight after work and will post back the results. Thanks.

There is a 'tool' called TortoiseGit that adds context menu functionality to windows..if you're not already using it.

From there, you could select 'show log' to see what revision your code is at.

Ok, I moved my source directory and created a new one under my EQ directory. I then did a git clone, as per the wiki guide. I redownloaded the dependencies and placed them in the correct folder, reran cmake and recompiled. It had no errors on the compile but when I launch the server, I still get the dialogue box popping up that zone.exe has stopped. I checked the command_settings table and it has 253 rows. I even left out my custom pet.cpp file and compiled with unmodified source code. Not sure what I am doing wrong but my old binaries work fine. I checked the date on them and they are from 11/03/15.

If you're not getting any zone logs or crash logs for this, it's most likely a run-time error specific to program start-up.


Try running the eqemu_update.pl script manually and selecting the windows server dll's option.

That should grab 3 needed library files for the current code.


Let us know if that helps.

There are no crash logs at all and the zone logs don't show any errors. I ran the updater manually and grabbed the 3 lib files, still having the same problem. I appreciate the suggestions though.

Would it help any to rerun cmake and change the error logging to 10? I currently have it set at 5.

I, myself, run it at 12..but, that's strictly a developmental environment.


You might check as to whether you have logging disabled in cmake (it is by default..)

Errors and crashes should still be caught, however...


If it comes to a last-ditch effort, you could always upgrade to VS2013 with Update 5 and make sure that your local repo is clean and up-to-date.


Tbh, though, it's really hard to trouble-shoot without a more clear issue.

If the crash pop-up has an option for reviewing details, you might try looking through that..otherwise, we'll have to keep our ears open.

I installed vs2013 for windows desktop. I set the error logging to 10 and made sure loggings was checked (which it was already). I reran cmake after making sure the source pull was up to date then used vs2013 to recompile. No luck, I still get the error message zone.exe has stopped working and closed. This pops up over and over until I stop the server. There are no crash logs in the folder and the zone logs only show the above error and not all of them do. Here is one that does.

I'd be interested in knowing why that is reporting like that..

Doing a grepwin of my source doesn't show any hits for that query text.