Weird Zone Crash

[Envisage]

I've done a lot of editing so installing a fresh db isn't really an option so please help. :)

Basically can't zone into nektulos. After a heavy edit didn't change anything out of the ordinary it worked fine even after a few server reboots. Then bam can't zone in and booted to login screen. zone.exe doesn't crash.

Things I have already tried. Moving the quests folder. Turning off hold zone. A bunch of other things but nothing has worked.

Here is the only clue I have to go on me and my fiance have been googeling for over 4 hours now trying to figure it out. If anyone has a clue about this please, pretty please help. All other zones work. Also nothing in the logs about errors.


[Debug] [WORLD__CLIENT] Manapana: Attempting autobootup of nektulos (25:0)
[Debug] [WORLD__ZONE] [5] [] Setting to 'nektulos' (25:0)
[Debug] [WORLD__CLIENT] Manapana: Entering zone nektulos (25:0)
[Debug] [WORLD__ZONE] [5] [nektulos] Broadcasting a world time update
[Debug] [WORLD__ZONE] [5] [nektulos] Setting to 'nektulos' (25:0)
[Debug] [WORLD__CLIENT] Manapana: Sending client to zone nektulos (25:0) at 192.
168.1.31:7004
[Debug] [WORLD__CLIENT] Manapana: Client disconnected (not active in process)
[Debug] [WORLD__ZONELIST] Removing zoneserver #5 at :7004
[Debug] [WORLD__ZONELIST] Hold Zones mode is ON - rebooting lost zone

[lerxst2112]

Post the stack trace from the zone log. You'll need to build with debug info if you haven't already.

[Envisage]

zone.exe isn't crashing. I wish that was the problem.

[NatedogEZ]

Does your client have the correct Nektulos zone files? If not... you wont be able to zone in without crashing.

[Envisage]

Yeah, all zone files are correct. It was loading fine even after the huge edit we did. Then it just poofed.

Basically what happens is after you login from char select it doesn't goto a loading screen now. It just kicks you back to login. Also tried adding the zone manually from another zone in game it was still failing with no errors.

[lerxst2112]

What's in the zone log?

[Envisage]

zone log
-------------------------------------------------------------------------
[07.27. - 23:22:38] Starting Log: logs/eqemu_zone_1876.log
[07.27. - 23:22:38] Using database 'peq2' at 127.0.0.1:3306
[07.27. - 23:22:57] Booting nektulos (25:0)
[07.27. - 23:22:57] Loading spawn conditions...
[07.27. - 23:22:57] Loading static zone points...
[07.27. - 23:22:57] Loading spawn groups...
[07.27. - 23:22:57] Loading spawn2 points...
[07.27. - 23:22:57] Loading player corpses...
[07.27. - 23:22:57] Loading traps...
[07.27. - 23:22:57] Loading adventure flavor text...
[07.27. - 23:22:57] Loading ground spawns...
[07.27. - 23:22:57] Loading Ground Spawns from DB...
[07.27. - 23:22:57] Loading World Objects from DB...
[07.27. - 23:22:57] Loading Objects from DB...
[07.27. - 23:22:57] Loading doors for nektulos ...
[07.27. - 23:22:57] Loading Doors from database...
[07.27. - 23:22:57] Loading AA information...
[07.27. - 23:22:58] Loading AA Effects...
[07.27. - 23:22:58] Loaded 1042 AA Effects.
[07.27. - 23:22:58] Loading Merchant Lists...
[07.27. - 23:22:58] Loading Temporary Merchant Lists...
[07.27. - 23:22:58] Successfully loaded Zone Config.
[07.27. - 23:22:58] Loading timezone data...
[07.27. - 23:22:58] Init Finished: ZoneID = 25, Time Offset = 0
---------------------------------------------
[07.27. - 23:22:58] Starting Log: logs/eqemu_zone_1876.log
[07.27. - 23:22:58] ---- Zone server nektulos, listening on port:7004 ----
[07.27. - 23:22:58] Zone Bootup: nektulos (25: 0)

error log which is typical or has been for me.
--------------------------------------------------------
[07.27. - 22:22:05] Starting Log: logs/eqemu_error_zone_1792.log
[07.27. - 22:22:05] Error in Zone::LoadTickItems: SELECT it_itemid, it_chance, it_level, it_qglobal, it_bagslot FROM item_tick (#1146: Table 'peq2.item_tick' doesn't exist)
[07.27. - 22:22:05] Path File ./Maps/nektulos.path not found.

[KLS]

Building with lua?

[Envisage]

Just a standard setup haven't made any source changes yet. Debugging is enabled however.

http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServerSetupGuide

Followed that to the letter so we could work on the db before we made changes to the source.

Looks like we are just going to use a backup copy of the db and loose only a little work thankfully I backup everyday. But I would still like some kind of clue as to what caused this. Seen a few posts with the same error but no answers yet.

[Envisage]

Well we have traced the error after editing again, this time we did it in steps instead of per npc. When we modified the loot tables, and would 0 out certain items or a whole table thats when the zone would no longer come up.

Right now we are removing probabilities on all the loot tables that were set to 0. So we'll see if that fixes it.

[Envisage]

UPDATE FIXED! :)

For anyone else having this issue. If you 0 out an entire loot table you have to set the probability to 0. If you dont it makes the zone try to load said loot over and over and the zone will not load and timeout/crash. Don't know if this is a bug or what. But that is the fix.

The odd thing was after a revamp on crushbone we did the same thing with no issue. Once we did nektulos thats when the issue popped up it seems more like a bug to me. With probability at 100 and all the loot in the table set to 0% seemed to tick it off.

[sorvani]

Nektulos has more than one version. Version 0 is classic and Version 1 is the revamped one. It is also a permanent instance. Any of these things could interplay with it.