|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Windows Servers Support forum for Windows EQEMu users. |
12-14-2015, 11:41 PM
|
 |
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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
|
12-14-2015, 11:46 PM
|
 |
Discordant
|
|
Join Date: Aug 2010
Location: Colorado
Posts: 410
|
|
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.
|
12-14-2015, 11:54 PM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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.
|
12-14-2015, 11:58 PM
|
 |
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
Quote:
|
[MySQL Error] 1146: Table 'peq.commands' doesn't exist SELECT command, access FROM commands.
|
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 
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
12-15-2015, 08:32 AM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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?
|
12-15-2015, 11:58 AM
|
|
Discordant
|
|
Join Date: Aug 2010
Location: Colorado
Posts: 410
|
|
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.
|
12-15-2015, 12:56 PM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
I will give that a try tonight after work and will post back the results. Thanks.
|
12-15-2015, 03:38 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
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.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
12-15-2015, 10:24 PM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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.
|
12-15-2015, 11:16 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
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.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
12-16-2015, 12:15 AM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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.
|
12-16-2015, 12:00 PM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
Would it help any to rerun cmake and change the error logging to 10? I currently have it set at 5.
|
12-16-2015, 03:41 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
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.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
 |
|
 |
12-16-2015, 10:37 PM
|
|
Hill Giant
|
|
Join Date: Apr 2013
Posts: 215
|
|
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.
Code:
[12-11-2015 :: 22:31:11] [Zone Server] CURRENT_VERSION: 1.1.3
[12-11-2015 :: 22:31:11] [Zone Server] Mapping Incoming Opcodes
[12-11-2015 :: 22:31:11] [Zone Server] Loading Variables
[12-11-2015 :: 22:31:11] [Zone Server] Loading zone names
[12-11-2015 :: 22:31:11] [Zone Server] Loading items
[12-11-2015 :: 22:31:11] [Zone Server] Loading npc faction lists
[12-11-2015 :: 22:31:11] [Zone Server] Loading loot tables
[12-11-2015 :: 22:31:11] [Zone Server] Loading skill caps
[12-11-2015 :: 22:31:11] [Zone Server] Loading spells
[12-11-2015 :: 22:31:11] [Zone Server] Loading base data
[12-11-2015 :: 22:31:11] [Zone Server] Loading guilds
[12-11-2015 :: 22:31:11] [Zone Server] Loading factions
[12-11-2015 :: 22:31:11] [Zone Server] Loading titles
[12-11-2015 :: 22:31:11] [Zone Server] Loading tributes
[12-11-2015 :: 22:31:12] [Zone Server] Loading corpse timers
[12-11-2015 :: 22:31:12] [Zone Server] Loading commands
[12-11-2015 :: 22:31:12] [MySQL Error] 1146: Table 'peq.commands' doesn't exist
SELECT command, access FROM commands
[12-11-2015 :: 22:31:12] [Zone Server] 252 commands loaded
[12-11-2015 :: 22:31:12] [Zone Server] Loaded default rule set 'default'
[12-11-2015 :: 22:31:12] [Zone Server] Loading Perl Event Export Settings...
[12-11-2015 :: 22:31:12] [Zone Server] Loading quests
[12-11-2015 :: 22:31:12] [Quests] Tying perl output to eqemu logs
[12-11-2015 :: 22:31:12] [Quests] Creating EQEmuIO=HASH(0xda8ce7c)
[12-11-2015 :: 22:31:12] [Quests] Creating EQEmuIO=HASH(0xda82314)
[12-11-2015 :: 22:31:12] [Quests] Loading perlemb plugins.
[12-11-2015 :: 22:31:12] [Quests] Unquoted string "false" may clash with future reserved word at plugins/Expeditions.pl line 375.
[12-11-2015 :: 22:31:12] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[12-11-2015 :: 22:31:12] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[12-11-2015 :: 22:31:12] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[12-11-2015 :: 22:31:12] [Quests] Subroutine CalcDestFromHeading redefined at plugins/path_tools.pl line 221.
[12-11-2015 :: 22:31:12] [Quests] "my" variable $Item1 masks earlier declaration in same scope at plugins/quest_handin.pl line 19.
[12-11-2015 :: 22:31:12] [Quests] "my" variable $Item2 masks earlier declaration in same scope at plugins/quest_handin.pl line 21.
[12-11-2015 :: 22:31:12] [Quests] "my" variable $Item3 masks earlier declaration in same scope at plugins/quest_handin.pl line 23.
[12-11-2015 :: 22:31:12] [Quests] "my" variable $Item4 masks earlier declaration in same scope at plugins/quest_handin.pl line 25.
[12-11-2015 :: 22:31:12] [Quests] Subroutine RandomRange redefined at plugins/random_utils.pl line 3.
[12-11-2015 :: 22:31:12] [Quests] Subroutine moelib_spawn_block redefined at plugins/spawn_utils.pl line 2.
[12-11-2015 :: 22:31:12] [Quests] Subroutine moelib_spawn_block_center redefined at plugins/spawn_utils.pl line 23.
[12-11-2015 :: 22:31:12] [Quests] Subroutine moelib_spawn_circle redefined at plugins/spawn_utils.pl line 45.
[12-11-2015 :: 22:31:12] [Quests] Subroutine GetMaxLoSDistFromHeading redefined at plugins/spawn_utils.pl line 71.
[12-11-2015 :: 22:31:12] [Quests] Subroutine FaceBestHeading redefined at plugins/spawn_utils.pl line 134.
[12-11-2015 :: 22:31:12] [Quests] Subroutine HeadingToShortestLoS redefined at plugins/spawn_utils.pl line 204.
[12-11-2015 :: 22:31:12] [Quests] Subroutine MoveAwayFromWall redefined at plugins/spawn_utils.pl line 268.
[12-11-2015 :: 22:31:12] [Quests] Subroutine MoveToFirstBestZ redefined at plugins/spawn_utils.pl line 340.
[12-11-2015 :: 22:31:12] [Quests] Subroutine SpawnZone redefined at plugins/spawn_utils.pl line 373.
[12-11-2015 :: 22:31:12] [Quests] Subroutine GetReverseHeading redefined at plugins/spawn_utils.pl line 456.
[12-11-2015 :: 22:31:12] [Quests] Subroutine ConvertHeadingToDegrees redefined at plugins/spawn_utils.pl line 477.
[12-11-2015 :: 22:31:12] [Quests] Subroutine vtell redefined at plugins/voicetell.pl line 6.
[12-11-2015 :: 22:31:12] [Quests] Subroutine Autovtell redefined at plugins/voicetell.pl line 56.
[12-11-2015 :: 22:31:12] [Zone Server] Entering sleep mode
[12-11-2015 :: 22:31:12] [Zone Server] Starting EQ Network server on port 7021
[12-16-2015 :: 21:02:58] [Zone Server] CURRENT_VERSION: 1.1.3
[12-16-2015 :: 21:02:58] [Zone Server] Mapping Incoming Opcodes
[12-16-2015 :: 21:02:58] [Zone Server] Loading Variables
[12-16-2015 :: 21:02:58] [Zone Server] Loading zone names
[12-16-2015 :: 21:02:58] [Zone Server] Loading items
[12-16-2015 :: 21:02:58] [Zone Server] Loading npc faction lists
[12-16-2015 :: 21:02:58] [Zone Server] Loading loot tables
[12-16-2015 :: 21:02:58] [Zone Server] Loading skill caps
[12-16-2015 :: 21:02:58] [Zone Server] Loading spells
[12-16-2015 :: 21:02:58] [Zone Server] Loading base data
[12-16-2015 :: 21:02:58] [Zone Server] Loading guilds
[12-16-2015 :: 21:02:58] [Zone Server] Loading factions
[12-16-2015 :: 21:02:58] [Zone Server] Loading titles
[12-16-2015 :: 21:02:58] [Zone Server] Loading tributes
[12-16-2015 :: 21:02:58] [Zone Server] Loading corpse timers
[12-16-2015 :: 21:02:58] [Zone Server] Loading commands
[12-16-2015 :: 21:02:58] [Zone Server] 253 commands loaded
[12-16-2015 :: 21:02:58] [Zone Server] Loaded default rule set 'default'
[12-16-2015 :: 21:02:58] [Zone Server] Loading Perl Event Export Settings...
[12-16-2015 :: 21:02:58] [Zone Server] Loading quests
[12-16-2015 :: 21:02:58] [Quests] Tying perl output to eqemu logs
[12-16-2015 :: 21:02:58] [Quests] Creating EQEmuIO=HASH(0xd95ce1c)
[12-16-2015 :: 21:02:58] [Quests] Creating EQEmuIO=HASH(0xd95243c)
[12-16-2015 :: 21:02:58] [Quests] Loading perlemb plugins.
[12-16-2015 :: 21:02:58] [Quests] Unquoted string "false" may clash with future reserved word at plugins/Expeditions.pl line 375.
[12-16-2015 :: 21:02:58] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[12-16-2015 :: 21:02:58] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[12-16-2015 :: 21:02:58] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[12-16-2015 :: 21:02:59] [Quests] Subroutine CalcDestFromHeading redefined at plugins/path_tools.pl line 221.
[12-16-2015 :: 21:02:59] [Quests] "my" variable $Item1 masks earlier declaration in same scope at plugins/quest_handin.pl line 19.
[12-16-2015 :: 21:02:59] [Quests] "my" variable $Item2 masks earlier declaration in same scope at plugins/quest_handin.pl line 21.
[12-16-2015 :: 21:02:59] [Quests] "my" variable $Item3 masks earlier declaration in same scope at plugins/quest_handin.pl line 23.
[12-16-2015 :: 21:02:59] [Quests] "my" variable $Item4 masks earlier declaration in same scope at plugins/quest_handin.pl line 25.
[12-16-2015 :: 21:02:59] [Quests] Subroutine RandomRange redefined at plugins/random_utils.pl line 3.
[12-16-2015 :: 21:02:59] [Quests] Subroutine moelib_spawn_block redefined at plugins/spawn_utils.pl line 2.
[12-16-2015 :: 21:02:59] [Quests] Subroutine moelib_spawn_block_center redefined at plugins/spawn_utils.pl line 23.
[12-16-2015 :: 21:02:59] [Quests] Subroutine moelib_spawn_circle redefined at plugins/spawn_utils.pl line 45.
[12-16-2015 :: 21:02:59] [Quests] Subroutine GetMaxLoSDistFromHeading redefined at plugins/spawn_utils.pl line 71.
[12-16-2015 :: 21:02:59] [Quests] Subroutine FaceBestHeading redefined at plugins/spawn_utils.pl line 134.
[12-16-2015 :: 21:02:59] [Quests] Subroutine HeadingToShortestLoS redefined at plugins/spawn_utils.pl line 204.
[12-16-2015 :: 21:02:59] [Quests] Subroutine MoveAwayFromWall redefined at plugins/spawn_utils.pl line 268.
[12-16-2015 :: 21:02:59] [Quests] Subroutine MoveToFirstBestZ redefined at plugins/spawn_utils.pl line 340.
[12-16-2015 :: 21:02:59] [Quests] Subroutine SpawnZone redefined at plugins/spawn_utils.pl line 373.
[12-16-2015 :: 21:02:59] [Quests] Subroutine GetReverseHeading redefined at plugins/spawn_utils.pl line 456.
[12-16-2015 :: 21:02:59] [Quests] Subroutine ConvertHeadingToDegrees redefined at plugins/spawn_utils.pl line 477.
[12-16-2015 :: 21:02:59] [Quests] Subroutine vtell redefined at plugins/voicetell.pl line 6.
[12-16-2015 :: 21:02:59] [Quests] Subroutine Autovtell redefined at plugins/voicetell.pl line 56.
[12-16-2015 :: 21:02:59] [Status] Booting tutorialb (189:0)
[12-16-2015 :: 21:02:59] [Status] Loading spawn conditions...
[12-16-2015 :: 21:02:59] [Status] Loading static zone points...
[12-16-2015 :: 21:02:59] [Status] Loading spawn groups...
[12-16-2015 :: 21:02:59] [Status] Loading spawn2 points...
[12-16-2015 :: 21:02:59] [Status] Loading player corpses...
[12-16-2015 :: 21:02:59] [Status] Loading traps...
[12-16-2015 :: 21:02:59] [Status] Loading adventure flavor text...
[12-16-2015 :: 21:02:59] [Status] Loading ground spawns...
[12-16-2015 :: 21:02:59] [Status] Loading Ground Spawns from DB...
[12-16-2015 :: 21:02:59] [Status] Loading World Objects from DB...
[12-16-2015 :: 21:02:59] [Status] Loading Objects from DB...
[12-16-2015 :: 21:02:59] [Status] Flushing old respawn timers...
[12-16-2015 :: 21:02:59] [Status] Loading doors for tutorialb ...
[12-16-2015 :: 21:02:59] [Status] Loading Doors from database...
[12-16-2015 :: 21:02:59] [Status] Loading Alternate Advancement Data...
[12-16-2015 :: 21:02:59] [Status] Loading Alternate Advancement Abilities...
[12-16-2015 :: 21:02:59] [Status] Loaded 1567 Alternate Advancement Abilities
[12-16-2015 :: 21:02:59] [Status] Loading Alternate Advancement Ability Ranks...
[12-16-2015 :: 21:02:59] [Status] Loaded 6651 Alternate Advancement Ability Ranks
[12-16-2015 :: 21:02:59] [Status] Loading Alternate Advancement Ability Rank Effects...
[12-16-2015 :: 21:02:59] [Status] Loaded Alternate Advancement Ability Rank Effects
[12-16-2015 :: 21:02:59] [Status] Loading Alternate Advancement Ability Rank Prereqs...
[12-16-2015 :: 21:02:59] [Status] Loaded Alternate Advancement Ability Rank Prereqs
[12-16-2015 :: 21:02:59] [Status] Processing Alternate Advancement Data...
[12-16-2015 :: 21:02:59] [Status] Loaded Alternate Advancement Data
[12-16-2015 :: 21:02:59] [Status] Loading Merchant Lists...
[12-16-2015 :: 21:02:59] [Status] Loading Temporary Merchant Lists...
[12-16-2015 :: 21:02:59] [Status] Successfully loaded Zone Config.
[12-16-2015 :: 21:02:59] [Status] Loading timezone data...
[12-16-2015 :: 21:02:59] [Status] Init Finished: ZoneID = 189, Time Offset = 0
[12-16-2015 :: 21:03:05] [Status] Path File Header: Version 2, PathNodes 373
[12-16-2015 :: 21:03:05] [Status] Path File ./Maps/tutorialb.path loaded.
[12-16-2015 :: 21:03:05] [Normal] ---- Zone server tutorialb, listening on port:7052 ----
[12-16-2015 :: 21:03:05] [Status] Zone Bootup: tutorialb (189: 0)
|
 |
|
 |
12-16-2015, 11:27 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
Quote:
[12-11-2015 :: 22:31:12] [Zone Server] Loading commands
[12-11-2015 :: 22:31:12] [MySQL Error] 1146: Table 'peq.commands' doesn't exist
SELECT command, access FROM commands
[12-11-2015 :: 22:31:12] [Zone Server] 252 commands loaded
|
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.
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:07 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
