World crash with Aug 13 peq dump

[Huppy]

This is not related to my past issue, but tested it out 3 times today to make sure, before I posted this. It's only happening with the peq daily dump of Aug 13 (today's). I have been performing these steps 100's of times when sourcing in a fresh DB.

1. Source in peqbeta.sql
2. Source in player_tables.sql
3. Source in load_login.sql
4. Run shared_memory
5. Run world.exe for updates ........world crashes.

If I repeat these steps with any previous dumps, (including Aug 12th), it works fine. Everything I have, (server related) is fully updated. VS, source code,(aug 11), etc. The problem is isolated to that Aug 13 daily dump. This was in the crash log, if it's of any use. Only thing that stood out to me:
[08-13-2019 :: 13:08:28] [Crash] e:\source test\common\database.cpp (1058 ): Database::LoadZoneNames
[08-13-2019 :: 13:08:28] [Crash] e:\source test\world\net.cpp (319): main

[Akkadius]

Originally Posted by Huppy

This is not related to my past issue, but tested it out 3 times today to make sure, before I posted this. It's only happening with the peq daily dump of Aug 13 (today's). I have been performing these steps 100's of times when sourcing in a fresh DB.

1. Source in peqbeta.sql
2. Source in player_tables.sql
3. Source in load_login.sql
4. Run shared_memory
5. Run world.exe for updates ........world crashes.

If I repeat these steps with any previous dumps, (including Aug 12th), it works fine. Everything I have, (server related) is fully updated. VS, source code,(aug 11), etc. The problem is isolated to that Aug 13 daily dump. This was in the crash log, if it's of any use. Only thing that stood out to me:
[08-13-2019 :: 13:08:28] [Crash] e:\source test\common\database.cpp (1058 ): Database::LoadZoneNames
[08-13-2019 :: 13:08:28] [Crash] e:\source test\world\net.cpp (319): main

Very interesting, I imported a ton of DoN zones last night and we had a zone entry that was null that must have made it into the dump

Run this

delete from zone where short_name is null;

These were the zones imported

https://docs.google.com/spreadsheets...it?usp=sharing

I also recorded the import process incase we need to go back and see which one we imported from whether it was Norrath Keepers or Dark Reign

https://www.youtube.com/watch?v=1ZSPkBp6uqQ

[Akkadius]

I've also just re-ran the dump which includes deleting the errant zone entry

[Huppy]

Oh, good, at least we know what was going on now, Thank You.

[Huppy]

I see, the ID for that null zone was 5922